I touched briefly on the MIN and MAX functions in my recent How To Excel At Excel Newsletter. If you want to sign up for 3 top tips every 15 days then just enter your email address here and as...
Category: Formulas
Do you need to clear just the numbers from your Excel worksheet?. I know I do this regularly if I have a worksheet I want to re -use for example a generic input form and I want to keep all of the...
A tally or a running total can be carried out on data in Excel with a range of formulas, but it is really easy to do the same thing simply, with a pivot table. Let's use an example with some random...
Do you ever get reams of paper printing at the end of your worksheet? I have been asked about this a few times, even if users have deleted their empty rows that they no longer use, when they hit...
When you format cells in Excel as percentages, Excel will then automatically format the cells as you type into them. All is well and good if your figure is under 1, once you start to enter figures...
Need to find duped values in your Excel data?. Do want them to jump out at you?. It's very easy to achive this using Conditional Formatting. You need to firstly set up the...