Tell/show your favorite trick(s) in excel.

CountIf()

Index(Match)

Macro: Aggregate Rows into Columns

Tips and tricks from the community

Concatenate() columns to create a new value used in finding duplicates across multiple columns

Use conditional formatting with the Match() function to do something similar to CountIf() above

ExcelNow add-in for excel with tutorials, templates, quizzes and more