How do you automatically enter consecutive numbers per row, i.e, "1, 2, 3, 4, 5, 6, etc...

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

You probably need a basic Excel course lol

likefunny

This is so true. Imagine not knowing basic excel in 2024.

=cell above + 1

like

Enter 1, 2 and 3 in the rows where you want them then highlight those three cells. See the little dot in the corner of the cell with the 3 in it? Click and drag it down as far as you want cells consecutively numbered.

like

flash fill?

like

1 enter
2 enter
3 enter
4 enter
Etc…

like

No dude you have to use indexmatch + xlookup + countifs

like

I did it once 10 years ago from 1-100000 for rows and A-ZZ for columns. I save that workbook to a separate cold storage because it’s too sacred to save on my computer where’s hackers could steal it.

Now whenever I find myself in a similar place to OP, i load up my cold storage drive, copy and paste the columns and rows I need, and voila 👩🏼‍🍳💋

Work smarter, not harder friends.

funnylike

Bravo 👏 🙌

Sequence

like

A lot of sarcasm in this thread, wow! =SEQUENCE(‘number of rows’) is what you want. Can also do number of columns, and you can change the starting point and step.

likehelpful

=row(same cell entered for formula)-row(header). Anchor header completely and row no will change if you move rows around

1,2,click and drag across or down. Works for most patterns, dates etc.

Related Posts

Fishbowlers... I need some advice. I’ve been in industry for two years and want to go back into consulting. I have an opportunity to work in same field at Capco or go back to pwc for an (c’ntd)..

like

Can anyone tell me what first year KPMG audit seniors make in the DC area?

like

I have my HR interview for salary discussion next week with FORD motors, Chennai location. My current CTC is 11LPA and total experience is 6.5yrs. (Java fullstack developer)

Could someone pls suggest how much can I ask? I heard they are paymaster. Can I ask 100 % hike? Is it reasonable?

Hi

I am working as PL/SQl developer having 5YOE with 5.45lakh CTC.
Today I got offer from TCS for the same with 10.5lakh.Is it good to accept?

Hello guys,

Any information on below would really help!!
I had package discussion with TCS HR this month 4th but I have not heard back yet. Tried to reach out to hr but no response.

Does anyone know how long they take to release offer letter?

If they put on hold or reject..will they notify us..
Please respond!?

Did anyone receive offer from TCS this month??

What is jl of applications architect in tcs...is it C3b or c4 or higher??

like

What do you guys do for fun in JC?

Hi All, I am new here. I am a small business owner and bake custom cakes for all occasions. Just wanted to share my business here. Please check my Instagram handle @cremenganache. Do follow if you visit!

like

Hi folks,

I work as data analyst in Zs associates since 1.3 years, now thinking to switch as it seems theres no growth opportunities left ..

Please help me to get some referal

FIRE newbie here. Is it possible to reach FIRE with a special needs kid? Has someone done it? Are there any alternatives to fund therapies beside insurance?

like

Recs on good rental insurance? 3 apts in my neighborhood were broken into and I’m looking for a good but not pricey option

like

How would you allocate $200K today, knowing (1) this is in addition to your HYSA, investment, 401K.. (2) you have no immediate use (3) if we see a drop in real estate price in the next 1-2 yr timeframe, this could be part of your down payment for a house in HCOL

like

Where did that phone come from? 😆

Post Photo
likefunnyhelpful

Enrolled in an executive MBA program at a top uni, and I have to say I’m very happy I did that vs FT/PT.

likeupliftingfunny

Hello everyone,

Job status in workday portal for PWC is showing Offer phase, anybody know what does it mean.

like
like

I’m a defense-side employment attorney with 5-7 years of mid- to large firm experience. What would it take to pivot to an employee relations-type position? MBA? MHRM? Come as I am?

like

I’ve been told my company is changing my title from Associate Director of BD to Sales Executive. I’m concerned it reads like a title demotion. Is it just semantics? How will this look for my career development? Curious about the standard perception of Sales Executive from a seniority perspective. Where does this land on the sales roles hierarchy? For context, it’s a professional services firm, I’ve been there 3+years, and they gave a Sales Executive title to someone who just started 5mo ago.

like

I feel really fatigued and weak if I don’t eat for a few hours. Outside of just planning my meals better, do you think this could be an underlying health issue?

like

Additional Posts in Excel Genius

What are your top Excel ninja tricks? Ones that few people know...

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

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

How do you fix microsoft excel cannot paste data error?

like

Would anyone be willing to teach me vlookup?

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

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

Anyone know what these badges are?

Post Photo
likefunny

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

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)

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

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

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