You cannot change the default Row (1,2,3,…) and Column (A,B,C,D….) headers, but a workaround is:
1. Enter what you’d like to be your Row Headers in the first column after cell A1
2. Enter what you’d like to be your Column Headers in the first row after cell A1
3. Format first row and column to match the default headers
4. Go to Tools>Options>View Tab>Clear the Row & column Headers check box.
Now, your sheet might look like this:
In this short video you can learn how to assign a macro to a button on your toolbar. If this macro is in the personal workbook then you can use it on any workbook.
If you want to count cells in a given range without formulae use this function
If you want to count cells with formule then just remove then “Not” in front of c.HasFormula
To calculate the average of n biggest numbers from a list enter this formula with Ctrl + Shift + Enter:
To calculate the average of n smallest numbers from a list enter this formula with Ctrl + Shift + Enter:
For an example:
I didn’t know this before today when an user at MrExcel wondered why he was not getting consistent answers with Excel and VBA. The key is negative numbers.
If you happen to have negative numbers (one of them) and you want to calculate MOD, you should use this code in VBA
Where n is your number and d is your divisor.
For more info, check:
MOD Function and Mod Operator Return Different Values
Written by
Recent Comments