Has anyone figured out flash fill because I swear it NEVER gets it right when I try it. What's the secret to making it work?

Post Photo
funnylike
Posting as :
works at
You are currently posting as works at

I've never tried to flash fill states, and it went about as well as that 😂

Post Photo
funny

😂 😂 😂 Hikansas sounds lovely

funny

I have always loved Excel for how awesome it does so many things, and also how awful it can do some of what should be the simplest things to do! Never ceases to amaze me and always good for a laugh! Never used flash fill for states either, but assume that is about how good it would go anyways!

Related Posts

New tiny baby emerging 🥰🌱

Post Photo
likeupliftinghelpful

Just spent 15 minutes buying a flight on the jet blue app... is there software really that slow?

like
like

Weekend Drive(Virtual) 17-18 Sept for Below Technologies in LTI-Larsen and Toubro Infotech.
*For Registration, Dm your Email with JobName*

Post Photo
like

I have recently joined Capgemini. When can I expect my joining bonus?

Hiya! I was wondering if anyone here has any good recommendations in terms of books or learning material that I can pick up to learn about sales and marketing relevant to the consulting industry?

like
like

Hey y’all, wanted to get some insight into an offer.

Director level sales role
250k OTE 60/40 split uncapped
325k stock 4 year vest (options) - pre IPO unicorn
10k sign on bonus

I’ve got about 8-9 years in enterprise sales /mgt

Hello Fishes!
I am a fresher. I have 4 months of experience in Business Intelligence. I've Worked on Qlik Sense/View for the development of all the analysis.
Any new job openings for entry level candidates Please reply.
Location: Mumbai

like

Manager told to provide onsite by next year if drop resignation since 1 year not completed not eligible for onsite now, is it good option to drop?

like

left NYC march 2020 and haven't been back since. Going this weekend- news is always talking about how the subways aren't safe anymore. Are they exaggerating?

like

Moving to LA soon. What are some good apps or meetup groups to join to meet new people?

like

Without warning it looks like we'll be switching from consultant teaching to inclusion...what do I need to know. Never co-taught or done inclusion except for years and years ago and it was very informal. Best ways to build a solid relationship with the classroom teacher you're paired with? Pitfalls to watch out for? Thanks!

like

What is THE BEST professional development you've ever been to? (Conference? District workshop? Etc.)

like

i joined GlobalLogic 1 month back , client is not allocated yet, but i want 4 days leave in January due to some personal function, can i approach for leave

Could anybody help with a reference for Siemens pls

like

What is the maximum pay for Senior Consultant band C1 in CG

like

Do we have to return UPS, Headphones apart from laptop on the lwd at IBM GBS ?

like
like

Any salaried workers figure up their *actual* hourly rate? Oooof what a mistake that was🥴

like

Additional Posts in Excel Genius

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Still don't have xlookup. #fomo

like

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Anyone know what these badges are?

Post Photo
likefunny

Any book recommendations on excel modeling for real world business applications?

like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Would anyone be willing to teach me vlookup?

like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal