Data Validation List Remove Duplicates, Not Past 33,000? TRUE: Then Go Old School! EMT 1878
Автор: excelisfun
Загружено: 2025-03-14
Просмотров: 3680
Download Excel File: https://excelisfun.net/files/EMT1878....
See that the Data Validation List feature removes duplicates up to 33,000 rows. After that, we must do old school methods: SORT and UNIQUE functions, or even older school methods from the 2012 Ctrl Shift Enter Mastering Excel Array Formulas Book.
ExcelLambda from YouTube supplies awesome solution!
Topics:
1. (00:00) Introduction
2. (00:03) New Ability of Data Validation List to Remove Duplicates
3. (01:06) Example of New Feature When It Does Not Work Poast Rows 33,000
4. (01:27) Old Fashion Way to Overcome New Feature Limited Row Ability
5. (02:20) Summary
6. (02:29) Closing
#excel #microsoft #excelisfun #excelcourse #datavalidation #excelfail
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
