The AND remix for the popular IF function can save at least 180 seconds of your time. 

This Excel Q&A by Philip Gamey will show you how to create one IF statement that checks for two conditions before returning a result.

One way is to sort from largest to smallest and write numbers by each another is to use RANK FX

This Excel Q&A shows how to use the RANK function to rank customers by their revenue.