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