Re: Ping the Excel gurus.

In communiqué <6u66b4Fdnk05U2@xxxxxxxxxxxxxxxxxx>, Simon Wilson <siwilson@xxxxxxxxxxxxxxxxxxxxxx> cast forth these pearls of wisdom
Krusty wrote:
antonye wrote:

Krusty wrote:
The problem I've got is the people I'm doing this for want to be
able to change the sort order in Excel. E.g. they may want it in
ascending Total Val order, but obviously keeping each client's
three rows grouped together (so in the above example Mr Fred's rows
would move to the top). Then they might want to have a look by
descending Equities, so Mr Bloggs' rows would move back to the top.
Data > Sort By ... > [Sort Dialog]

Sort By: Total Val
Then By: Client Name

...because you can specify more than one sort column.
That mixes all the clients up. I'm pretty sure it can't be done by
sorting - what I don't know is whether it can be done by macros or
something.


Not an Excel[1] expert, but IWHT that you would have to get each client's data all into one row first?

[1]dislike it with a passion

We should form a sect.

Once our site has been 'refreshed' am going to have to cobble up things in Excel that were an absolute doddle with a proper database 4GL.

--
+----------------------------------------------------------------+
| Pete Fisher at Home: Peter@xxxxxxxxxxxxxxxxxxxxx |
| Voxan Roadster Gilera Nordwest * 2 Yamaha WR250Z |
| Gilera GFR * 2 Moto Morini 2C/375 Morini 350 "Forgotten Error" |
+----------------------------------------------------------------+
.

Relevant Pages

  • Re: Sort by name
    ... When I open the files in Excel with FILE> OPEN there is no columns ... I can sort without a problem. ... you click on the column heading "Name" this will sort the list ... Clicking on NAME again reverses the sort order. ...
    (microsoft.public.excel)
  • Re: Sort by name
    ... When I open the files in Excel with FILE> OPEN there is no columns 'Name' ... But when in Windows Explorer, I can sort without a problem. ... Clicking on NAME again reverses the sort order. ...
    (microsoft.public.excel)
  • RE: Excel Sort
    ... For example, if a cell contains the text "A100," Excel Services places the ... Note If you have changed the default sort order to be case-sensitive ...
    (microsoft.public.excel.programming)
  • Re: Need a sorting solution
    ... Is your question about mail merging? ... If you want to sort what is the sort order? ... Excel '03 plus '07 beta... ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Ping the Excel gurus.
    ... to change the sort order in Excel. ... Sort By: Total Val ... Then By: Client Name ...
    (uk.rec.motorcycles)