"cbanks" wrote:
I have data in column C for several days. Some of the data is repeated. I
only need the data out of here that does not have a duplicate. I was told you
could do this with vlookup. Can someone help? Thanks

One way to dynamically* extract the uniques into an adjacent col ..

Assuming source data in col C,
from row1 down to say, an expected max row100

In D1:
=IF(ISERROR(SMALL(E:E,ROW())),"",INDEX(C:C,MATCH(S MALL(E:E,ROW()),E:E,0)))

In E1:
=IF(C1="","",IF(COUNTIF($C$1:C1,C1)1,"",ROW()))

Select D1:E1, copy down to E100
(cover the max expected extent of data in col C)

The unique items in col C will be auto-extracted into col D,
all results neatly bunched at the top.

(Hide away the criteria col E, if desired)

*If it's a one-off run, we could also:

Select col C
Click Data Filter Advanced Filter
Check: Copy to another location,
Copy to: F1 (say)
Check "Unique records only"
Click OK
(Unique items will be listed in col F)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---