Excel Tips| Dynamic Count Using Aggregate Function

Here are a few excel tips that might interest you:

Dynamic Second Smallest Value:

Dynamic Second Largest Value:

Dynamic Min Using Aggregate Function:

Dynamic Max Using Aggregate Function:

Dynamic Average Using Aggregate Function:

Dynamic Sum Using Aggregate Function:

Hiding Errors:

Stacking Tables:

Deleting Blank Spaces:

Converting Units:

Highlighting Data Using Conditional Formatting:

Using Sum product & Rank Functions:

Automatic Numbering a List:

Using Formatting & Unique Function to identify duplicates: