Nathan Head - Excel - Business Software - Computing/Technology

About > AllExperts
	Search for

Main Menu

Login (Experts Only)

About Us · FAQ · Tell Friends About Us · Link To Us · Free Encyclopedia · Disclaimer · Tech Support

You are here: AllExperts > Computing/Technology > Business Software > Excel

Expert Profile: Nathan Head

Expertise: Microsoft Excel questions related to advanced formulas, Pivot Tables, filters, forms, graphs, and just about anything else (EXCEPT for VB 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

	View Past Answers	View Detailed Ratings

What do you like about this subject? Learning something new and helping others learn something new!!

Average Ratings
Prestige Points: 9950
Knowledge	9.95 Best of the best
Clarity of Response	9.93 Best of the best
Timeliness	10.0 Best of the best
Politeness	9.97 Best of the best
Number Of Questions (in Past 24 Hours)		0
Max Questions to be Asked (in 24 Hour period)		2
Total Questions (since joining AllExperts)		981

Recent Reviews from Users

Knowl	Clarity	Time	Politeness	Date
10	10	10	10	10/29/08
8	10	10	10	10/28/08
10	10	10	10	10/27/08
10	10	10	10	10/27/08
10	10	10	10	10/26/08

User Comments

Nathan was of great help on a rather complex sumproduct formula. He helped me fix my issue within the day and I was able to generate the expected report!
(Catherine on 10/29/08)

Very quick response.
(Joseph on 10/28/08)

Answer was explained well.
(Tom on 10/27/08)

Thanks, Nathan, that was a helpful explanation. --dave
(Dave on 10/27/08)

Thankyou.
(Annette on 10/26/08)

View All Comments

	View Past Answers	View Detailed Ratings

Recent Answers from Nathan Head

2008-10-29 SUMPRODUCT or other solution...: Catherine: Try entering the formula as an array formula. This means wheny you confirm the function you enter it with CTRL-SHIFT-ENTER instead of simply ENTER. A correctly entered array formula will...

2008-10-29 SUMPRODUCT or other solution...: Catherine: You have the right idea; however, I suspect you may have had some glitches or mismatched parenthesis on the formula entry. Here is the formula I developed: =SUMPRODUCT((IF(A2="all",1...

2008-10-28 Date Formula: John: Lets assume you have a series of 12 dates in the range A1:A12 1/1/2008 2/1/2008 3/1/2008 4/1/2008 5/1/2008 6/1/2008 6/1/2008 9/1/2008 9/1/2008 9/1/2008 11/1/2008 12/1/2008 What...

2008-10-28 Filters: Joseph: Without visual basic programming (which I cannot help you with...that is a completely different area of expertise), I would suggest the following: 1) Click data->filter to set up the currently...

2008-10-27 Top 5 Values: Tom: This will require an array function that uses both LARGE and FREQUENCY. The LARGE function grabs the Nth largest item in a list. The only problem with this is it will not ignore duplicates...