| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting frequency in unsorted data
Dave,
thank you, yes that did the trick...I had the sumproduct function wrong, I was using "=XA" not ="XA" - an important difference. The solution you provided works provided I subtract for blank spaces. I have to treat 0 and blank cells separately ( 0 is a possible outcome whereis blank is no data available). Thanks very much Phil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for counting frequency then sorting | Excel Worksheet Functions | |||
| Frequency Counting | Excel Worksheet Functions | |||
| word frequency counting | Excel Discussion (Misc queries) | |||
| Counting Numbers of Same Frequency | Excel Discussion (Misc queries) | |||
| Counting Frequency of Filtered Data | Excel Worksheet Functions | |||
Threaded Mode
