Comments on: How to use Flash Fill in Excel 365 - 2013

Comments page 2. Total comments: 46

1. 

   Milan Kumar Maharjan says:
   2024-01-18 at 12:07 pm

   Thanks! Very Helpful and easy to understand

2. 

   Abid s kureshi says:
   2024-01-01 at 5:11 am

   Good experience

3. 

   SHRIKANTA MANDAL says:
   2023-12-19 at 5:41 am

   While I can see the benefits in some cases of flash fill

4. 

   Tanusree Paul says:
   2023-10-16 at 3:48 pm

   Very informative

5. 

   Satya Prakash Sahu says:
   2023-09-29 at 2:47 pm

   It's very important subject for us.

6. 

   Sangey yangzom says:
   2023-09-20 at 12:25 am

   Helpful

7. 

   Simran khatoon says:
   2023-08-10 at 1:23 pm

   You have a nice diyaa

8. 

   Simran khatoon says:
   2023-08-10 at 1:20 pm

   Nicee

9. 

   Simran khatoon says:
   2023-08-10 at 1:18 pm

   No

10. 

    Priyanka nayak says:
    2023-08-02 at 3:26 am

    Excellent

11. 

    Anuska Mehta says:
    2023-07-17 at 7:46 am

    Very nice and easy way to understand

    1. 

       Shivangi says:
       2023-09-19 at 11:42 am

       Thankyou!
       That 's exactly the information i was
       Looking for.

12. 

    Ryan P says:
    2023-04-24 at 5:11 pm

    Hello,
    I'm late to the party but have an inquiry on whether flash fill can be used for more advanced combinations.

    Take this formula as an example

    =(F84*((BLDG33!E6)/E84))/(VLOOKUP(H84,'Available Time'!E3:F21,2,FALSE)*I84)

    When I flash fill downward it gives the following

    =(F85*((BLDG33!E7)/E85))/(VLOOKUP(H85,'Available Time'!E4:F22,2,FALSE)*I85)

    Is there a way to reach my intended outcome with flash fill, which is only changing the cell of the columns within the same active sheet and not from other sheets or documents

    =(F85*((BLDG33!E6)/E85))/(VLOOKUP(H85,'Available Time'!E3:F21,2,FALSE)*I85)

    I worry I'm going to have to continue manually for these entries, any help is greatly appreciated!

    Thanks,

    1. 

       Alexander Trifuntov (Ablebits Team) says:
       2023-04-25 at 6:38 am

       Hi! If I understand your task correctly, the following tutorial should help: Relative and absolute cell reference: why use $ in Excel formula.

       1. 

          Ryan Patrick says:
          2023-05-02 at 8:27 pm

          Thank you!

          That's exactly the information i was looking for.

13. 

    Nikki says:
    2021-10-19 at 10:50 pm

    I have shut flashfill off, yet it still tries to flashfill. I've never ever had flashfill work as described and it comes up with very strange fills for me (all kinds of misspelled words that make no sense). How to I permanently kill this feature. As I said, it is shut off. I can't get it to stop and I can't even use my spreadsheet as everytime I try to type something it flash fills garbage and when I undo and try again, it just flashfills again.

    1. 

       Alexander Trifuntov (Ablebits Team) says:
       2021-10-20 at 7:59 am

       Hi!
       Turn off Flash Fill as described in the article above. Then restart Excel.

14. 

    Bhupal giri says:
    2021-07-09 at 11:19 am

    I don't have flash fill option anywhere in edit menu of Advanced option,

15. 

    Sarah says:
    2021-05-14 at 9:23 am

    Good day. Thank you for the tutorial. I have one problem. I want to extract a year from a given date say I want to extract 2020 from the date 3/02/2020. How do I go about it? I keep getting wrong responses.

    1. 

       Alexander Trifuntov (Ablebits Team) says:
       2021-05-14 at 9:32 am

       Hi!
       I recommend reading this guide: Excel YEAR function - convert date to year.
       This should solve your task.

16. 

    Cassandra says:
    2020-12-30 at 2:50 am

    How can I disable flash fill and copy paste in a workbook?

17. 

    Kamran Imtiaz says:
    2020-10-08 at 6:56 am

    I just want to learnt about the Flash fill formula. My excel sheet requirement is as under;

    let and example;
    Ali-050512-25-07-20220 i want to extract only the number not the name and date and the said number has the different length.

    kindly provide me the solution

    1. 

       amin says:
       2021-05-04 at 1:53 pm

       Hi
       You may use excel bulitin tools
       Combination of these tools
       Text to columns
       And function
       If
       Lenth

    2. 

       Alexander Trifuntov (Ablebits Team) says:
       2020-10-08 at 7:58 am

       Hello!
       Without seeing your data it is difficult to give you any advice.
       Flash fill looks for a common pattern in your data. To do this, he uses several cells arranged sequentially in a column. From your example it is impossible to understand where the date is, where the number is. But if the number can have a different number of digits, then there is no pattern. Give an examples of the source data and the expected result.
       It’ll help me understand it better and find a solution for you.

18. 

    AL says:
    2020-05-12 at 8:08 pm

    While I can see the benefits in some cases of flash fill; IT SHOULD NOT EVER BE AUTOMATICALLY ENABLED TO AUTOMATICALLY FLASH FILL! I have a document maintained by myself and 3 other people and this stupid auto enabled new feature started auto auto-filling the initials of 1 person over everything! If ya got a new feature then simply put it in a one time notification and don't assume everyone does things a stupid and/or unproductive and/or risky manner that would cause misinformation being typed in by someone not paying attention to the hidden fact that you added a feature but didn't tell ANYONE!

19. 

    Robin Cooper says:
    2020-01-17 at 1:47 am

    This is quit working:
    2 9 /5day
    39 116 /3day
    18 49 /3day
    8 24
    7 22
    9 28
    63 189
    I need the 2nd column to include the "N/3day" message.