Thread by @exceltoexcel

8 *NEW* Excel Functions that are changing the game!
#excel #learnexcel #excetricks #exceltips

1. UNIQUE Function
- Use UNIQUE Function to remove duplicates: youtube.com/shorts/xgf4Zps…
- Drop-down lists without duplicates: youtube.com/shorts/z-Ok5hS…
- Combine/merge multiple lists without duplicates: youtube.com/shorts/l8ObRSG…

2. FILTER Function
- Use FILTER Function to filter data: youtube.com/shorts/AwKsb5V…
- Find common values between lists: youtube.com/shorts/HlF72AH…
- Use FILTER with AND / OR Criteria: youtube.com/shorts/a_zExgP…
- Select and Filter Multiple non-adjacent Columns: youtube.com/shorts/aGLfHkY…

3. SEQUENCE Function
- Dynamic Yearly Calendar: youtube.com/shorts/SbKgLB6…
- Dynamic Monthly Calendar: youtube.com/shorts/h80IXkR…
- Self-numbering list: youtube.com/shorts/NcNNbED…
- Add serial number (Make sequence): youtube.com/shorts/4jzXfZN…

4. VSTACK Function
- Combine multiple data ranges into one: youtube.com/shorts/XupIlef…
- Combine multiple lists without duplicates: youtube.com/shorts/l8ObRSG…

5. TOCOL Function
- Use TOCOL Function to merge multiple columns: youtube.com/shorts/3xN1Pl0…

6. SORT Function
- Use SORT Function to sort data: youtube.com/shorts/DBfHwmW…

7+8. TEXTBEFORE and TEXTAFTER
- Extract Last Name with TEXTAFTER: youtube.com/shorts/Hf66EVn…
- Extract Middle name with TEXTBEFORE & TEXTAFTER: youtube.com/shorts/5ycWrzL…

Subscribe: bit.ly/3z2rzRw for daily #Excel tips

Don't forget to follow
@exceltoexcel