EXCEL - not an expert
Home
Contact
THEMES
1. Sort unique filtered values
2. Concatenate
3. Data validation using “Name Manager”
4. Countifs
5. Averageif and Averageifs
6. Unique values on a filtered table
7. Total of values on a filtered table
8. Controlling Repeated values using “Name manager”
9. Controlling values not included in a another table
10. Slicer
11. Unique values per month on a filtered table
12. Total of values per month on a filtered table
13. Swiping down all filled values
14. PictureLookup
15. Unique values filtered by date
16. Sequence by rows
17. Randarray and Textjoin
18. Timestamp non volatile
Others
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
13. Swiping down all filled values based on colour
PLEASE SEE VIDEO