You've probably noticed a typo in the flash fill example on the phone number. I wrote 2475 at the end of the first number and it should have been 7890. Flash fill couldn't recognize the pattern and when I copied it down, it kept the 2475 at the end and didn't notice 😳 I've updated the practice sheet so it is correct. Sorry about any confusion.
@meatiethatsme24716 ай бұрын
Thank you Jamie. I was wondering about that. Great video.
@dorissarpong54962 ай бұрын
Nice👏👏 l never knew so simple I love it❤❤❤
@michaelmansaray93667 ай бұрын
Thanks a lot.❤ I never knew the Autofill function could be used in reverse.
@TeachersTech7 ай бұрын
You’re welcome!
@estherlawanson7951Ай бұрын
Thank you so much, you are amazing
@s.baskaravishnu223 ай бұрын
Many thanks
@banneman43767 ай бұрын
Clear video, my compliments. However, if I use the keyboard shortcut ctrl + E in my Excel 2019, Excel will read the cell in question. When I add flashfill to the quick access toolbar and stand on the icon it shows the shortcut Ctrl + E. But it does not work. Do you have a solution for this problem?
@ashleyparkhurst50053 ай бұрын
I've watched so many videos on flash fill and I'm currently taking a course at my local library on Excel. Everybody is telling me that you only have to type in the first thing of a list, however it only seems to work for me if I type in the first two. Is this because of an update that happened? I was also told that if you type directly into a cell the second thing in a list should start to appear after typing the first couple of letters, but that never seems to work for me.
@OlugbengaOluwasina-tg8ud4 ай бұрын
Thanks for the tips on flash fill. What if I want to add a prefix like mailto: before email addresses in the same column. How do I flash fill the entire column?
@oboycorporationАй бұрын
no flashfill option even its enable in option, help??
@Chaithra7777 ай бұрын
Hello Jamie. I like your way of teaching. Thanks for your lessons. I have a question though. In the flashfill, the phone numbers are incorrect as the last 4 digits are repeated in the rows after Flashfill.
@TeachersTech7 ай бұрын
Thanks, when I did it, I hurried through it. I should have filled another row to help the pattern.
@Chaithra7777 ай бұрын
@@TeachersTechoh! i tried it now. that won't be necessary i guess. as you have entered the last 4 digits 2475 in the first row, which is not in the data. thats's the reason it showed the error. when i tried to enter the first row correctly. the rest are coming in line.
@intermixhector29025 ай бұрын
Updating updating systems good is it am lost on updating it
@Tesnobay7 ай бұрын
The telephone # example is incorrect?
@MoniMeka6 ай бұрын
Yeah, they all had 2475 at the end. He didn't see that?
@TeachersTech6 ай бұрын
I had a typo on the first line and didn't notice. The first number needed to be corrected; the last four digits didn't match, so it couldn't find the pattern.
@user-cc8hs9rc9t4 ай бұрын
Hello there. tyvm for the clip. i have a question; flash fill only works on columns, ins`t it? best regards from Portugal
@theriemannbreaker81745 ай бұрын
Flash Fill: 5:09
@MoniMeka6 ай бұрын
Why didn't the phone numbers do the same number at the end? They all had 2475 at the end. 🤨
@TeachersTech6 ай бұрын
I wrote the wrong phone number on the first line and it didn't match. On the practice file I had 2475 at the end, should have been 7890. Just make the change on the sheet and it should work.