ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sort 1 Column to match another (https://www.excelbanter.com/excel-discussion-misc-queries/143695-sort-1-column-match-another.html)

David P.

Sort 1 Column to match another
 
I would like to sort column B to match column A like this:

Column A (stays the same) Column B (sorts to match Column A based on
C__)
---------------------------------------------------------------------------------------
Duette\CPLP C20 (34) Duette\C21 (c)
Duette\CPLP C21 (34) Duette\C23 (a)
Duette\CPLP C23 (34) Duette\C20 (b)

The other variable is that the information in column B will have one common
denominator and that is the "C20, C21, C22" the rest of the info may not
match.

Do I need to first isolate the "C20, C21, C22" if I want this to work?
--
David P.


All times are GMT +1. The time now is 09:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com