Formula Required

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mare - 30 Jun 2005 04:03 GMT

Hello,
I have a partial worksheet that I pasted below. I am going to use mail
merge eventually. I need to use some type of formula that I can sort all
information in numerical order using the last column of numbers, keeping all
pertinent information attached to it in the rows. The list that I have is
like 8000 names and I need a quick way.

Thanks,
Mare

16273 ELLISON EUPHA L 2503 PISGAH RD PRINCETON WV 24740 23 A
16300 HAROLD MELISSA D 240 12TH ST, EXT #7 PRINCETON WV 24740 29 A
16320 HOWARD GREGORY D 406 LWR PINE ST PRINCETON WV 24740 5 A
16446 ARNOLD SHARON E BOX 394 LWR PINE PRINCETON WV 24740 4 A
16467 TIBBS KATIE B 382 WYNDALE DR PRINCETON WV 24740 5 A
16599 COX LEONARD D 2160 BRICKYARD RD PRINCETON WV 24740 5 A
16831 WHITE TERESA L PO BOX 5095 PRINCETON WV 24740 5 A

Reply to this Message

Earl Kiosterud - 30 Jun 2005 04:10 GMT

Mare,

There are sorting tools in Excel. There are the sort buttons on the
standard toolbar. Be careful -- ensure the data is OK when you've sorted
it. Undo if it isn't. Excel can be brutal with novices when sorting.
There's a piece on sorting at www.smokeylake.com/excel. And if you have
newer releases of Word (where I presume you're doing the mail merge), I
think it can sort them too, as part of the mail merge process. That would
probably be the way to go. It won't trash your worksheet.

Signature

Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

> Hello,
> I have a partial worksheet that I pasted below. I am going to use mail
[quoted text clipped - 14 lines]
> 16599 COX LEONARD D 2160 BRICKYARD RD PRINCETON WV 24740 5 A
> 16831 WHITE TERESA L PO BOX 5095 PRINCETON WV 24740 5 A

Reply to this Message