597 reputation
1513
bio website excelninja.blogspot.com
location Washington, DC
age 32
visits member for 4 years, 10 months
seen Jul 3 at 17:51

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 suggested 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 suggested edit on Indirect turns up with #ref error
Jan
29
suggested suggested 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
Jan
24
comment Why does Saturday show up automatically when I use the “TEXT” function in Excel?
+1 for the formula. Great way to handle it. 0 equates to Jan 0, 1900 in Excel's date-speak. Since Jan 1, 1900 was a Sunday, the day before that is "logically" a Saturday.
Jan
24
answered Excel 97-2003 Macro does not work in Excel 2013
Jan
23
suggested suggested edit on Excel 97-2003 Macro does not work in Excel 2013
Jan
22
comment Check value is numeric and no more than n digits
OP stated digits. Hence my response. And even if it was characters, since we are dealing with numbers, it is more reliable to validate within a range (unless you need to limit the numbers after the decimal point).