Excel/Expert Profile

Nathan Head

U.S.
On Vacation
returns 02/15/2010
Expertise

Microsoft Excel questions related to advanced formulas, Pivot Tables, filters, forms, graphs, and just about anything else (EXCEPT Visual Basic Coding/Programming and Macros, I don't have any expertise there).

Experience in the area

I have been using spreadsheets since Lotus 1-2-3 was released. As a CPA, I use spreadsheets every day at work.

Education/Credentials

CPA, Texas

What do you like about this subject?

Learning something new and helping others learn something new!!

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    T = Timeliness    P = Politeness
UserDateKCTPComments
Gareth10/30/0910101010Thanks for this. The formula was exactly .....
Charles10/28/09101010great idea, nice and simple. It doesn't .....
Isabella10/25/0910101010Oh my god, wow Nathan your amazing! .....
solayman.inty10/01/0910101010 
Dominika09/24/09101010 

Recent Answers from Nathan Head

2009-10-29 SUMIF with multiple IF statements:

Gareth: What you need is the SUMPRODUCT function. The following formula is not exactly what you need, but I believe it will be close (adjust as needed for your actual data): Lets assume 11/01/2009

2009-10-28 Trend lines in Excel 2007:

Charles: Good question! 1) Select the line with the actual data points. 2) Right-click on the line and choose format data series. 3) Change marker options to none. 4) Change line color to no line

2009-10-22 rand? generate 1-4 with a twist...:

Isabella: I have uploaded a sample spreadsheet here: http://home.swbell.net/nate-sus/excel/randomizer.xls I must point out I'm not 100% certain I understood the question; however, I took a stab

2009-09-30 excel formula:

solayman.inty: I will presume the above values are in cells A1:B5. Place this formula in cell C1: =ABS(A1-B1) Copy the formula down from C1 through C5. ABS is the Excel function for absolute

2009-09-29 Help:

Steve: The formula you have chosen is one of the best choices to use. You've done the hard work already - now it is just a matter of copying the formula to all of the existing cells. I'm not 100%

 

Ask A Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

All Answers

Answers by Expert:


Ask Experts

Volunteer


©2009 About.com, a part of The New York Times Company. All rights reserved.