I have a excel file I'm trying to use for my GPS. One of the rules for the mgln gps is it can not have duplicate names. In this file they named one whole clm(200+) to goodwill. I need the names to Be unique like goodwill #1, goodwill #2 etc all the way down (even goodwill1, goodwill2 would work|||Use the Advanced Filter in Excel, I assume you are using MS Excel? If this is the case, go to Data and Under Filter you will find 'Advanced Filter'
Copy the heading of your column as a reference and then associated the ranges that excel requires..and then make sure "unique data/records only" is ticked.. then press ok
Hope this heps, if you need more, let me know by email !|||I just tried this myself and put "goodwill1" then did a click and drag and Excel did the numbering (i.e. goodwill2, goodwill3...)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment