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