Thread: Finding the first and last entry in a column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JohnUK JohnUK is offline
external usenet poster
  
Posts: 173
Default Finding the first and last entry in a column
In a column (array $B$7:$B$54) I have entered all numbers 1 from B12:B24. I
would like a formula which recognises the first entry (on B12) and returns a
value from A12.

Also I would like a formula which recognises the last entry of the entries
(onB24) and returns the value from A24.
Reply With QuoteReply With Quote