Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: how do I group a row
I have different pieces of information in each column relating to a single
client eg. A1=job no:, A2=client name, A3=age etc. In the b, c, d, e rows there are new clients with similiar information. My question is: Is it possible to "group" all the information in the A row so when I want to "sort by client name" all the information in the A row will follow its assigned job no? At the moment when I want to sort by age, only the "age" column will change but the other information relating to the client remains static. Any ideas? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: how do I group a row
You need to select all your data before using Data | Sort
In the Sort Options set the sort for left to right Please try to use "row" and column" correctly -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Arderra" wrote in message ... I have different pieces of information in each column relating to a single client eg. A1=job no:, A2=client name, A3=age etc. In the b, c, d, e rows there are new clients with similiar information. My question is: Is it possible to "group" all the information in the A row so when I want to "sort by client name" all the information in the A row will follow its assigned job no? At the moment when I want to sort by age, only the "age" column will change but the other information relating to the client remains static. Any ideas? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: how do I group a row
Select the relevant range of data (rows and columns) before you impose the
Sort command. Don't let Excel guess what you want to include. -- David Biddulph "Arderra" wrote in message ... I have different pieces of information in each column relating to a single client eg. A1=job no:, A2=client name, A3=age etc. In the b, c, d, e rows there are new clients with similiar information. My question is: Is it possible to "group" all the information in the A row so when I want to "sort by client name" all the information in the A row will follow its assigned job no? At the moment when I want to sort by age, only the "age" column will change but the other information relating to the client remains static. Any ideas? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: how do I group a row
Gents,
That worked perfectly. Thank you "Bernard Liengme" wrote: You need to select all your data before using Data | Sort In the Sort Options set the sort for left to right Please try to use "row" and column" correctly -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Arderra" wrote in message ... I have different pieces of information in each column relating to a single client eg. A1=job no:, A2=client name, A3=age etc. In the b, c, d, e rows there are new clients with similiar information. My question is: Is it possible to "group" all the information in the A row so when I want to "sort by client name" all the information in the A row will follow its assigned job no? At the moment when I want to sort by age, only the "age" column will change but the other information relating to the client remains static. Any ideas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
I wish to group my worksheets under group tabs | Excel Worksheet Functions | |||
How can I convert a group of numbers to a group of letters? | Excel Worksheet Functions | |||
Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions |