| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to Sort #'s in Column B,C&D in the order from Column A
I HAVE A LIST OF NUMERICAL DATA IN COLUMN A
I NEED COLUMNS B-D TO SORT IN THE SAME ORDER AS COLUMN A, IF THERE IS NO LIKE NUMBER IN COLUMN B-D THE SPACE NEEDS TO BE LEFT BLANK....... HELP |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need to Sort #'s in Column B,C&D in the order from Column A
Hi,
is column B to D related to A?, if yes highlight from column A to D and then sort by column A "KIKI" wrote: I HAVE A LIST OF NUMERICAL DATA IN COLUMN A I NEED COLUMNS B-D TO SORT IN THE SAME ORDER AS COLUMN A, IF THERE IS NO LIKE NUMBER IN COLUMN B-D THE SPACE NEEDS TO BE LEFT BLANK....... HELP |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need to Sort #'s in Column B,C&D in the order from Column A
No, the columns are independent of each other....I need them to sort like
column A... and leave blanks where there is no data that matches...I need a "matching" function basically.... match up column B to column A and match up column C to column A.... the create a custom sort does not work since we are dealing with numbers instead of text "Eduardo" wrote: Hi, is column B to D related to A?, if yes highlight from column A to D and then sort by column A "KIKI" wrote: I HAVE A LIST OF NUMERICAL DATA IN COLUMN A I NEED COLUMNS B-D TO SORT IN THE SAME ORDER AS COLUMN A, IF THERE IS NO LIKE NUMBER IN COLUMN B-D THE SPACE NEEDS TO BE LEFT BLANK....... HELP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SORT a column of Texts to follow another "EXACT" order | Excel Discussion (Misc queries) | |||
| How to change the column order in Excel table with multiple sort | Excel Discussion (Misc queries) | |||
| Flipping the order of words in a column to a new column | Excel Discussion (Misc queries) | |||
| my column is sorted in two sections. How do I sort entire column? | Excel Discussion (Misc queries) | |||
| sort column in date order dd/mm/yy | Excel Discussion (Misc queries) | |||
Linear Mode
