LinkBack URL
About LinkBacks
boothexcel 
Please see attachment; looking to sort list on the left to yield list on the right.
Thanks!
Please see attachment; looking to sort list on the left to yield list on the right.
Thanks!
You could do this with a Pivot Table, or with 2 helper columns
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you very much!
I am a beginner; not sure what you mean by helper columns; could you demonstrate?
Thank you!
A helper column is a column that you add to include a formula to help you do stuff - they can be hidden iof needed.
Put this in E4 and copy down...
=IF(C4="",E3,CODE(C4))
Then copy all of that and paste values over that same range
Now you can sort by column E and then then by column D
A helper column is a column that you add to include a formula to help you do stuff - they can be hidden iof needed.
Put this in E4 and copy down...
=IF(C4="",E3,CODE(C4))
Then copy all of that and paste values over that same range
Now you can sort by column E and then then by column D
Thank you, FDibbins!
Glad it worked for you, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks