============================================================
--------     TIP OF THE DAY for August 26, 2004     --------
--------      from the editors of PC Magazine       --------
--------             www.pcmag.com/tips             --------
============================================================

For more useful tips and tricks, check the Tips page 
(and scroll down to search Tips by category) 
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96182-1

============================================================
*****    Sponsored by Xerox Office Printing Business   *****

The world's fastest workgroup color printer has the speed of 
a true thoroughbred.

Enter to win an $11,000 Business Upgrade or a Phaser 7300 
Color Printer.

Visit http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96185-1 
to enter.

************************************************************
============================================================
TODAY'S TIP

Category: Excel

Asterisk Foils VLOOKUP

"I'm having difficulty using the VLOOKUP() function with the 
range_lookup argument--set sometimes to True and sometimes 
to False--to try to find part numbers with names like 
700*BTM17530A*2*XL and 700*BTM17530A*XL in a huge list.  
What's the problem?"

For the solution, click below: 
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96188-1

For more Solutions, click below: 
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96191-1

E-mail questions and tips to [EMAIL PROTECTED]

============================================================ 

The PCMag.com Bookstore

PC Magazine's Windows XP Solutions
Ever wish they'd consulted you before they designed Windows XP? 
Sure, it's a great system, but there's this one feature that 
makes you crazy. Or that annoying problem that keeps occurring. 
Well, you can rely on Neil Randall and your friends at PC 
Magazine to correct that oversight. Here's the complete compendium 
of solutions to the things that bug you, threaten your security, 
slow you down, or other-wise prevent Windows XP from running like 
it should.
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96194-1

PC Magazine Guide to Home Networking
Ready to plunge into creating your own home network?  Reading 
this book is like having PC Magazine contributing editor Les 
Freed drop by and set the whole thing up for you. 
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96197-1

More Books 
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96200-1 

============================================================ 
Tech Jobs 
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96203-1

============================================================ 
Ziff Davis Channel Zone 
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96206-1

============================================================ 
DevSource 
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96209-1

============================================================ 
Free Special Report
Brought to you by St. Bernard 

A legal nightmare could be the next thing your users 
download from the Internet. 

Find out about an Internet filtering appliance that is the 
easy, reliable way to protect your organization from costly 
legal liability, unnecessary bandwidth drain and decreased 
productivity. 


Read more about this problem in a timely Special Report: 
Internet Filtering Alternatives
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96212-1

============================================================ 
Upcoming Events
============================================================ 
8/31 Part One: The Basics of HDTV
FREE eSeminar! We start off our two-part series with an 
hour-long seminar dedicated to the basics of HDTV. 
ExtremeTech.com editors will discuss resolutions, the 
difference between "HDTV" and "EDTV" and the basic display 
types, including plasma, DLP and LCD. Then we will discuss 
what to watch with an overview of programming sources, 
including VOOM, DirecTV, Dish Network, HDNet, cable and 
more. Register now.
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96215-1

============================================================ 
Elsewhere on Ziff Davis Internet 
============================================================ 
Building a Super Tiny Home Server
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96218-1

Microsoft Preps for the Next XP SP2 Wave
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96221-1

Terrorist Strike, Cracked Code Threaten Internet?
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96224-1

Single Box Integrates Multiple Media
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96227-1

============================================================ 
eNewsletter Information 
============================================================ 
You are subscribed to TIP OF THE DAY with the e-mail: 
[EMAIL PROTECTED]

To unsubscribe to this newsletter, click below: 
http://www.pcmag.com/unsubscribe_newsletter/0,4223,,00.asp?n=39&type=u&[EMAIL 
PROTECTED]

To change your e-mail address, change your text/HTML 
preferences, or to subscribe to other FREE PC Magazine Online 
e-mail newsletters, visit: 
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96230-1

If you'd like to advertise in our eNewsletters, visit: 
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96233-1

Questions or comments regarding this newsletter?  E-mail 
mailto:[EMAIL PROTECTED]

Having problems?  Consult our Frequently Asked Questions 
(FAQ) page at: 
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96236-1

============================================================ 
PC Magazine Print Subscriptions 
============================================================ 
Start or Renew a subscription:
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96239-1

Give a gift subscription: 
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96242-1

Help with your subscription: 
http://eletters.pcmag.com/zd1/cts?d=81-1044-5-2-280167-96245-1

Copyright (c) 2004 Ziff Davis Media Inc. All Rights Reserved. 
Ziff Davis Media Inc., 28 East 28th Street, New York, NY 10016

[Non-text portions of this message have been removed]



------------------------ Yahoo! Groups Sponsor --------------------~--> 
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/BCfwlB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/kumpulan/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 

Reply via email to