Home

Flash Fill - Wrong Pattern for Filling Month Names

%3CLINGO-SUB%20id%3D%22lingo-sub-355213%22%20slang%3D%22en-US%22%3EFlash%20Fill%20-%20Wrong%20Pattern%20for%20Filling%20Month%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355213%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20what%20the%20Flash%20Fill%20suggests%20to%20fill%20the%20full%20month%20names!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20845px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F84034i81638A32F4FC4752%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Flash%20Fill%20-%20Wrong%20Pattern.png%22%20title%3D%22Flash%20Fill%20-%20Wrong%20Pattern.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EIt%20should%20be%20smart%20in%20this%20regard%20to%20recognizes%20this%20simple%20pattern!%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EWhat%20do%20you%20think%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-355213%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355759%22%20slang%3D%22en-US%22%3ERe%3A%20Flash%20Fill%20-%20Wrong%20Pattern%20for%20Filling%20Month%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355759%22%20slang%3D%22en-US%22%3Eyep%20they're%20based%20on%20the%20same%20technology%2C%20but%20at%20least%20Power%20Query%20tells%20you%20the%20forrmula%20it's%20writing%20which%20is%20much%20safer.%20As%20Sergei%20says%2C%20I%20don't%20trust%20FlashFill%20further%20than%20a%20I%20can%20see.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355757%22%20slang%3D%22en-US%22%3ERe%3A%20Flash%20Fill%20-%20Wrong%20Pattern%20for%20Filling%20Month%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355757%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3B%2C%20not%20the%20same%20but%20related%20topic%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F33539752-add-short-month-name-and-short-day-name-in-power-q%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F33539752-add-short-month-name-and-short-day-name-in-power-q%3C%2FA%3E%2C%20you%20may%20vote%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355754%22%20slang%3D%22en-US%22%3ERe%3A%20Flash%20Fill%20-%20Wrong%20Pattern%20for%20Filling%20Month%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355754%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20all!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBy%20the%20way%2C%20I%20also%20noticed%20the%20same%20behavior%20in%20Power%20Query!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F84178iD95D91B68C445BB0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Add%20Column%20From%20Examples.png%22%20title%3D%22Add%20Column%20From%20Examples.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355744%22%20slang%3D%22en-US%22%3ERe%3A%20Flash%20Fill%20-%20Wrong%20Pattern%20for%20Filling%20Month%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355744%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20that%20particular%20case%20don't%20use%20Flash%20Fill%20but%20Auto%20Fill.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355741%22%20slang%3D%22en-US%22%3ERe%3A%20Flash%20Fill%20-%20Wrong%20Pattern%20for%20Filling%20Month%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355741%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20that's%20expected%20behaviour%20and%20that's%20why%20I%20prefer%20not%20to%20use%20Flash%20Fill%20on%20relatively%20big%20ranges%20-%20you%20always%20have%20to%20check%20if%20it%20found%20correct%20pattern%20for%20all%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355738%22%20slang%3D%22en-US%22%3ERe%3A%20Flash%20Fill%20-%20Wrong%20Pattern%20for%20Filling%20Month%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355738%22%20slang%3D%22en-US%22%3EThe%20opposite%20would%20work%20(extract%20first%203%20characters).%20There%20has%20to%20be%20some%20pattern.%3CBR%20%2F%3E%3CBR%20%2F%3EOr%20type%20January%20then%20double%20click%20on%20the%20corner%20of%20the%20fill%20handle%20to%20create%20list%20of%20full%20months.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20see%20what%20you're%20saying%20but%20I%20don't%20think%20it's%20unexpected%20behaviour%3C%2FLINGO-BODY%3E
Haytham Amairah
Trusted Contributor

Hi all,

 

This is what the Flash Fill suggests to fill the full month names!

Flash Fill - Wrong Pattern.png

 

 

It should be smart in this regard to recognizes this simple pattern!
What do you think?

6 Replies
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

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.

@Haytham Amairah 

In that particular case don't use Flash Fill but Auto Fill.

 

@Wyn Hopkins @Sergei Baklan @Detlef Lewin 

 

Thank you all!

 

By the way, I also noticed the same behavior in Power Query!

Add Column From Examples.png

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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies