A recent United States Postal Service states that 98 percent of consumers
bring their mail in each day, and that 77 percent of customers sort through
and organize their mail immediately.† As with most self-produced surveys, these
results strike me as being a bit inflated.† However, it makes me think of how
accountants treat their mail during busy season.† For those immersed in the
rigors of the January-April tax season, Iíve heard tales of some accountants
amassing Paul Bunyan-like stacks of mail.† Do you have any tales to share on this subject?
Questions & Advice
Working around #N/A
An #N/A (missing data) populates a vlookup answer cell if the
information is not found in the lookup table for an exact match
(and I don't want to use a fuzzy TRUE match). This error
message (the #N/A) prevents that cell from being useable
(columns won't add and I haven't figured out how to eliminate
it with IF statements buried in the vlookup statement either).
Any suggestions how to work around this dreaded missing data issue?
Add your input!
Merging Cells in MS Excel 2003
I am in the process of organizing some meeting notes using MS
Excel 2003. I am using the merge cell function for my type-
written notes. The problem I am having is the spreadsheet does
not show the full text that I have typed in. I have utilized
the autofit row height function with no luck. Can someone help
me figure out how to get the full text to show on the
Share your suggestions!
Visit AccountingWEB's complete archives, and current quiz by following the links below:
E-Newsletters, Supplements, and Audio Features
This week's CPA review
Get straight to your point, with Checkpoint®
For more than 10 years, accounting, auditing and tax professionals have been turning to Checkpoint®, the revolutionary, easily-searchable online system, to get straight to their answers.
Checkpoint brings together the most trusted information on the most powerful research system available, integrating unparalleled expert guidance, primary source materials and analysis.
Plus, Checkpoint is completely customizable to meet your specific research needs, so you see exactly what you want, and reach your answers faster and easier than ever before.
Try Checkpoint now at NO COST for 30 days. Call 1.800.950.1216 or visit ria.thomsonreuters.com today.
Advertise in the Weekly News Analysis E-Newsletter
Many advertising opportunities are available
Contact Diane Williams, Sales Manager
866-688-1678 x 17 or e-mail firstname.lastname@example.org
Has Outlook blocked your images?
If you need to right-click one of the images in this e-newsletter to see the pictures it's
easy to set up AccountingWEB.com as a 'safe sender' so you don't have to do this every time
you receive an e-newsletter. Select the Actions-Junk Mail menu and pick either the 'Add
Sender' or 'Add Sender's Domain' option.