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

Apr
22
suggested approved edit on Macro to Copy Hyperlink from Another Sheet
Apr
22
suggested approved edit on Running macro on multiple sheets
Apr
20
revised Run EXCEL VBA code in separate workbooks in sequence
replace 'macros' tag with 'vba'.
Apr
20
suggested approved edit on Run EXCEL VBA code in separate workbooks in sequence
Apr
17
revised Excel, macro move one row down and then delete the row
replace macro tag with vba
Apr
17
revised How to give worksheet tab a color if range of cells contains text
inappropriate use of macro tag
Apr
17
revised How to export images from Excel table
replaced macro tag with vba
Apr
17
suggested approved edit on How to give worksheet tab a color if range of cells contains text
Apr
17
suggested approved edit on Excel, macro move one row down and then delete the row
Apr
17
suggested approved edit on How to export images from Excel table
Apr
15
comment Calculate total number of open item at each month in Powerpivot
I think that would assume that there is a close date entered. Although absent any other information from the OP, who knows?!
Apr
9
revised What prevents Excel from staying current with the years. For instance, why aren't I using Excel 2015?
Removed inappropriate tags
Apr
9
comment making a running total for excel using countif function, 1 out of 14 drop down options don't work
Can you provide the formulas you are trying? Also some data can help so that we can see what the answer should be.
Apr
9
answered Excel 2011 plotting difference between logged sent-time / acknowledgment-time
Apr
9
suggested approved edit on What prevents Excel from staying current with the years. For instance, why aren't I using Excel 2015?
Apr
7
comment How can I make a Scattered chart in excel where the dots are different colors?
I've got an idea, but a question for you first, how many importance levels are there? Will that number ever change?
Apr
7
comment Excel: Get rid of gaps in line chart
There really isn't a way to do this outside of what you've already described. On another note, I'd caution against this, as connecting the dots (so to speak) can infer that there is data that doesn't really exist, and can be misleading.
Mar
30
revised Different colored columns in excel
clarified the type of chart needed.
Mar
30
answered Different colored columns in excel
Mar
26
comment Weird Calculated Field behavior in a Pivot table in Excel
By "Number of items in your pivot table" you mean distinct number of items? Which for purposes of your data above, the Grand Average would equal 3.5? (7 line items/2 distinct items in Day column)