Picking from a list

  • Thread starter Thread starter Gun_Maddie
  • Start date Start date
G

Gun_Maddie

I am trying to find a solution for the following problem. I have a
list - let's say

Account
210
5012
3022
210
5012
2121

Now in a completely different column I need a formula that will look
at the list pull the first non-blank number. Then the next cell down
needs to be the second non-blank number, but it must not match what is
in the cell above it.

My output should look like
210
5012
3022
2121

Any help would be appreciated - this is driving me wacko....
 
Suggest you use Data >> Filter >> Advanced Filter.
Action = copy to another location (specify where in "copy to"), unique
records only checked.

HTH,
Andy
 
Using advanced filter will do the trick.
Make sure you insert a row above the range just to name
the list.
Select the cell with the name and the list.
On the Data menu, point to Filter, and then click Advanced
Filter.

Select the Unique records only option to remove duplicated.

To filter the list by copying rows to another area of the
worksheet, click Copy to another location, click in the
Copy to box, and then click the upper-left corner of the
paste area.

This should eliminate all duplicates, and also preserve
the order of the original list (i.e. no sorting).

Good luck.

Bill K
 
Back
Top