Flashfill not sequencing numbers when using the handle it’s just copying numbers....

like
Posting as :
works at
You are currently posting as works at

If I understood your dilemma correctly... you have to highlight multiple cells that introduce the sequential pattern.

For example, if you want consecutive numbers, highlight "1" and "2" and dragging down will activate the flash fill functionality in Excel.

like

Figures it out tried that...apparently there’s a glitch need to filter and unfilter and it works....

Related Posts

Hi, anyone from Slalom willing to refer please? Thank you!

like

How are perceptions of post vendors companies created? Where do they stem from? This industry just gets so hard to navigate through sometimes. Would love some honest insight!

like

I have 2 Yoe as a full stack and recently I cleared Accenture full stack interview and I am waiting for HR call. My current CTC is 7.4lpa how much hike should I ask from Accenture HR???

Hi all,
I am holding offer from Infosys- 16 LPA, Mindtree- 11LPA, TCS- 9 LPA and VGL- 15 LPA as I will join the company in two weeks. I am not sure, which one I should join and should I ask with other companies for revised offer letter (if yes, please suggest me the process) or I should join Infosys or VGL?

Any help or suggestion will be highly appreciated, thanks for your help.

like

Any insight on LinkedIn and contract roles?

like

Consulting is a serial offender for crazy decks. Is anyone else fed up of being asked to format other people's messy ugly decks 😑 like seriously it's not that hard, I'm not your personal DTP.

like

Anyone following the story of the EY employee who died by suicide at the office? Hoping this brings change to the work culture of big 4, but I doubt it.EY

likeupliftinghelpful

It drives me unjustifiably insane when somebody says "high five" and sticks out there hand for a low five.

funnylike

32 | F | Dallas looking for some decent friends..weekend restaurants/bar..HH hangouts. Also I’m a lesbian but I am NOT in the dating scene nor mindset. So please don’t be alarm, I’m not THAT lesbian that’ll try to hit on you. I respect boundaries like I would expect the same from the next person. I have way more heterosexual friends if anything.

likeuplifting

I’m thinking of leaving audit after my second busy season. My main interest in accounting has always been forensics /fraud . Also thinking of going the CFE route instead of CPA. What position should I apply to or transfer into ? Also do I look for a senior position or just an associate. Please any input will be helpful . Thanks in advance

like

share your investment queries omaynotgave the bestbut abetter prospective

Everyone is getting engaged or married…where is everyone finding people that love them that much?! I can’t even get a damn date.

likefunnyuplifting

Any recommended courses or books on customer care/cust success analytics or marketing analytics in general?

like

What's a reasonable amount of billable hours for a first year? How do you adjust to not having much free time?

like

Retail workers, what is something your manager could do to make working there easier?

like

Dm if you are interested for a job at Deloitte 😊

like

There is a special place in hell for people who merge cells and add spacer columns.

like

Why is it so hard to get a call back? I’ve applied for hundreds of positions and asked for referrals and followed up so many times… I have a really solid resume and currently work for a company that’s known for high standards. Is anyone else struggling to find a better job right now?

like

Real question: do you (the reader) personally consider people of Asian descent to be POC? If you don’t, do you find it offensive if Asian people consider themselves POC?

like

UK Citizen based in Italy and looking to move in a Sales role ideally within SaaS in Tech, Fintech or Telco.

Experience in Ops & CS Management within VC backed start-ups, but fairly new to outbound sales.

Looking for a fully remote role and would love a referral.

Must ideally be in the CET timezone but I can be flexible with some overlap.

Anyone know for something?

like

Additional Posts in Excel Genius

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

Please help. I was recently hired by a Venture Capital firm that uses MacBooks instead of PCs. I’m extremely efficient with Excel on PCs and am struggling with the transition to Mac. Do any Mac users have a list of keyboard shortcuts that they use frequently, or any other tips/tricks?

likefunny

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

What are the most typical models you all build

likehelpful

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

I have a field in excel that represents the GSID, that I want to concatenate to create a link. Example field GSID is 123-west and the link needs to be www.website/123_west.html for some reason using concatenate with left & right formulas to switch - to _ results in the field throwing an error. Anyone knows of a way to make this work?

like

Whats a good book/course that will teach me advanced excel skills? I want to be quick with shorcuts etc & learn VBA/Macros. Under $30 please, input is greatly appreciated.

like

Anyone know if / how to have the CapIQ and SNL (MI) excel plugins running at the same time? I always run into issues with one of them not functioning when they’re both enabled

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?

like

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

Has anyone encountered this error before? We can’t access a workpaper with 70% of the work done 😩😩

Post Photo
like

[shortcut genius] how can I use a keyboard shortcut to simulate the double-click on the cross in right low corner that extend your formula only to the row you need (ctrl+d will go too far)

likehelpful

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

Can anyone help me with this pls? I created a graph using data above (not shown) but for some reason “technology” here appears three times. I want sectors to be grouped together. Is there any way to fix this?

Post Photo
like

What’s the best way to become a good excel modeller in a short time? Coursera course? Something else?

like

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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