Reputation
795
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 5 14
Newest
 Organizer
Impact
~89k people reached

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
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