597 reputation
1513
bio website
location Seattle, WA
age 32
visits member for 5 years
seen Jul 3 at 17:51

Nov
8
comment Excel functions showing wrong results
I second Barry's result. I also get 1.984.
Nov
8
answered Amortization Schedule in Excel - Know how much interest will be saved by large payment
Nov
6
comment Highlight Peak Point Excel 2010
It is possible to hide the extra column of data with a change to the chart properties. Also, once the formulas are entered there is should be no other interaction needed.
Nov
6
revised Highlight Peak Point Excel 2010
added 502 characters in body
Nov
6
answered Highlight Peak Point Excel 2010
Nov
5
answered Excel: resize chart sheet
Nov
4
comment How to sort time column by value instead of alphabetically
Excel does understand dates and times, but only when they are formatted as such. I see that the data is stored as a date in the DB, but is it coming into Excel as a date? What happens if you try to divide one of the dates by two? (i.e. in Cell C2 type '=A2/2" without the quotes). This will let us know how it is stored in Excel.
Nov
4
comment Line chart from multiple tables in Excel 2013
why do you need multiple tables? If there is something different about each table, you could combine them all and include an additional column to distinguish the values. This will make it easier to draw your charts, too.
Nov
4
comment Multiple if functions
Genius solution!
Nov
1
answered Excel - Referring to a certain cell based off of data in another
Nov
1
comment Merging data tables to form one master table
No update after a month, with no clarification from the OP. This should be closed.
Oct
31
comment How to automate transforming a table into a matrix
have you tried putting all of this information in the 'row labels' section of the pivot table fields and messing around with formatting? The values area will only aggregate, but the row labels become subsets.
Oct
31
comment Flatten Excel Formula (2007)
What you are asking is legitimate, but functionally it isn't ideal. Complex calculations are very difficult to troubleshoot. It is best practice to show your calculation, even if the details of the calculation are ultimately hidden from the end user.
Oct
31
accepted custom format for cells with nothing in them without using conditional formatting
Dec
14
awarded  Notable Question
Dec
6
awarded  Famous Question
Nov
14
awarded  Revival
Oct
7
awarded  Yearling
Jul
17
awarded  Popular Question
Mar
3
awarded  Notable Question