Excel flash fill is amazingly bad. I've never seen produce anything but unintelligible garbage.
this post was submitted on 12 Oct 2025
328 points (98.5% liked)
Facepalm
3676 readers
2 users here now
founded 3 years ago
MODERATORS
You’re dragging it wrong
Flash fill is not the result of user dragging. It's an automatic prediction done by Excel while you type. Therefore, the commonly horrible output is not the result of user error.
Ok but then my double entendre wouldn’t work…¯\_(ツ)_/¯
It either works flawlessly or not at all in my experience.
So it is software gore 👍
Ah yes North and Sorth Carolina
They pale in comparison to Worth Carolina
It always confused me that there was no Eorth Carolina.
Just stay away from Dorth Carlonia. it's very dark.
What about Fourth Carolina?
that is just a myth started by lunatics and mathematicians to scare the rest of the carolinas
“Lorth, I am your father”
– Dorth, probably
VLOOKUP is your friend.
so is NLOOKUP
Dorth Carolina, Washington State 🥇
Oorth Harolina, surely
That one's in space
All the great Cackalakys…
Must be a code!
NOLNLIWOTSDWSCFMTM
what the fuck's even the order😭 i thought it'd at least follow the alphabet but no
Look at the state codes in the column to the left and think like a really shitty computer
The column to the left.
Seattle in the Carolina that matters not like Orlando in that one over there...
Worth Carolina
They should merge all the Carolinas then to make it simpler.
I'm wondering why anyone would think that would work.
Omaha - congratulations on joining the best Carolina…
That flash fill knows something. The government is hiding the truth! Quick! To the Conspiracy Cave!
my city is there, wonder what's this about now 🤔
Welcome to the Carolina multiverse.
in Columbia, so already Carolina, but not like is a good thing tho
Columbia Sorth Carolina. Enjoy the rebrand…