Sort by empty fields

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
 
M

Markus Scheible

Hi Mark,

use the AutoFilter at Data=>Filter

and then use Custom...

Best

Markus
 
S

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: [email protected]

For eco-techs & game for a better world, visit:
http://homepage.mac.com/aertssven
 
D

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'
 
M

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
 
Top