Dear All
please see attach sample file is only a small portion of huge data i got
i am trying to do a table out from A and B with only unique values
but always records are mission after doing the filtering . Please what is the
easiest way to copy unique cells from A and B to C and D
thank you
Your list needs headings.
• Insert a row above your data
A1: Title
B1: Dates
The destination area must use the same headings as your data
C1: Title
D1: Dates
• Select your data A1:B160
• Data.Advanced
...List range: (already selected)
...Check: copy to another location
...Check: Unique records only
...Copy to: Select C1:D1
...Click: OK
Does that help?
To use Advanced Filter you to add heads to the columns
Since your data begins at row 1 you need to insert a row at the top and label it let's say Column1 and Column2 respectivly.
Go to Data, Advanced section and select Copy to another location and check Unique Records only. In Copy to: click on cell E1
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you for the feedback!
Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks