Reputation
770
Top tag
Next privilege 1,000 Rep.
See vote count; VIP usercard
Badges
1 5 14
Newest
 Organizer
Impact
~80k people reached

1d
comment Which Excel functions are array formula friendly?
the list of functions that I usually use, are the ones appropriate to the task at hand. Again, problem first, solution second.
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
14
comment Which Excel functions are array formula friendly?
Generally easier to start with a task to solve and figure out how to do, as opposed to figuring out all the potential ways you could solve a problem if you had one to solve.
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
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
comment How to write this Excel formula in MS Access 2013
@fixer1234 I updated the question with the information the OP put in the comments. I think it's a valuable question, but need more clarification as to whether the OP is looking for a Query, or a calculated column.
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)
Mar
25
comment Weird Calculated Field behavior in a Pivot table in Excel
hmmm... I would suggest that you change your question to include what you are ultimately trying to do. You may find that the way you are approaching this intermediary step could be improved/changed to better suit your end goal.
Mar
24
comment How to plot IP address frequency distribution chart on Excel or Calc?
Using a pivot table would also provide you with a unique list of candidates, and the count of each, which could then be graphed.
Feb
23
comment Excel pivot and chart - hiding field from the chart
you can get away from the concatenation by "Repeating All Label Items" in the Report Layout section of the pivot table design tab of the ribbon. That way you would add the date and project, and they would display like a normal table (each row containing each label)
Feb
23
comment Consolidate Text Data in Excel
start learning pivot tables, great resource for quick calculations.
Feb
23
comment Excel - How to create a stacked radar chart?
@user1542743 To get it to connect from 8 to 1, you just need to repeat the numbers from Stat8 in the Stat1 column on the corresponding rows.
Feb
23
comment Is there a software or web service that allows the creation of basic flow charts from text (such as a numbered or bulleted list)?
You can do this (to some extant) in Word by inserting SmartArt.
Feb
23
comment How could I set a Text Highlight Color—not cell shading—for a specific text within an Excel cell?
@omareg94 you'll see in the screenshot that Excel provides no option to highlight the text, only to change font color, or make sub- or super-script.
Feb
20
comment Excel 2013 spreadsheet is too slow
A few things. You are running XP. No longer supported and likely not tuned to work with Excel 2013. Are you running the 64-bit version of Excel 2013? That could cause issues as XP doesn't support 64-bit anything. You got a new hard drive: fewer RPM? More RPM and not compatible with XP? Does anyone else have the same issues with the file? Especially with a similar software setup?
Feb
11
comment How do I format a MAC address to be separated by colons?
If you need a second opinion, no you cannot do this with a format mask. Format masks work great with numbers, but don't work with text.
Jan
29
comment Placement of Secondary Horizontal Axis
That was it Jon. Didn't think to check the vertical axis properties. Thanks!
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.