Return value from specific column if not in new column previously
 

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.

Return value from specific column if not in new column previously
 

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

"JDub" wrote in message
...
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.