Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have two columns populated with different values.
I would like to count all the cells pair having specific values, i.e. like countif function, but for both cells. For now I am doing this concatenating both columns and after that performing CountIf over resulting column. Another way is to write a piece of code looping and counting, but it seems too much for such a simple thing. Is there any other way of doing that? Without intermediate steps, only using one formula? Thanks, Yakimo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNTIF with 2 columns | Excel Worksheet Functions | |||
COUNTIF for 2 columns | Excel Worksheet Functions | |||
COUNTIF - across 2 columns | Excel Worksheet Functions | |||
Countif for 2 columns | Excel Worksheet Functions | |||
countif in 2 columns | Excel Discussion (Misc queries) |