This week's tutorial covers a number functions in Google's Spreadsheet app, Google Sheets. Here we take a practical look at using weekdays in calculations, introduce "if" statements and learn how to ...
Microsoft Excel’s RANK.EQ() function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ() with a conditional formatting rule to highlight the top ...
The easiest way to spot a unique value is to format it, and Microsoft Excel offers two ways to do so. One of the most common requests I receive from users is how to identify duplicate and unique ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results