| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort & match | Excel Worksheet Functions | |||
| formula to match a range(sort) so it matches an external column | Excel Discussion (Misc queries) | |||
| Index? Match? Function to sort and return value fr diff column in | Excel Worksheet Functions | |||
| Any way for 2 column vlookups. i.e match last name then match firs | Excel Worksheet Functions | |||
| Match and sort | Excel Worksheet Functions | |||
Linear Mode
