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 the rows within the table itself instead of relying on the rows numbers in Excel on the left of the screen, which may not always correspond to where your table is on your worksheet. This allows the table to be placed anywhere on the worksheet and your rows numbers will always be correct even if … [Read more...]

## 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 Investopedia - It is an average in which each quantity to be averaged is assigned a weight, and these weightings determine the relative importance of each quantity on the average. This is a great method when some parts of something are more important than others. An obvious example of this is exam … [Read more...]

## 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 range. The example I am going to use is from this data extract of online sales transactions for June 2017. In this data extract I want to see how many sales online are over €10.00. This is ideally the minimum sales value we want for each transaction. Calculating how many sales in June met … [Read more...]

## 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, ISNA and the good old VLOOKUP functions. Here is an extract of my data set. I have Employee ID's from 2016 in Column B and Employee ID's from 2017 in Column C. I want to see which employees are not in the database now in 2017 that were present in 2016. The formula we are going to use is simple … [Read more...]

## Formula Friday – Calculate The First And Last Occurrence Of A Value

Today's blog post will show you how to find the first and last occurrence of a value. I have recently used to find the first date and and the last date that a product appeared in my data set. We can easily achieve this by using the Functions MAXIFS and MINIFS. Both of these are two of the new Functions available in Excel 2016. Suppose my data set look like this extract below. I have a list of products along with the Week Ending Sales Volumes Data. I want to see the first date and the … [Read more...]

- « Previous Page
- 1
- 2
- 3
- 4
- 5
- …
- 18
- Next Page »