LookUp?
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. |
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. |
LookUp?
Thank you. That wasn't how I pictured this solution, but I can make this
work - and it is a fairly easy fix. "Nigel" wrote: 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. |
All times are GMT +1. The time now is 12:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com