s8ntandrew
New Member
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 state names (e.g., Arizona, Oregon, California, etc...) and Column B includes an associated automobile types (e.g., Chevy, Ford, Honda). I want to search all of the Oregon entries and produce the first mention of each automobile type. So the cell where the formula is should produce Chevy, Ford, Honda, etc....
Is this possible?
So, for example, Column A includes state names (e.g., Arizona, Oregon, California, etc...) and Column B includes an associated automobile types (e.g., Chevy, Ford, Honda). I want to search all of the Oregon entries and produce the first mention of each automobile type. So the cell where the formula is should produce Chevy, Ford, Honda, etc....
Is this possible?