flash fill

  1. G

    Flash Fill Question

    Good morning, Currently, I'm trying to compare a date with another cell that has a date in it but it's formatted in a way that conditional formatting isn't working. For example: A1 = 6/11/2021 O1 = 17May2021 MON I'm trying to figure out how to extract that 17May2021 into another cell as a...
  2. B

    Inconsistant flash fill Error

    Hi, If anyone can help me with this dilemma. I've created a table in excel with a set of data and formulas. This table includes column titles. The table is almost similar to a bank statement where there's an Opening Balance and Closing Balance. The first cell in the Closing Balance is simply...
  3. A

    Making the dates uniform in excel

    Dear All, I have a large data set with 16,000 values. I need to extract the start date from the column. However, the dates are in different forms. Some have a single date wherein some contains ranges like 06-06-2019 - 08-06-2019. Is there a way wherein I can convert these into a single date...
  4. George J

    Disabling Flash Fill

    I have searched online for the solution and have not seen one, which does not bode well. Time to ask the experts. I have a workbook that creates another workbook. In this second workbook , the user fills in reference ID's but Excel is trying to be helpful. When it thinks it sees a pattern...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top