Hi,
I'm still learning Excel and have what is probably an easy and basic question.
I have one worksheet with product numbers in one column that are ordered by popularity then I have a master sheet with the same prodcut numbers ordered by number (AA100, AA101, etc)
Is there a way to sort the column ordered by product number so that it matches the column ordered by popularity?
If you mean to keep the product number sorted together with the popularity, select all the data then on the Home Tab, click on Sort and Filter, Custom, and choose the column to sort on.
<---------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
CA223 CA223
CA224 CA224
CA270 CA239
CA239 CA242
CA251 CA132
CA136 CA133
CA274 CA253
CA244 CA254
CA275 CA124
CA238 CA125
CA229 CA250
CA279 CA251
CA240 CA136
CA230 CA138
CA267 CA209
CA281 CA210
CA228 CA241
CA252 CA244
CA226 CA229
CA277 CA238
For example, the first column is popularity and the second is the list of product numbers. I want the second column to match the first without changing the first.
I just tried selecting all and using custom sort but it sorted both columns in an A to Z orientation. I haven't had any luck with any of the other options.
Last edited by mttmrrsn; 11-14-2013 at 03:20 PM. Reason: Just saw the response
This is your data sorted by the first column by selecting all the data and sorting on the first column.
CA136 CA133
CA223 CA223
CA224 CA224
CA226 CA229
CA228 CA241
CA229 CA250
CA230 CA138
CA238 CA125
CA239 CA242
CA240 CA136
CA244 CA254
CA251 CA132
CA252 CA244
CA267 CA209
CA270 CA239
CA274 CA253
CA275 CA124
CA277 CA238
CA279 CA251
CA281 CA210
This is the same data sorted on the second column
CA275 CA124
CA238 CA125
CA251 CA132
CA136 CA133
CA240 CA136
CA230 CA138
CA267 CA209
CA281 CA210
CA223 CA223
CA224 CA224
CA226 CA229
CA277 CA238
CA270 CA239
CA228 CA241
CA239 CA242
CA252 CA244
CA229 CA250
CA279 CA251
CA274 CA253
CA244 CA254
This is your data sorted by the first column by selecting all the data and sorting on the first column.
CA136 CA133
CA223 CA223
CA224 CA224
CA226 CA229
CA228 CA241
CA229 CA250
CA230 CA138
CA238 CA125
CA239 CA242
CA240 CA136
CA244 CA254
CA251 CA132
CA252 CA244
CA267 CA209
CA270 CA239
CA274 CA253
CA275 CA124
CA277 CA238
CA279 CA251
CA281 CA210
This is the same data sorted on the second column
CA275 CA124
CA238 CA125
CA251 CA132
CA136 CA133
CA240 CA136
CA230 CA138
CA267 CA209
CA281 CA210
CA223 CA223
CA224 CA224
CA226 CA229
CA277 CA238
CA270 CA239
CA228 CA241
CA239 CA242
CA252 CA244
CA229 CA250
CA279 CA251
CA274 CA253
CA244 CA254
There is something goofy going on here. I make one post and get an error telling me to wait 15 seconds and try again....result 2 posts
I am sorry, I think I am asking this the wrong way. If my data is currently this:
CA223 CA223
CA224 CA224
CA270 CA239
CA239 CA242
CA251 CA132
CA136 CA133
CA274 CA253
CA244 CA254
CA275 CA124
CA238 CA125
CA229 CA250
CA279 CA251
CA240 CA136
CA230 CA138
CA267 CA209
CA281 CA210
CA228 CA241
CA252 CA244
CA226 CA229
CA277 CA238
Then I want to sort it so it looks like this:
CA223 CA223
CA224 CA224
CA270 CA270
CA239 CA239
CA251 CA251
CA136 CA136
CA274 CA274
CA244 CA244
CA275 CA275
CA238 CA238
CA229 CA229
CA279 CA279
CA240 CA240
CA230 CA230
CA267 CA267
CA281 CA281
CA228 CA228
CA252 CA252
CA226 CA226
CA277 CA277
So that the second one matches the first one.
Use this formula to retrieve values from column 2 that match column 1 . Insert a column between columns A and B and enter this formula in the new column B:
=IFERROR(VLOOKUP(A1,$C$1:$C$20,1,0),"")
There are many non-matches which will return a blank cell. How you want to handle these situations, I don't know.
Thanks! Working around the empty cells will be easier than doing it all by hand.
You're welcome. Thank you for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks