Formula Friday – Use The SubTotal Function To Number Rows In An Excel Table.
Hello Excellers time for some handy #formulafriday tips. This week let's take a look at using the SUBTOTAL Function to easily number our rows in an Excel Table. You may want to number...
Formula Friday – Full Marks! Calculating Weighted Exam Percentages…For The Final Grade.
Hello and time for some more #formulafriday fun. Today we are going to look at calculating some weighted average percentages. I looked up the meaning of weighted average and according to...
Formula Friday – Count How Many Cells In My Range Have A Greater Value Than Another Range Of Cells.
Welcome Excellers to another #formulafriday. Today let's look at a scenario which uses the COUNTIF Function in Excel to find the number of cells we have in one range that are greater than another...
Formula Friday – Find The Missing Values In My Columns Of Data
Hello it's #formulafriday. Time to have some #formulafun with a couple of functions to help me find values that are listed in one column of data and not the other. We are going to use the IF,...
Formula Friday – How About A Date…Converting Text To A Real Date With DATEVALUE
Hello Excellers time for some more #formulafridayfun. How about today we look at using the DATEVALUE function to convert text values in our Excel worksheets to a REAL Date value. First let's...
Formula Friday – Quickly Convert Formulas To Cells Values In Excel
Happy Friday Excellers, and welcome back to some more #formulafriday fun. Today let's take a look at how to easily display only cells values and not the Excel formulas that you have...