Excel Advanced Filtering

preview_player
Показать описание
Do you feel comfortable using wildcards in your Excel data search? And or Or are two options to narrow your Excel search. Plus if you've ever wanted to copy filtered Excel data and got all data, @TrainerLori shows you how to master Advanced Filtering!
Рекомендации по теме
Комментарии
Автор

Profetal, the easiest option is to prenumber every cell in the column. Put 1 in the first cell then hold CTRL and click and drag the autofill handle (in the bottom right corner of the cell) down to the end. Or to only show a number when there is data copy this formula: =IF(ISBLANK(B2), "", ROW(B2))

TrainerLori