Formula Friday – Easily SUM Values From Different Excel Sheets With The Same Cell Address
Time for some more Friday Formula Fun. Today we are looking at the good old SUM function, but we are going to use it to SUM the values from the same cell in multiple Excel worksheets. What does...
Formula Friday – Write Formulas Faster With Auto Correct In Excel
Hello Excellers, time for some more formula fun, or some fast formula writing fun. Let's look at using one of Excel's features - Auto Correct and put it to another use to speed up Formula...
Hello Excellers, time for another Formula Friday. Today let's look at calculating the percentage of the year that is completed and that is remaining really easily using the YEARFRAC function in...
Formula Friday – Sum Formula Not The Best Solution? Try Subtotal!
Today's Formula Friday will be looking at the Sum Function vs the Subtotal Function. If you want to download the Formuala Friday examples you can so so here [wpdm_package id='10703'] Even...
Formula Friday – Generate Random Interview Name Lists No Repeats In Excel
I love Friday, as it is time to share more Formula Fun. Today let's look at generating some random names against times slots which are going to use to schedule interview times for potential...
It's Friday so that means some more Formula Fun. Today let's look at calculating the percentage of cells in a range that contain a specific string. I have used this to as an alternative to a...