Formula Friday – Convert All Of Your Text To Upper Case Using…You Guessed It The UPPER Function
Hello Excellers. I love Friday Formula time. Don't forget to #followfriday on Twitter...... This is a really useful formula, and one that a lot of Excel users dont use that often, in fact,...
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...