MSMVPS.COM

The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.
Welcome to MSMVPS.COM Sign in | Help
in Search

Harry Waldron - Microsoft MVP Blog

Security News and Best Practices for corporate and home users

Excel Forums - Excellent Tips and Techniques Information

As I use Excel extensively at work.  About a month ago, I discovered this free forum that allows you to ask questions and get answers by experts.  I've learned so much recently, that previously labourious research and financial reconcilation in Excel have been made much easier and enjoyable (e.g., Pivoting Tables, Advanced Formulas, Table matching, etc). 

The Forum posts are also mapped to the microsoft.public.excel.* newsgroups 

 http://www.excelforum.com/showthread.php?t=584092

Only published comments... Jun 26 2007, 02:02 PM by Harry Waldron

Comments

 

Harold said:

I am working on a formula that has 7 nested IF statements to search a specified cell for different combinations of 3 words with different outputs for all 7 combinations. I had to define ranges and split the formula into 2 seperate formulas to make it work. How do I use the same defined ranges in all the cells in that column?

July 10, 2007 9:54 PM
 

majid memon bhan said:

hi

i cant make out ur tip

September 8, 2007 3:38 PM

Leave a Comment

(required) 
(optional)
(required) 
Submit
Powered by Community Server (Commercial Edition), by Telligent Systems