Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Organizing Data
I have a huge spreadsheet of data from questions on 5 different things. How
do I sort the data. I know there is a function like vlookup to help me do this but i dont know what it is. My data looks like A 1 2 3 A 4 5 6 B 1 2 2 C D A...... You see what I mean. I want to group all the A's, B's etc together in a new sheet (so that i can do the average, standard deviation etc) so I need excel to go from row to row, searching for all the A's and for each A that it finds transfer all of the data in that row. How do I do that? Thank you |
#2
|
|||
|
|||
Maybe I don't see the problem you have, but you can sort all your data
(Data - Sort) on the first column. This will put all the As together, and all the Bs together, and so on. Then you can copy and paste all the As, all the Bs, etc. If you have a reason for not doing it this way, or I missed your problem, then you would have to use VBA (a macro) to do what you want. Post back if sorting as above does not work for you. HTH Otto "trini" wrote in message ... I have a huge spreadsheet of data from questions on 5 different things. How do I sort the data. I know there is a function like vlookup to help me do this but i dont know what it is. My data looks like A 1 2 3 A 4 5 6 B 1 2 2 C D A...... You see what I mean. I want to group all the A's, B's etc together in a new sheet (so that i can do the average, standard deviation etc) so I need excel to go from row to row, searching for all the A's and for each A that it finds transfer all of the data in that row. How do I do that? Thank you |
#3
|
|||
|
|||
one method is to select all and go to <data<Filter<autofilter)
a little double arrow appears in the top row in each column. if you use the arrow in th efirst caloumn, you can select just the As. Copy these and insert on a new page. Go back and select B etc. There are actually many ways to do what you want to do. There are advantages and disadvantages to all of them. "trini" wrote: I have a huge spreadsheet of data from questions on 5 different things. How do I sort the data. I know there is a function like vlookup to help me do this but i dont know what it is. My data looks like A 1 2 3 A 4 5 6 B 1 2 2 C D A...... You see what I mean. I want to group all the A's, B's etc together in a new sheet (so that i can do the average, standard deviation etc) so I need excel to go from row to row, searching for all the A's and for each A that it finds transfer all of the data in that row. How do I do that? Thank you |
#4
|
|||
|
|||
Perhaps you might want to try something along the lines outlined in this
recent post: http://tinyurl.com/cw8jp -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "trini" wrote in message ... I have a huge spreadsheet of data from questions on 5 different things. How do I sort the data. I know there is a function like vlookup to help me do this but i dont know what it is. My data looks like A 1 2 3 A 4 5 6 B 1 2 2 C D A...... You see what I mean. I want to group all the A's, B's etc together in a new sheet (so that i can do the average, standard deviation etc) so I need excel to go from row to row, searching for all the A's and for each A that it finds transfer all of the data in that row. How do I do that? Thank you |
#5
|
|||
|
|||
Thank you all. Duh. This was helpful. I guess I didn't explain myself
correctly. The data actually looks like A 1 2 3 B 2 3 2 B 2 3 4 E 1 1 1 E A A etc. I have information in rows and columns. But with a little bit of work(on my part) I will organize the infor into different sheets and then sort. Thanks again. Amanda "Max" wrote: Perhaps you might want to try something along the lines outlined in this recent post: http://tinyurl.com/cw8jp -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "trini" wrote in message ... I have a huge spreadsheet of data from questions on 5 different things. How do I sort the data. I know there is a function like vlookup to help me do this but i dont know what it is. My data looks like A 1 2 3 A 4 5 6 B 1 2 2 C D A...... You see what I mean. I want to group all the A's, B's etc together in a new sheet (so that i can do the average, standard deviation etc) so I need excel to go from row to row, searching for all the A's and for each A that it finds transfer all of the data in that row. How do I do that? Thank you |
#6
|
|||
|
|||
You're welcome !
Thanks for posting back -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "trini" wrote in message ... Thank you all. Duh. This was helpful. I guess I didn't explain myself correctly. The data actually looks like A 1 2 3 B 2 3 2 B 2 3 4 E 1 1 1 E A A etc. I have information in rows and columns. But with a little bit of work(on my part) I will organize the infor into different sheets and then sort. Thanks again. Amanda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |