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...]

## 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 look at the DATEVALUE syntax which is really straightforward. DATEVALUE =DATEVALUE(date_text) where date_text is a required argument which is a text string representing a date. Excel will return a serial number which represents a date in Excel. There are a couple of benefits to … [Read more...]

## 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 written. Let's take this Excel formula I have written as as example- So, we only need to hard coded cell values not the formulas in Column D. I have two ways to do this. Method 1. Use Copy Paste Special You probably know this method. Copy the cells that contain your formulas by hitting CTRL+C … [Read more...]

## Formula Friday – How To Highlight All Cells That Contain A Formula Using ISFORMULA

Hello Excellers Happy Friday and it's time for some more #formulafriday fun. Today let's look at how to use the ISFORMULA function to achieve the following To test a cell reference to see if it contains a formula Conditionally format a cell reference if it does contain a formula. This is really useful if you need to see all of the cells that contain formulas at once on your Excel worksheet. You could use the GOTO option in Excel, but in this way you can highlight your formulas … [Read more...]

- « Previous Page
- 1
- 2
- 3
- 4
- …
- 34
- Next Page »