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!