LookUp?

  • Thread starter Thread starter Shawn777
  • Start date Start date
S

Shawn777

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.
 
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.
 
Thank you. That wasn't how I pictured this solution, but I can make this
work - and it is a fairly easy fix.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top