Sort data using array formula

[mukeshbaviskar]

Dear Friends,
In my cd player distribution register I want to sort the data as follows in column range “bb6:bw2000” respectively. I want to use array formula for it as district wise sorting in the table left of this table range “ab6:aw1000”.

Requirement:
The data should be sort in ascending order of district, column ‘bg6:bg2000’ and standard, column ‘bm6:bm2000’ respectively and received date column range ‘bc6:bc2000’ respectively.

Condition 1:
If I enter standard in cell ‘az3’ and enter start date in cell ‘az6’ and end date in cell ‘az7’ Then the data should be sort between start and end date of given standard in ascending order of district and standard and date in the table.
At this time the standard from and standard to entries will be blank and have no effect cells ‘az4’, ‘az5’.

Condition 2:
If I enter start date and end date in cells ‘az6’, ‘az7’ respectively, standard from and standard to in cells ‘az4’, ‘az5’ respectively then the data should be sort in ascending order of date, district and standard respectively in the table.
At this time the standard entry in cell ‘az3’ have no effect.

Please suggest me the solution at the earliest.

Thanking you in anticipation.

Please see the attachment.

Regards

Mukesh

[mukeshbaviskar]

Hello Kevin and all excel experts,
I'm in a urgent need of sorting the data mentioned in my previous post. I humbly request you to my problem positively and solve my problem at the earliest.
Dear Kevin you have solved my previous problem successfully with the help of array formula so now I expect a positive solution from you soon.
Thanking you in anticipation.
Waiting for solution at the earliest.

Mukesh

[Pepe Le Mokko]

Urgent requests = see pay site. Forum rules suggest waiting about 24 hrs before bumping

[mukeshbaviskar]

Dear Pepe Le Mokko,
I'm new to this forum. It was not my intension to break forum rules. I respects the forum and it's rules.
I appologize for requesting before 24 hours completion. Now I will wait till tomorrow to get my solution eagerly.
Sorry once again.

Mukesh

[mukeshbaviskar]

Dear excel experts,
Good morning!
I'm in a urgent need of complete the cd player register at the earliest. Therefore I humbly request you to take some time to solve my problem quickly.
Sorry for requesting repeatedly but please try to understand my need to complete the cd register quickly. I'm optimistic to solve this problem today positively.
Do give me a solution today.
Thanking you in anticipation.

Mukesh