Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have an column of numbers, e.g.
a1 - 0.03 a2 - 0.17 a3 - 0.35 a4 - 0.54 a5 - 0.67 a6 - 0.83 a7 - 1.00 What I'd like is a formula that returns the cell reference of the first number in the column that is above a specific number (say, 0.5). Can anyone suggest a formula that would achieve this? Many thanks, Geoff. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Converting column & row numbers to a cell reference | Excel Worksheet Functions | |||
Find a empty cell in next column | Excel Discussion (Misc queries) | |||
up to 7 functions? | Excel Worksheet Functions |