Extracting a list of unique values from a list on another sheet

john I

Thank You! This worked for me. I added a column with sequential numbers (1 thru 50) and referenced that column in the formula to get all the second, third, fourth, etc unique names.

Paul Newcome

@john I That's typically what I do as well, but you indicated the desire to avoid helper columns which is why I just went with the hard coded number that gets manually changed for you.

Eric Slauson

I"ve been thinking through this for days trying matches and countifs but running into the dreaded cell formula limit. This INDEX(DISTINCT) combination was exactly what I was looking for.

Well done!