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