Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cumlative Counting Question
I was wondering if there is a way to write a formula that will count all the
unique and cumlative occurances of data in a spreadsheet? To try to say it in another way... Count Non-Duplicate values per column per in each row except for previous duplicates in predicessing columns on the given previous rows. Column A B C D E ROW 01 X Y X 02 X 03 X 04 X 05 X 06 X X 07 X Y 08 X X 09 X 10 X 11 X Y 12 X 13 X 14 X 15 X 16 X 17 X 18 Y X 19 X X 20 X X A= 4 X's & 0 Y's B= 12 X's & 2 Y's C= 14 X's & 2 Y's D= 14 X's & 3 Y's E= 20 X's & 4 Y's I hope that this is a possibility because I have to count items that way for a few thound rows over a few hundred columns. Thanks in Advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cumlative % on a Pivot Table | Excel Discussion (Misc queries) | |||
Counting Question | Excel Worksheet Functions | |||
Counting Question | Excel Discussion (Misc queries) | |||
Counting Question | Excel Discussion (Misc queries) | |||
Counting question | Excel Discussion (Misc queries) |