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

#### Low-Joe

##### New Member
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

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

##### MrExcel MVP
Hi - welcome to the board!

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

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

#### Low-Joe

##### New Member
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.

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

Replies
1
Views
2K
Replies
18
Views
505
Replies
3
Views
462
Replies
0
Views
220
Replies
1
Views
278

1,181,931
Messages
5,932,849
Members
436,866
Latest member
MichelVaillant

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back