Forum Discussion
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?
The opposite would work (extract first 3 characters). There has to be some pattern.
Or type January then double click on the corner of the fill handle to create list of full months.
I see what you're saying but I don't think it's unexpected behaviour
Or type January then double click on the corner of the fill handle to create list of full months.
I see what you're saying but I don't think it's unexpected behaviour
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.