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.