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

Jun
18
comment Plotting multiple datasets of different lengths on the same scatter graph in Excel 2010 (extended)
just pick the largest length and use that. If a particular series isn't the same length it just won't plot anything for the empty cells.
Jun
18
comment Seeing email thread in email body on ipad, but not on pc
does he have the conversations feature turned on in Outlook?
Jun
18
awarded  Yearling
Jun
1
comment Forcing axis units in Excel 2013 plots, being written after minimum bound of axis
@Mr.Mascaro: I agree, with a caveat, that it depends on the story you are trying to tell, and how you tell it. You should not change the axis to be misleading, but the axis range can be used to highlight min and max vaiues.
May
28
awarded  Notable Question
May
14
answered How can I set a cell value based off of what another cell contains?
May
7
revised Excel Macro insert value into another cell
Replaced 'macro' tag with 'vba'. 'Macro' not appropriate here.
May
7
revised macro for arranging data into a column
Removed 'macro' tag. not appropriate here.
May
7
suggested approved edit on Excel Macro insert value into another cell
May
7
suggested approved edit on macro for arranging data into a column
May
7
answered Calculate date average in excel
May
7
comment Calculate date average in excel
This will give you the average month, and the average day of the month. It will not, however, return the average month/day of the year.
May
7
comment Rule to dim cells
If you are changing the color, why not use the built-in Conditional Formatting feature in Excel? Regardless, you'll need to share some code if you want anyone to help.
May
5
revised Excel 2013 - Multiple Countifs
edited formula for readability. added image.
May
5
comment Excel 2013 - Multiple Countifs
@miltonb if you know of a way to have a pivot table do this, please post it as an answer.
May
5
suggested approved edit on Excel 2013 - Multiple Countifs
Apr
28
comment Excel Charting - How to edit the X axes for positive value on both sides?
Short answer, anything you want to show to the left of the axis you have to change to a negative value (even if it is positive), then use custom number formatting in the axis to show positive instead of negative left of the 0 value of the axis.
Apr
22
revised Macro to Copy Hyperlink from Another Sheet
replace `macro` tag with `vba`
Apr
22
revised Running macro on multiple sheets
remove macro tag
Apr
22
suggested rejected edit on Using IF to compare name of a worksheet with worksheets in workbook