Forum Discussion
Haytham Amairah
Feb 22, 2019Silver Contributor
Flash Fill - Wrong Pattern for Filling Month Names
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?
Haytham Amairah
Feb 23, 2019Silver Contributor
Wyn Hopkins SergeiBaklan Detlef_Lewin
Thank you all!
By the way, I also noticed the same behavior in Power Query!
Wyn Hopkins
Feb 23, 2019MVP
yep they're based on the same technology, but at least Power Query tells you the forrmula it's writing which is much safer. As Sergei says, I don't trust FlashFill further than a I can see.