Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
My ColA and ColB contain arbitrary integers, either positive, zero, or
negative. I'm trying to count the number of times that the value in a given row of ColA is greater than that in ColB. For instance, for these data: 1 | 4 2 | -1 3 | 7 4 | -3 5 | 0 .... I need to return a three (the values in rows 2, 4, and 5 of ColA are greater than those of ColB). I tried COUNTIF(A:A,"<B:B"), with no luck. I get a zero value, no matter the appropriate return. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comparing Two Columns | Excel Discussion (Misc queries) | |||
Comparing two columns | Excel Worksheet Functions | |||
Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
comparing two columns | Excel Discussion (Misc queries) | |||
comparing two columns? | Excel Discussion (Misc queries) |