Find The Last Value In An Excel Row Using Index And Count Functions.
I have used this formula on a regular basis to return the last value in my rows of data, handy if you add in new values every month to an Excel spreadsheet but always want to return the most recent...
Formula Friday – Conditionally Format An Excel Chart With IF Function
Happy Friday Excellers, you are probably thinking two things here as you have read the title of the blog post..... We can't use conditional formatting in charts I thought this was...
Prevent Duplicate Entries In A Data Range Using Data Validation and The COUNTIF Formula
Sometimes is is not enough to just highlight duplicate values using conditional formatting in Excel, sometimes you just do not want to allow users to enter duplicates. For example if you are...
Friday Formula time..... Today let's look at a handy formula for transforming an email address into a name, without the email address junk that is associated with it. At work I get data...
Formula Friday – Highlight Expired Policy Numbers With Conditional Formatting In Excel.
Happy Friday Excellers, time for some Formula Fun. Today a simple formula to conditionally highlight any policy numbers in our data set that are out of date. Here...
Have you come across a data set that looks a bit like this?. The source data in your Pivot Table is not as clean as it should be with a slight variation in spelling that is a right pain in the...