Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a column of figures, maximum of 7 numbers in total and need to find
the first positive number in the column, negatives will always be shown first and are dependant on other calculations. Some of the last cells may be blank depending on the periods in the term ie 1. -10 2. -1 3. 10 4. 5 5. 80 6. 7. Should return 10 as the first positive in the list Is there a built in fucnction I can use to do this? Many thanks for any help Sheila D |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to find what number in Column A is not included in Column B? | Excel Discussion (Misc queries) | |||
Find first positive value in a column | Excel Discussion (Misc queries) | |||
Find max Row() number for a value in column | Excel Worksheet Functions | |||
FIND POSITIVE VALUE | Excel Discussion (Misc queries) | |||
How do I find the first value in a column less than a number? | Excel Worksheet Functions |