Perhaps an example from my spreadsheet would help.
Column A Column B
1040 700
1040 700
1040 800
1040 800
2000 700
2000 700
2000 850
2000 900
2100 800
2100 900
2100 900
In column C, I'd like to produce...
I have a spreadsheet with two columns. Each is full of duplicated data points. I'd like to search Column A for duplicates and create an array based on the results that I can search the associated data in Column B for the first unique data points. Make sense?
So, for example, Column A includes...