Thread
:
LookUp?
View Single Post
#
2
Posted to microsoft.public.excel.programming
Nigel[_2_]
external usenet poster
Posts: 735
LookUp?
Use advanced filters, select the list range (include a header), choose the
Copy to another Location (must be on same sheet) and check the Unique
Records only.
--
Regards,
Nigel
"Shawn777" wrote in message
...
I have a spreadsheet with codes, number codes not programming, that need to
be pulled to a summary table. I was wondering if there was a way of
pulling
these codes automatically without including duplicates. I would prefer if
this could be done through formulas instead of writing a macro €“ but
either
solution will work. For example if one page has the codes of 02, 02, 04,
05,
05, 08, 10, 10. The summary table will automatically show 02, 04, 05, 08,
10.
Reply With Quote
Nigel[_2_]
View Public Profile
Find all posts by Nigel[_2_]