Return value from specific column if not in new column previously

[JDub]

I have a spreadsheet where a user enters values in column B for a specific
set of rows, i.e. rows 1 - 6. For purposes of this example, the user enters
1, 2, or 3 in cell range B1:B6. In column J, I want Excel to automatically
pick up what the user entered in column B and insert the same data in column
J. However, I do not want multiple instances of the same data in column J,
just one instance. For example, in column B if a user enters the following
in rows cell range B1:B6: 1, 2, 2, 1, 1, 3; I want column J to only display
1, 2, 3 and not 3-1's, 2-2's and 1-3.

 

[Ashish Mathur]

Hi,

You could use advanced filter to extract unique values. Give a heading to
the numbers in column B, say the heading is in B1. Now to go Data > Filter

Advanced Filter. Select copy to another location. In the list box,

select B1:B7. Leave the criteria blank and give the reference of any blank
cell in the copy to box. Check the box for unique records only.

Click on OK

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com