Sort by empty fields

[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

 

[Markus Scheible]

Hi Mark,

use the AutoFilter at Data=>Filter

and then use Custom...

Best

Markus

 

[Debra Dalgleish]

You can use an AutoFilter to show the records. There are instructions here:

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

From the dropdown list in the Email column heading, choose (Blanks)

 

[Sven Aerts]

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

 

[Debra Dalgleish]

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'

 

[Mark Flynn]

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