| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find a negative number in a range
I'm trying to search through a range of numbers for any numbers that are
negative. The range is a hidden column, and I need to determine if there is a negative number anywhere in the column. Is there a function to do so? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find a negative number in a range
Hi Scott
One way =COUNTIF(D:D,"<0") where D is your hidden column. This will give you a count of the negative numbers, but not tell you where they are within the column. Regards Roger Govier Scott at Culvers wrote: I'm trying to search through a range of numbers for any numbers that are negative. The range is a hidden column, and I need to determine if there is a negative number anywhere in the column. Is there a function to do so? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| convert cells to negative number | Excel Discussion (Misc queries) | |||
| how do i subtract a negative number | Excel Worksheet Functions | |||
| How to add one number to a range of numbers | Excel Worksheet Functions | |||
| How do I find the first value in a column less than a number? | Excel Worksheet Functions | |||
Linear Mode
