I have 3 columns that display calculated data from 3 worksheets.
I would like to combine these 3 columns into a single sorted column with no duplicates.
GO FROM:
437444 439772 438849 441768 439031 439572 439772
TO THIS:
437444
438849
439031
439572
439772
441768
However, I am unsure of how to do this. HELP!
Last edited by wkalata; 09-03-2013 at 09:34 AM.
If your data is in columns A and B enter this formula in column C and copy down the length of your data:
Adjust the range to suit your actual data. This will take all the values and list them in ascending order. This will include duplicates. Select the list, click on the Data tab, Remove Duplicates.Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
How can I remove duplicates from that list?
If your column with duplicates is "A" and you entering formula in "C" use formula below. This is an array formula and must be entered with
Ctrl+Shift+Enter. Adjust formula's ranges if needed accordingly.
=INDEX($A$2:$A$100, MATCH(0, COUNTIF($C$1:C1, $A$2:$A$100), 0))
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks