Hi
I have data in column A which looks like below
54
521
87454
521
Here is what I am trying to determine
1 appears with 1 in 0 rows
1 appears with 2 in 2 rows
1 appears with 3 in 0 rows
1 appears with 4 in 0 rows
1 appears with 5 in 2 rows
and so on.
I can have the table setup in different column as
Value 1, Value 1, Count
Value 1, Value 2, Count
etc
Hope this makes sense
I have data in column A which looks like below
54
521
87454
521
Here is what I am trying to determine
1 appears with 1 in 0 rows
1 appears with 2 in 2 rows
1 appears with 3 in 0 rows
1 appears with 4 in 0 rows
1 appears with 5 in 2 rows
and so on.
I can have the table setup in different column as
Value 1, Value 1, Count
Value 1, Value 2, Count
etc
Hope this makes sense