Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIf question
I have a report that has 4 columns of numbers 0 - 9, about 1500 rows deep, what I would like to be able to do is simple, but I can't seem to get my brain wrapped around it tonight. I need to find the most frequent occurring number in each column (got that part), then compare the top three from column A to the top 3 from col. B, etc.
Not to give away any information I'm not allowed to, think of it like this" 0 - Apples A - Northeast 1 - Oranges B - Southeast 2 - Grapes C - Northwest 3 - Plums D - Southwest -------- data --------- -------------- Results --------------- A B C D A B C D 1 0 1 3 6 0 1 0 0 0 0 0 0 2 2 4 3 2 1 0 1 2 1 0 1 0 3 2 1 7 5 2 2 2 1 2 0 2 1 4 4 2 5 9 3 0 3 0 3 2 3 0 4 1 4 1 4 0 4 0 What I cant seem to get is: A B C D 2 1 3 2 I can't seem to be able to combine 4 "Countif"s statements... -- Live simply...Love generously...Care deeply...Speak kindly...Leave the rest to God. -- Live simply...Love generously...Care deeply...Speak kindly...Leave the rest to God. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif question | Excel Discussion (Misc queries) | |||
countif question | Excel Worksheet Functions | |||
CountIf Question | Excel Discussion (Misc queries) | |||
Countif question | Excel Worksheet Functions | |||
countif question | Excel Worksheet Functions |