Sort by empty fields

  • Thread starter Thread starter Mark Flynn
  • Start date Start date
M

Mark Flynn

Hi:
I have a mailing list, and about 1/3 of the records do not have email
addresses.
QUESTION: how do I sort the list so that only the records with empty email
address fields appear?
Thanks, Mark Flynn
 
for a calc. people must be able to select 1 of 5 possible arguements
if they select:
Org 1 then membershipfee = 1
Org 2 then membershipfee = 2
Org 3 then membershipfee = 5
etc....

How do I make such a pull down/scroll field/select field ?
Can't find it in Microsoft Excell....


--
Sven-Brussels
GSM: +32 (0)485/389679
ExcelXv1-OSX.3.2.Panther-IBook-600MHz-640MB SDRAM-14GB HD-Airport-QWERTY
Keyboard
CHAT : ICQ UIN: 113835655 - YahooID: aertssven -
AOL Instant Messenger Screen Name: aertssven1 -
MSN Messenger Passport ID: (e-mail address removed)

For eco-techs & game for a better world, visit:
http://homepage.mac.com/aertssven
 
Somewhere in the workbook, create a list of organizations and membership
fees.

In your main table, you could use data validation in one cell, to choose
the organization. Then use VLOOKUP formulas to return the matching
membership fees in the adjacent cells. There are instructions and
examples here:

http://www.contextures.com/xlFunctions02.html

There's a sample invoice that uses data validation and VLookup formulas
here:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Invoice for Selected Number'
 
Hi Marcus, Debra and Sven:
Thank you all for your prompt responses, and help.
I greatly appreciate your time and expertise.
Best regards, Mark Flynn
 
Back
Top