I have an excel file with 272,000 lines of data across 5 columns. The data looks like this:
A B C D E
1 1 1 1 1
1 0 1 0 1
1 1 1 1 1
1 0 0 0 0
1 0 1 0 1
1 0 1 1 1
1 1 1 1 1
1 0 1 0 1
1 0 1 1 1
1 1 1 1 1
1 1 1 0 1
1 0 1 1 1
1 0 0 1 1
0 1 0 0 0
1 0 0 0 1
0 0 0 0 1
1 1 1 1 1
1 1 1 0 1
0 1 0 0 0
1 0 0 0 0
1 1 1 0 1
1 1 1 1 0
1 0 0 0 0
1 1 1 0 1
0 0 0 0 1
1 0 0 0 1
1 1 1 1 1
1 1 0 1 1
1 1 1 1 1
I know what the unique combinations are:
A
AE
AB
BE
B
AC
ABC
BC
C
ACE
ABCE
BCE
CE
ACDE
ABCDE
BCDE
CDE
ADE
ABDE
BDE
DE
AD
ABD
BD
D
How do I get a count of how many times each combination appears? I tried using a nested 'IF' function and also the count if function. What can I do in this situation.