Feb 21 2019 11:59 PM
Hi all,
This is what the Flash Fill suggests to fill the full month names!
It should be smart in this regard to recognizes this simple pattern!
What do you think?
Feb 23 2019 02:19 AM
Feb 23 2019 02:25 AM
Yes, that's expected behaviour and that's why I prefer not to use Flash Fill on relatively big ranges - you always have to check if it found correct pattern for all data.
Feb 23 2019 02:58 AM
Feb 23 2019 03:45 AM - edited Feb 23 2019 03:45 AM
@Wyn Hopkins @Sergei Baklan @Detlef Lewin
Thank you all!
By the way, I also noticed the same behavior in Power Query!
Feb 23 2019 04:32 AM
@Haytham Amairah , not the same but related topic is here https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/33539752..., you may vote
Feb 23 2019 04:47 AM