Is there a way/shortcut, without using a mouse to drag cells down, to fill a range of data following a trend? I want a column with the first day of each month up to a certain date (row number). Thanks

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

I figured it out. First, you need to copy the cells that begin the trend you want to continue. Then, you select the range of cells in which you want your trend to continue, starting from the first data point in your trend. Then use Ctrl + D to continue the trend to the last cell you have selected.

Hope this helps to anyone who was also curious. And KPMG 1, if this was what you were alluding to, thanks.

likesmart

CohnReznickProud!!!!

likefunny

Ctrl+D is fill down without a mouse.

like

That would work, I was just looking for a shortcut version rather than formulaically solving

Related Posts

has anyone attended the school of practical philosophy?

I am getting 32 lakh pa at oracle. I have around 15 yrs of experience. And I have 1300 units of rsu with me. I just completed 4 yrs in oracle. Now I started a feeling like I am under paid. What you guys think?

like

Do I need to bring my I-797 to travel internationally with a valid unexpired visa? I’m backpacking for a month so don’t want to loose my org docs. Last time entering US the officer didn’t ask for it

I had 2 interviews with two different managers. Can I send one thank you email and add them both to it? Or should I send a separate email to each?

like

Is there anyone here who can comment on the interview process for FLAMMA in PA?

Does anyone have recommendations for thought leaders/influencers in the M&A space? Looking for blogs, books, YouTube videos? Not currently in the space, trying to learn more as I’m thinking about a pivot after a few years in consulting/startups

likehelpful

Junior copywriter here. Is it possible to build a healthy work relationship with a senior copywriter you don't jive with? I'm 100% sure she doesn't like me, but she keeps it professional at work.

like

Assuming there a significant difference in Comp when working internally for Mckinsey&Company within their Technology&Digital group? Considering a switch….

like

I’m the first community manager the company hired (6 months ago). My boss is trying to get me fired because “we don’t need her after all.” What do I say to the higher-ups to save my job?

like

How soon after a final interview with a DM is ok to call and follow up on a job potential?

like
like

Has anyone suffered from binge eating disorder? How did you manage it? What triggered episodes?

like

Why is Bain NY 90% HBS grads

like

When recruiters pursue you on linked in for one-off type roles, is it appropriate to respond immediately with salary expectations / min expectations (in a polite a manner as possible)? Not sure if it’s rude; or acceptable, to save everyone time…?

like

Guys, Im working for a EY in Mumbai (Business Consulting - FS). Keen to transition to McK, BCG, Bain, Kearney. Any idea how can I apply to these roles within / outside India. What is the best way to get in touch with the hiring partners?

Any referrals here will be highly appreciated

like

This year I got into ultramarathon running, and more recently I learned about Skyrunning, which is like Ultra running, but you do it on really tall and steep mountains... and last night I ran my first all-night 100K race, and I loved finding my way through the dark with a headlamp, so now I'm curious if there's a sport combining spelunking and trail running. Is cave running a thing?

Post Photo
likeuplifting

What agencies are asking you to go in today?

like

Can a company(big 4) terminate the individual if the he/she has not disclosed that he joined "x" company for 2-3 months as full time employee but has not disclosed it in any of the discussions with the company. I understand it will not be reflecting in background verification but since the UAN remains same and they can catch from pf.

Pls provide your comments, would be really helpful

like

❤️ I’m doing great
🧡 I’m okay
💙 I’m not sure how I feel
💛 Things are tough, I’m struggling
💜 Having a hard time and wouldn’t mind if someone reached out to me
💔 I’m in a dark place

likeuplifting
like

Additional Posts in Excel Genius

Is there any big advantage of using gsheets over excel?

like

It's that time...🦃

What function are you most grateful for in Excel? 😎

Drop it below! 👇

likehelpful

Any ideas for how to reshape a dataset from wide (panel) format with two column header rows to long (pivot) format while keeping one column header row?

Post Photo
like

Anyone run into an instance where one VBA goal seek will work within a loop and then another vba goal seek not in a loop within the same workbook won’t work? I’ve done some google research and it seems like it might be a COM add-in problem but wondering if others have exp this.

like

Google Sheets vs Excel - pros and cons? Asking seriously.

like

Noob here:(
Lead wants me to limit values in 5 columns - achieved
Now she wants me to implement - If 1st column is filled and others' are empty, raise an error. Tried ISBLANK but it removes drop-down

like

I am trying to create a formula based on data type geography. I want to ba able to write if(cell=NY,,) but I get #value.

How do I get formula to recognize the text of a geography data type?

like

How do you create a Pareto chart in excel? Like I want to identify what percentage of customers contribute to 80% sales. I have data at individual customer level.

like

Having trouble with data dependent drop down list. In sheet 1 I have “type” and “subtype” columns that are blank and I need column B to be a data dependent drop down of A. The master data is the format:
(A.) (B)
T1 S1
T1. S2
T1. S3
T2 S4
T2 S5

How can I have my list show only S1-3 if I type in T1 in column A? (T1 = type 1, S1 = subtype 1) there are multiple words, spaces, and numbers for the data as well

like

Need some urgent help with using if and vlookup together. Anyone willing to help via direct messages please?

like

Whenever I press Enable Content, Excel crashes (and does an infinite loop). I can’t seem to break link the cell that is supposedly linked to an external source. Anyone know how to solve this?

like

Can someone explain how to build a Monte Carlo simulation in excel ? Videos in YouTube aren’t helping.

like

I would like to create a geographic heat map in excel using a list of addresses that will be continuously added to and would like the map to update as addresses are added. TIA

like

Does anyone know a shortcut for unhiding rows/columns. I.e. the inverse of Ctrl+9 and Ctrl+0?

like

Please do excuse how dumbed down the example is, I’ve had to replicate the problem on a much smaller scale with all sensitive data removed.

“Location” refers to a location of stored data and “User group” refers to the user that has access to the location.

I am attempting automate the finding of all instances of where the “U1” user group occurs but exclude it if another user group also has access.
Continued below….

Post Photo
like

Excel: I have data showing the monthly actual for assets deployed after a certain date. I want to figure out how many months it took for the asset to ramp to $100M revenue for each of the individual assets (200+).

Currently I’ve done a count-if based on the revenue range (0-200) and then taken an average of the months it took. Is there an easier way to do this?

like

Are courses (either Marquee or other in-person offerings, or online) notably worth it or did you find learning on the job to be sufficient/better? Considering enrolling but wanted to gauge first.

like

Really basic q but I forgot how to do it - how do I grab all the text after “@“ for a column of email addresses?

like

Hello All,
Excel help please. I’m trying to combine 3 tabs into 1. So on tabs a,b,c I have wire instructions that go to different places, but they all have the same field names/format. However the number of rows for each tab will vary from day to day. I need to make a fourth tab that shows all the rows from a,b,c consecutively. Because the number of rows change, I can’t find the best way to collate all the rows into one table. I can use a macro or lookups or a source formula. Please advise!
Mo

like

Excel VBA syntax question.

Trying to do this:
Worksheets ("Sheet1").Range("A1"). Select

By ding something like this:
Worksheets ("Sheet1").Range(Cells(1,1)). Select

Any thoughts on how to make the second one work like the first?

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