Hello all,
Please see attached file.
Two red tabs contain a list of 36 values (35 unique, 1 duplicate). I need an array formula to extract unique values only from both red tabs and list them sorted alphabetically on the yellow tab.
Thank you for helping!
the easiest way is to put it into a pivot table.Extract unique values from 2 worksheets.xlsx You'll need to reformat your dates so they can be sorted properly.
Last edited by igoodable; 07-16-2013 at 05:46 PM.
I'm late in replying, but I just wanted you to know that your solution did fix my problem. Thank you so much for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks