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

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

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

Need to Sort #'s in Column B,C&D in the order from Column A
 

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You send a clear explanation of what you want
3. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KIKI" wrote in message
...
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