Find solution
How to filter single column in a jtable?

In MS Excel, how do I make a list of unique entries from another column?

  • I have: An Excel worksheet with a column of ID numbers. The numbers may appear several times each in the column. I want: to make another column, listing each unique number in the ID number column only once. For example, whether the number 1063 appears 5 times or one time in the ID column, it would appear only once in the new column. Basically, I want the list that is in the Filter drop-down menu when I add Auto Filter to the ID Number column.

  • Answer:

    If your info is in Column A starting in A1, copy this formula into the first cell of the column where you want the unique numbers =IF(COUNTIF($A$1:A1, A1)=1, A1, "") After you type/paste it in, press CTRL+Shift+Enter to make this an array formula; this puts brackets around the formula to show that it is an array formula. Then copy it down alongside the entire original column. Your new column will now only show one entry for each unique record. You can Copy | Paste Special... | Values now to finish.

mangofan... at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

Thanks O Cacador!!! You deserve ten points. I have done this years ago. I knew it had to do something with an array and countif function but I wasn't sure how to put it all together. Thanks again. Hope you get ten points for this.

crazyhumans

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.