============================================================
--------      TIP OF THE DAY for November 24, 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://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122492-0-0-0-1

============================================================
**********            Sponsored by AT&T           **********

Get unlimited calling in the U.S. and to Canada through 
your broadband connection and save at least $200 with 
AT&T CallVantage(sm) Service.  Just $19.99/mo. for the 
first 6 months. 
http://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122495-0-0-0-1

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

Category: Microsoft Excel

Advanced Ranking in Excel

"I have columns of students, band instruments, and tryout 
scores. I want to rank them automatically with some sort of 
formula. I know I could get the highest and lowest using Max 
and Min, but I need to have them ranked 1, 2, 3, and so on, 
from the highest score down. I also need the ranking for each 
instrument separately. The solution should also give the same 
number to any ties (there aren't supposed to be any ties, but 
I want to be prepared)."

For the solution, click below: 
http://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122498-0-0-0-1

For more Solutions, click below: 
http://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122501-0-0-0-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://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122504-0-0-0-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://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122507-0-0-0-1

More Books 
http://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122510-0-0-0-1 

============================================================ 
Tech Jobs 
http://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122513-0-0-0-1

============================================================ 
Ziff Davis Channel Zone 
http://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122516-0-0-0-1

============================================================ 
DevSource 
http://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122519-0-0-0-1

============================================================ 
Free White Paper 
Brought to you by Remedy 
============================================================ 

Right now, business is planning a change to the IT infrastructure. 
ARE YOU READY? Download your free white paper, Balancing IT 
Responsiveness and Control -- Ten Things To Consider When 
Developing a CCM Strategy. 

Download this free white paper and find out more! 
http://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122522-0-0-0-1

============================================================ 
Upcoming Events
============================================================ 

Ziff Davis Media Unveils An Exclusive Security Virtual Tradeshow!

This live, two-day Virtual Tradeshow will highlight the leading 
security threats facing your company and provide you with the 
necessary safeguards on how to combat future attacks! Hear from 
security experts such as Dan Larkin, Unit Chief, Internet Crime 
Center at the FBI and Steve Wozniak, Co-Founder of Apple Computer 
and many more! Nov. 30th and Dec. 1st, 2004. Register today and 
attend for free right from your desktop! 
http://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122525-0-0-0-1

============================================================ 
Elsewhere on Ziff Davis Internet 
============================================================ 

IE Exploit Targets Banner Ad Servers  
http://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122528-0-0-0-1

Google Fights Click Fraud  
http://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122531-0-0-0-1

Kidz Gear Headphones for Kids 
http://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122534-0-0-0-1

Novell Launches New Linux Operating System 
http://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122537-0-0-0-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://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122540-0-0-0-1&[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://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122543-0-0-0-1

If you'd like to advertise in our eNewsletters, visit: 
http://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122546-0-0-0-1

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

Having problems?  Consult our Frequently Asked Questions 
(FAQ) page at: 
http://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122549-0-0-0-1

============================================================ 
PC Magazine Print Subscriptions 
============================================================ 
Start or Renew a subscription:
http://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122552-0-0-0-1

Give a gift subscription: 
http://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122555-0-0-0-1

Help with your subscription: 
http://ct.enews.pcmag.com/rd/cts?d=184-1273-5-55-280167-122558-0-0-0-1

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

Reply via email to