Alphabetizing a list with names, addresses, phone # and date

[Low-Joe]

I am having trouble Alphabetizing a list consisting of about 750 rows and 8 columns. There are six rows containing information regarding information about a student. There is a row between each of the sudents information. On the last page I have Formulas to calculate the results. The spread sheet is working fine aside from not being able to Alphabetize. I need help, thank you in advance.

_________________
I am having trouble Alphabetizing a list containing: names, addresses, phone numbers, dates. These are some of the formula's I am using. =SUM(IF(A8:A733="ANDY",I4:I729))
=SUM(IF(B8:B733="MORN",I4:I729))
=SUM(IF(E4:E729="PROCESSED"
This message was edited by Low-Joe on 2002-09-19 17:12
This message was edited by Low-Joe on 2002-09-19 18:20

 

[PaddyD]

Hi - welcome to the board!

'Alphabetize' - meaning sort alphabetically, I assume??

What, exactly, are the problems with the methods you've used so far?

Paddy

 

[Low-Joe]

When I use the sort by option I get a message " The operation requires the merged cells to be identically sized". When I try top to botton or left to right data is out of order. I have a row seprating each of the six rows containing each student's information. I can email you a sample sheet if it will help. Low-Joe.

 

[PaddyD]

unmerge all the cels then sort - what do you get?