What I am trying to accomplish is like using a SELECT DISTINCT in SQL.

I already know of formula arrays and the ribbon buttons, but that is still not enough.

The constraints I am working with are:

I have 2 Excel tables

One has duplicate values in one column.

I have to get only the distinct values in the second column.

Can you folks help me on that?

  • Welcome to Super User. New members commonly mistake this for a service site where we will do the work. It is a Q&A community where specific questions are asked after you have attempted something and get stuck. Please add details of what you have tried so far, including scripts, code or formulas, and we will try to help. If you need more info about asking questions, check out How to Ask in the help center. – CharlieRB Apr 13 '16 at 11:51
  • Two tables, but one table has duplicates in column 1, but you need unique values from column 2? What does column 1 or the other table have to do with? – Raystafarian Apr 13 '16 at 14:49

A possibility to get distinct value from a table or column, is to use a simple pivot table. Take the column with duplicate value as ROWS in the pivot and you will get a list without duplicate.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.