Tell/show your favorite trick(s) in excel.
CountIf()
- Where/when do you use it?
- What are the benefits?
- Are there other options/methods you know about?
- How is it done?
Index(Match)
- Where/when do you use it?
- What are the benefits?
- Are there other options/methods you know about?
- How is it done?
Macro: Aggregate Rows into Columns
- Where/when do you use it?
- What are the benefits?
- Are there other options/methods you know about?
- How is it done?
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