LinkBack URL
About LinkBacks
btamulis 
Does it need to be in the same order?
You can copy your range (i.e. A2:A1000) and paste it below the original and then Sort by that column to get the duplicate values back together again. Would that work for you?
Does it need to be in the same order?
You can copy your range (i.e. A2:A1000) and paste it below the original and then Sort by that column to get the duplicate values back together again. Would that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I tried your solution and ran into the following: Copied my rows (38,365 rows)
I tried to paste my selected at the 1st blank row after my last record - get that ugly message that I cannot paste and that I must select a single cell (which I did) or I must choose a range equivalent to my selected range.........
My range is 38,365 rows - so I try to select a range below my range with 38,375 rows (76,730 total) - the spreadsheet maxes at 65,000 - I am on 2007 - how to change the default of 65,000 rows available?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks