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,...
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 – 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...