Flash Fill for Mac?

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!

|

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

2 people found this reply helpful

Was this reply helpful?

Yes
No

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

For whatever reason, Microsoft does not support Flash Fill for its Mac version of Excel.

114 people found this reply helpful

Was this reply helpful?

Yes
No

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

How utterly ridiculous. Pay full price for the software and have a limitation on one of the best features? Incredible.

7 people found this reply helpful

Was this reply helpful?

Yes
No

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Pardon for being dumb. But describe, "Flash - Fill" I've been an apple User since 1986 and a Mac User since the days of the SE/30. I've never run across the term Flash Fill so I don't know what it does. Might just be a Difference in Terms. For example, What windows people call options, Mac people call preferences. Perhaps Mac People call it something different. Or indeed it might be something that never been offered in Mac version.

_________

Disclaimer:

The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone, and do not reflect upon my position as a Community Moderator.

If my reply has helped, mark accordingly - Helpful or Answer
Phillip M. Jones, C.E.T.

Was this reply helpful?

Yes
No

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Flash Fill is a feature recently added to & currently available only in Excel for Windows:

A Beginner's Guide to Flash Fill in Microsoft ...

AI: Artificial Intelligence or Automated Idiocy???
Please mark Yes/No as to whether a Reply answers your question.

Regards,
Bob J.

4 people found this reply helpful

Was this reply helpful?

Yes
No

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Reply In reply to deleted message
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.

17 people found this reply helpful

Was this reply helpful?

Yes
No

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Exactly! Well put!
I am an unpaid volunteer and do not work for Microsoft. "Independent Advisors" work for contractors hired by Microsoft. "Microsoft Agents" work for Microsoft Support.

1 person found this reply helpful

Was this reply helpful?

Yes
No

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

http://lmgtfy.com/?q=What+is+flash+fill%3F&l=1

Was this reply helpful?

Yes
No

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

You can open the document in Excel online, there you are able to use flashfill function, save and open it on your desktop Excel again.

Was this reply helpful?

Yes
No

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

So, I had this same question, and finally found a perfect enough answer to solve my problem of how to turn names into email addresses EVEN if you are using Excel on a mac...

Use the formula =CONCATENATE(cell,".",cell,"@domain.com"). Be sure to include the apostrophes and commas - the formula won't work otherwise.

Here's the SUPER helpful link: http://blog.goptg.com/blog/2014/10/29/turn-names-into-email-addresses-in-excel

Was this reply helpful?

Yes
No

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

 
 

Question Info


Last updated September 16, 2021 Views 19,782 Applies to: