Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Formula Question
I am certain someone can help me here. To start off lets assume you have
something that looks like this: Cells: A4 = Extravert A5=Intravert A6=Passive A7=Other Cells: A1 - A800 are the clients names, so A1 = Client #1, A2=Client #2, and so forth. Each client answers a number 1 to 4 for the above A4 - A7. Now what I would like to is be able to sort on each customer row A4 - A7 based on the answers 1 - 4. So for example if Client #1 said 1 to a4, 2 to a6, 3 to a5, and 4 to a7, then it would put data in that order and keep the title because I am using the title on another page. I realize I might need to create more columns which is fine. Any thoughts on a formula? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Formula Question
Cells: A4 = Extravert A5=Intravert A6=Passive A7=Other
Cells: A1 - A800 are the clients names, These statements conflict. ------------------------------------------------------ I would like to is be able to sort on each customer row A4 - A7 based on the answers 1 - 4. Only sort on four rows? ------------------------------------------------------------- So for example if Client #1 said 1 to a4, 2 to a6, 3 to a5, and 4 to a7, then it would put data in that order and keep the title because I am using the title on another page What titles? Row 1 was a name and column A seems to be names. ------------------------------------------------------------------------- You need to clean this up and repost. ' "MLewis123" wrote in message ... I am certain someone can help me here. To start off lets assume you have something that looks like this: Cells: A4 = Extravert A5=Intravert A6=Passive A7=Other Cells: A1 - A800 are the clients names, so A1 = Client #1, A2=Client #2, and so forth. Each client answers a number 1 to 4 for the above A4 - A7. Now what I would like to is be able to sort on each customer row A4 - A7 based on the answers 1 - 4. So for example if Client #1 said 1 to a4, 2 to a6, 3 to a5, and 4 to a7, then it would put data in that order and keep the title because I am using the title on another page. I realize I might need to create more columns which is fine. Any thoughts on a formula? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Formula Question
WOW!!! You are not kidding, I really messed this post up....thanks, I will
repost. "JLGWhiz" wrote: Cells: A4 = Extravert A5=Intravert A6=Passive A7=Other Cells: A1 - A800 are the clients names, These statements conflict. ------------------------------------------------------ I would like to is be able to sort on each customer row A4 - A7 based on the answers 1 - 4. Only sort on four rows? ------------------------------------------------------------- So for example if Client #1 said 1 to a4, 2 to a6, 3 to a5, and 4 to a7, then it would put data in that order and keep the title because I am using the title on another page What titles? Row 1 was a name and column A seems to be names. ------------------------------------------------------------------------- You need to clean this up and repost. ' "MLewis123" wrote in message ... I am certain someone can help me here. To start off lets assume you have something that looks like this: Cells: A4 = Extravert A5=Intravert A6=Passive A7=Other Cells: A1 - A800 are the clients names, so A1 = Client #1, A2=Client #2, and so forth. Each client answers a number 1 to 4 for the above A4 - A7. Now what I would like to is be able to sort on each customer row A4 - A7 based on the answers 1 - 4. So for example if Client #1 said 1 to a4, 2 to a6, 3 to a5, and 4 to a7, then it would put data in that order and keep the title because I am using the title on another page. I realize I might need to create more columns which is fine. Any thoughts on a formula? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Formula Question
If this is for your work and possible publication please note:
Introvert and Extrovert are correct spelling. Gord Dibben MS Excel MVP On Tue, 29 Sep 2009 19:15:01 -0700, MLewis123 wrote: WOW!!! You are not kidding, I really messed this post up....thanks, I will repost. "JLGWhiz" wrote: Cells: A4 = Extravert A5=Intravert A6=Passive A7=Other Cells: A1 - A800 are the clients names, These statements conflict. ------------------------------------------------------ I would like to is be able to sort on each customer row A4 - A7 based on the answers 1 - 4. Only sort on four rows? ------------------------------------------------------------- So for example if Client #1 said 1 to a4, 2 to a6, 3 to a5, and 4 to a7, then it would put data in that order and keep the title because I am using the title on another page What titles? Row 1 was a name and column A seems to be names. ------------------------------------------------------------------------- You need to clean this up and repost. ' "MLewis123" wrote in message ... I am certain someone can help me here. To start off lets assume you have something that looks like this: Cells: A4 = Extravert A5=Intravert A6=Passive A7=Other Cells: A1 - A800 are the clients names, so A1 = Client #1, A2=Client #2, and so forth. Each client answers a number 1 to 4 for the above A4 - A7. Now what I would like to is be able to sort on each customer row A4 - A7 based on the answers 1 - 4. So for example if Client #1 said 1 to a4, 2 to a6, 3 to a5, and 4 to a7, then it would put data in that order and keep the title because I am using the title on another page. I realize I might need to create more columns which is fine. Any thoughts on a formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Question | Excel Programming | |||
Sorting question-is this possible | Excel Programming | |||
Sorting question | New Users to Excel | |||
sorting question | Excel Discussion (Misc queries) | |||
Sorting Question | Excel Discussion (Misc queries) |