Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |