But of a problem I've encountered here, I have two columns of data that I am preparing a summary report from.
- In one of the columns I have a 5 or so different string values (from a defined group of 5 string values) which do repeat (eg A, A, C, A, C, D, E)
- the other column has values from an undefined group and can have repeating values (12,12,5,100,5, 12, 15,)
What I need to know is for each of the defined string values in the first Column how many unique values there are in the other column. For example using the simplified example above "A" would have 2 unique values 12 and 100. Alos a few things I should mention:
- I can't combine the two columns and analyse that
- I can't use a macro but I can use a VBA function if formulas can't solve this (VBA functions is the approach I have been trying).
Thanks for looking at my question and if you neeed anymore info let me know.