Greetings all,
I am seeking to create a table in which I can see how many times entries have the same value (in this case entries take the form "X###Y", in which all values/letters are variable). Additionally, I would like to generate a table that only counts 1 instance of a value according to a the value of another column.
For example, the data would be:
1 a110b
1 a110b
1 b222c
1 b222c
1 a321y
2 a110b
2 b222c
2 a321y
The first macro would return a table that included
a110b 3
b222c 3
a321y 2
and the second, using the first column as the reference, would show
a110b 2
b222c 2
a321y 2
I have an idea of how to do the count if I declare each potential X###Y explicitly, but this is not feasible given the number of potential unique entries (7000+ rows with dozens of different values).
Any guidance is much appreciated.
Best regards,
DJRockit
Bookmarks