Sorting data in group
 

Working on a excel sheet maintaining huge data and need to sort it date wise,
amount wise (range 1 to 10000, 10001 to 20000).

The problem is that we have data set of different clients, this data set of
each client spread over 9 columb and 7 rows and i need to sort it in a group.

How do i do this?
Data set should'nt be destroy?



for example
Columbs a

Name of Client nature of business funded non funded trade
business date of approval limit expiry date fresh/renewal remarks.

rows a
DM
MMF
IERF
BD/RISK LINE
PAD
OTHERS
SUBTOTAL

Sorting data in group
 

Select the entire range (rows and columns) before you sort.
--
David Biddulph

"Akber Khan, Karachi, Pakistan"
m wrote in message
...
Working on a excel sheet maintaining huge data and need to sort it date
wise,
amount wise (range 1 to 10000, 10001 to 20000).

The problem is that we have data set of different clients, this data set
of
each client spread over 9 columb and 7 rows and i need to sort it in a
group.

How do i do this?
Data set should'nt be destroy?



for example
Columbs a

Name of Client nature of business funded non funded trade
business date of approval limit expiry date fresh/renewal
remarks.

rows a
DM
MMF
IERF
BD/RISK LINE
PAD
OTHERS
SUBTOTAL

Sorting data in group
 

Thank for your reply

But when we sort by selecting range it mix all the rows in order to give the
desire result, i want to keep certain rows togather. i hope u understand

"Akber Khan, Karachi, Pakistan" wrote:

Working on a excel sheet maintaining huge data and need to sort it date wise,
amount wise (range 1 to 10000, 10001 to 20000).

The problem is that we have data set of different clients, this data set of
each client spread over 9 columb and 7 rows and i need to sort it in a group.

How do i do this?
Data set should'nt be destroy?



for example
Columbs a

Name of Client nature of business funded non funded trade
business date of approval limit expiry date fresh/renewal remarks.

rows a
DM
MMF
IERF
BD/RISK LINE
PAD
OTHERS
SUBTOTAL

Sorting data in group
 

Your need to use a helper column for sorting which identifies each group
uniquely ..........

Vaya con Dios,
Chuck, CABGx3


<Akber Khan; <Karachi; "Pakistan"
m wrote in message
...
Thank for your reply

But when we sort by selecting range it mix all the rows in order to give
the
desire result, i want to keep certain rows togather. i hope u understand

"Akber Khan, Karachi, Pakistan" wrote:

Working on a excel sheet maintaining huge data and need to sort it date
wise,
amount wise (range 1 to 10000, 10001 to 20000).

The problem is that we have data set of different clients, this data set
of
each client spread over 9 columb and 7 rows and i need to sort it in a
group.

How do i do this?
Data set should'nt be destroy?



for example
Columbs a

Name of Client nature of business funded non funded
trade
business date of approval limit expiry date fresh/renewal
remarks.

rows a
DM
MMF
IERF
BD/RISK LINE
PAD
OTHERS
SUBTOTAL