Formula Friday – Generate Random Odd Or Even Numbers With RANDBETWEEN
Happy Friday Excellers. Today let's look at RANDBETWEEN to generate some random numbers, but we can combine the function with others in Excel which is exactly what we are going to do today. This...
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...
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...