Excel 2013: Flash Fill

preview_player
Показать описание
Quick look at the Flash Fill feature in Excel 2013 to extract data from a single column
Рекомендации по теме
Комментарии
Автор

I can't tell you how many people I've helped write MID functions to separate text. This will save so much time in data processing

Ers
Автор

Thank you for making it quick and easy!

barbarastirling
Автор

thanks, I understand how to use it now.

Jedsa
Автор

Can't get this to work. Need to click in bottom right of cell and click and copy is default do beef to click flash fill each time

Jimbob
Автор

not true. I have been having an issue with using flash fill. I have 1300 cells that need to be filled in and flash fill would be great but its not working..sometimes it does and sometimes it doesn't, it also doesn't always follow the structure that I am using. So be aware that this FlashFill is still very buggy, and double check your work after using FlashFill, ALWAYS!

kewllp