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

Low-Joe

New Member
Joined
Sep 17, 2002
Messages
2
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

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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

New Member
Joined
Sep 17, 2002
Messages
2
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.
 

Forum statistics

Threads
1,144,451
Messages
5,724,425
Members
422,553
Latest member
excelgraham

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top