 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2005Sort by empty fields
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 Hi Mark, use the AutoFilter at Data=>Filter and then use Custom... Best Markus >-----Original Message----- >Hi: [quoted text clipped - 5 lines] > >. 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) > 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?  SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html 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.... SignatureSven-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: sven_aerts@hotmail.com For eco-techs & game for a better world, visit: http://homepage.mac.com/aertssven ----------- Have a nice day... 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' > for a calc. people must be able to select 1 of 5 possible arguements > if they select: [quoted text clipped - 5 lines] > How do I make such a pull down/scroll field/select field ? > Can't find it in Microsoft Excell.... SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html 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 > 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.