This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a project I need to finish and one of the questions gives me three numbers in a column and says to use flash fill to finish the sequence. However, I already know the correct answer and any method I try won't get me these numbers. Here are the numbers: bs001, cg001, dh001 and the correct answer after flash fill is bs001, cg001, dh001, kb001, mt001, pd001, pj001, rc001, tg001. Is there a similar function I can use to achieve the same results? Thanks!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
For whatever reason, Microsoft does not support Flash Fill for its Mac version of Excel.
So its like Microsoft gifts Flash Fill to half of the world, but the other half has to wish for it in their prayers before sleeping time every day until their wish comes true, and dont be naughty as well. Also leave some cookies and milk so one day Microsoft will come and grant Mac users the same features that its giving to Windows users.
How utterly ridiculous. Pay full price for the software and have a limitation on one of the best features? Incredible.
Flash Fill is a feature recently added to & currently available only in Excel for Windows:
Check if this helps.