sorting help

[lwilt]

Is there a way to do multiple independent sorts at the same time on the same sheet? I have data for multiple months in the same sheet and want to be able to sort them all at the same time but each sort should be independent of the others since they will all not have the same sales data in them.

 

[Deepak]

Hi,

Just select the range where u want to sort & do the sorting.

 

[lwilt]

I need to sort two separate columns at the same time and where each should yield different results...

 

[Deepak]

I need to sort two separate columns at the same time and where each should yield different results...

Pls explain itself with xl by sample.

 

[lwilt]

so the sales comp for each month needs to be sorted independently of the other months...not sure if the spreadsheet needs to be set up slightly different

 

[tomas]

Hi

Select the whole first area which you want to sort then sort. Then select the whole second area and repeat

 

[lwilt]

that's not feasible when it has years and years of information in it