If you using Excel versions prior to 2013 then you may want to look away now...only kidding!!!! But this tip really does only apply to Excel 2013 onwards, that is the ability to count unique items in...
Category: Formulas
Formula Friday – Using The AND Function To Highlight Cells Meeting Multiple Logical Conditions
HAPPY FRIDAY EXCELLERS. More Formula Fun time.... Today let's look at a small but mighty powerful formula. AND. We can use it to test multiple conditions ( up to 255 logical ones!). The...
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,...