Formula Friday – Excel Rank Function – Who is The Leader Of The Pack?
Hello, Excellers. Welcome back to another blog post in my #FormulaFriday series. Today it is back to basics exploring the Rank function in Excel. The rank Excel formula will compare numbers...
Formula Friday – Find The Highest or Lowest Value In A Row and Return the Column Heading
Today's #formulafriday Excel tip will show you how to identify the the highest or lowest value in a row of data and return the column heading or title. So let's say you have some data set out as...
Wow that was a quick week it is Friday again and that means another #formulafriday You can download the example workbook for this Excel tip below. [ddownload id="9577"] Today...
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,...
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...