Filter data using checkboxes. #Excel #exceltutorial #exceltips | Excel Basics

14K views · 127 reactions | Excel Ranking Brilliance: Use LARGE and...

Use this function to rank lists in seconds. Obviously you could sort a list and find the highest values easily. But this allows you to keep your list sorted in place and still see the relative rank. Newer functions in Excel and Google Sheets use RANK.AVG and RANK.EQ. Those differ in how they handle ranking items that have the same value. I use plain RANK for most of my needs. But you can look into those other functions if you have lots of values that might be the same. #excel #googlesheets #work