weeping fig
New Member
- Joined
- Jan 4, 2014
- Messages
- 3
Hi new to Excel but enjoying it.
I have a column of numbers, say in column "A" that increase to a maximum and then starts to decrease.
I have Identified the cell that has the maximum number in the column using the Max function and this number is then updated in another part of my spreadsheet but I need to identify what row number this is.
What formula would show this?
Many thanks
I have a column of numbers, say in column "A" that increase to a maximum and then starts to decrease.
I have Identified the cell that has the maximum number in the column using the Max function and this number is then updated in another part of my spreadsheet but I need to identify what row number this is.
What formula would show this?
Many thanks