View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen Karen is offline
external usenet poster
 
Posts: 447
Default formula to relate last cell of info to another cell

I have created a spreadsheet that shows ppls attendance as the 'y' axis and
the date they attended as the 'x' axis. I want to create a formula that will
tell me the last date they attended.

Im guessing that it would have to start in the row for the person that I am
looking at, search for the last cell with informaion and then cross reference
to the date above.... I hope that makes since....

Help please!!!