Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 8,651
Default Sorting data in group

See your post in another group. Please don't multipost; crosspost if
necessary.
--
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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting data in group Akber Khan, Karachi, Pakistan Excel Discussion (Misc queries) 3 January 11th 08 10:43 AM
Sorting in group daniellchiu via OfficeKB.com Excel Discussion (Misc queries) 2 December 1st 07 11:16 AM
Sorting by Group of Cells -random- Excel Discussion (Misc queries) 3 November 17th 05 07:11 PM
excel group sorting meehaha Excel Discussion (Misc queries) 1 July 5th 05 06:07 PM
Automatic Sorting of a group of columns. Josh Barbara Excel Worksheet Functions 1 November 15th 04 01:55 AM


All times are GMT +1. The time now is 01:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"