| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find occurance of something from 2 creterion
If I have 2 columns like below:
A,2008 A,2007 C,2007 B,2008 C,2007 A,2008 A,2008 B,2008 I can use COUNTIF(A1:A8,A11) to find the total occurance of A, but how can I add one moe creterion so I can get the result that it's A and also 2008 (2nd column). So the answer should be 3 in the example above. Thanks for the help, liu |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find the next occurance | Excel Worksheet Functions | |||
| Find nth occurance of data | Excel Worksheet Functions | |||
| help to find a string for 4th occurance | Excel Worksheet Functions | |||
| Macro to find last occurance | Excel Discussion (Misc queries) | |||
| Find next occurance | Excel Discussion (Misc queries) | |||
Threaded Mode
