Leave a comment letting me know how YOU use FLASH FILL. I'd love to learn some new tricks!
@joniraunig2321
2 жыл бұрын
Life changing - no joke. I really need to upgrade my skills. Thanks!
@FrankMLoSchiavo
2 жыл бұрын
My pleasure. Thanks for leaving a comment :)
@igotjoy1
3 жыл бұрын
Wonderful! Thank you!
@FrankMLoSchiavo
3 жыл бұрын
You're welcome. Please consider sharing it with others. I'd love to spread the news about this awesome feature in Excel!
@ARLYNELUCAS
2 жыл бұрын
THANK YOU SO MUCH!!!!!!!!!!!!!!!!!!!!!!!!!!! BIG HELP!!!!!!!!!!!!!!!!!
@FrankMLoSchiavo
2 жыл бұрын
My pleasure :)
@kathycasford8514
Жыл бұрын
OMG! You are my hero!! Thanks!
@FrankMLoSchiavo
Жыл бұрын
Flash fill is like magic, isn't it?
@joebaxter2159
Жыл бұрын
LOVE THIS!!! Thank you!
@FrankMLoSchiavo
Жыл бұрын
You're welcome! Thanks for posting a comment :)
@badzkoh890
Жыл бұрын
Wow thanks for this. Very useful 👏❤
@FrankMLoSchiavo
Жыл бұрын
Glad it helped!
@tamp8390
5 ай бұрын
Awesome!! Thanks
@FrankMLoSchiavo
5 ай бұрын
Flash fill is wonderful, isn't it? I'm glad the video helped you :)
@riversaly
Жыл бұрын
what if there are peeple who have many first names and also middle initial
@FrankMLoSchiavo
Жыл бұрын
It's possible that an automated process like flash fill might not be best in that situation. However, look at the video again and see if the second trick I share might help. That trick shows how to apply a correction to flash fill. That part of the video starts here: kzitem.info/news/bejne/06idza6mmoeTam0
@marieltandingan3131
2 жыл бұрын
Thank you
@FrankMLoSchiavo
2 жыл бұрын
My pleasure :)
@cloverchips6913
2 жыл бұрын
hi im having some problem when there are two first names.. some of the characters are missing. How do you use flash fill if for example the name is maria grace de la cruz?
@FrankMLoSchiavo
2 жыл бұрын
Flash fill works best when there are consistent patterns in the data. Sometimes you can train Excel to make corrections to the cells that don't fit those patterns. See this part of the video where I demonstrate the necessary technique. It might work in your situation. Not sure. kzitem.info/news/bejne/06idza6mmoeTam0
@ntm_jan
2 жыл бұрын
Excel is great but hard to memorise patterns 😔😔😔😔😔
@FrankMLoSchiavo
2 жыл бұрын
I agree. But most people don't need to memorize Excel functions and formulas. In general, I only have a few memorized. They're the functions and formulas I used often. Everything else I search Google, and then figure it out from there. Thanks for posting a comment!
@tammywong6774
2 жыл бұрын
This is exactly what I wanted to learn. Thank you Sharon Smith
@FrankMLoSchiavo
2 жыл бұрын
You're welcome! :)
@marilyngross2838
Жыл бұрын
This was amazing. I'm a Subscriber now and look forward to discovering new things to do in Excel!
Пікірлер: 27