Reputation
815
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 7 14
Newest
 Yearling
Impact
~117k people reached

Jan
28
asked Placement of Secondary Horizontal Axis
Nov
12
comment Excel 2010 Chart Not Printing To Size
Does this question on the Answers Microsoft forum work?
Nov
7
comment Excel 2010 Chart Not Printing To Size
Move the chart to it's own Chart Sheet and see if that fixes the issue.
Nov
6
answered Create a double group scatterplot
Feb
28
comment Is there a limit to how many separate wifi networks can successfully and securely operate within a given (building) area without interference issues?
+1. Cheers, mate. Seems like you had a bad day yesterday :)
Feb
11
comment How do you make a set of cascading dropdown lists in excel?
You are correct in stating that this should be done in a database. The contextures link is great, but as you say has limitations. The main being that Excel is not a Database. I would suggest moving your solution to something more suited towards your requirements.
Feb
11
awarded  Yearling
Feb
10
revised Why is this Excel formula returning two different values?
Updated to show that the `iferror` formula is available back to 2007
Feb
10
comment How do you make a set of cascading dropdown lists in excel?
www.Contextures.com has a page exclusively for this, with a more robust solution than then other answer here. The page is titled "Create Dependent Drop Down Lists" and can be found here.
Feb
10
suggested approved edit on Why is this Excel formula returning two different values?
Feb
4
answered How do I make excel label every bar in a bar chart?
Feb
4
comment How do I filter pivot table rows by values?
added as an answer. If you mark as complete, it may help others with the same questions. Glad it worked for you.
Feb
4
answered How do I filter pivot table rows by values?
Feb
3
comment How do I make excel label every bar in a bar chart?
What happens if you change the size of the chart?
Feb
3
comment How do I filter pivot table rows by values?
Your link tells you how to do what you are looking for. Just select Value Filters and enter greater than 1.
Jan
29
revised Indirect turns up with #ref error
update formatting and grammer
Jan
29
revised Indirect turns up with #ref error
updated formatting and spelling
Jan
29
suggested approved edit on Indirect turns up with #ref error
Jan
29
suggested approved edit on Indirect turns up with #ref error
Jan
24
revised Excel 97-2003 Macro does not work in Excel 2013
Moved code from comments to question