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.

@meatiethatsme2471

6 ай бұрын

Thank you Jamie. I was wondering about that. Great video.

Nice👏👏 l never knew so simple I love it❤❤❤

Many thanks

Thanks a lot.❤ I never knew the Autofill function could be used in reverse.

@TeachersTech

6 ай бұрын

You’re welcome!

Thank you so much, you are amazing

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.

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?

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?

Updating updating systems good is it am lost on updating it

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.

@TeachersTech

6 ай бұрын

Thanks, when I did it, I hurried through it. I should have filled another row to help the pattern.

@Chaithra777

6 ай бұрын

@@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.

no flashfill option even its enable in option, help??

Hello there. tyvm for the clip. i have a question; flash fill only works on columns, ins`t it? best regards from Portugal

The telephone # example is incorrect?

@MoniMeka

6 ай бұрын

Yeah, they all had 2475 at the end. He didn't see that?

@TeachersTech

6 ай бұрын

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.

Flash Fill: 5:09

Why didn't the phone numbers do the same number at the end? They all had 2475 at the end. 🤨

@TeachersTech

6 ай бұрын

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.