Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting in group | Excel Discussion (Misc queries) | |||
Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
Sorting by Group of Cells | Excel Discussion (Misc queries) | |||
excel group sorting | Excel Discussion (Misc queries) | |||
Automatic Sorting of a group of columns. | Excel Worksheet Functions |