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
Posting as :
works at
You are currently posting as works at

Yes. Create a row that is 1, +1, +1, +1, =A, =B, =C, =D and copy that all the way over.

Then a year row with similar syntax but make it 2021, =A, =B, =C, +1, =E, =F, =G.

Then in final row: =concatenate (row 1 & “Q” & row 2)

likehelpful

Agree, use a concat function.

Could use =edate() formula to add 3 months and then lookup to a table that says what quarter the month is in.

Consider using a table

Related Posts

Hey guys, I have the first short 15-minutes call with a product guy from Hugging Face today wherein he is likely going to take a guess at what roles I could be suitable for. I had applied for Post-Sale Machine Learning solutions Engineer. Is there anyone who’s gone through the process for a similar role at similar organisations or best case scenario would be if anyone has gone through the process with HF.
I have been working for a year and am doubtful if I’m mature enough for the role. Help lol

like

Hi All ,
Can anyone please suggest which one to choose from cognizant, Coforge, Magic edtech for noida location on Java stack for better WLB and long term stability.

Thanks!

I have an accounting degree and am looking for something where I spend most of my time using excel. Surprisingly, audit —at least at my company— doesn’t really do that. Any suggestions would be helpful.

I’m not sure if this is the right place to post, it’s my first time so please excuse me!

like

Anyone know if we can expense coffee pods during this WFH thing? I’m already on my 2nd cup.

likefunny

Is this the new ‘Enterprise Strategy’ practice at IBM?

Please suggest what would be the in-hand salary. I deposit 1.5 lakh through 80C.

Post Photo
like

Help guys. Could you tell how much in hand will I receive for below break up -Cognizant Tata Consultancy Infosys Accenture Deloitte KPMG Amazon Synechron Inc.

Post Photo
like

What's the biggest delivery you've ever made? I just brought a 75,000 pound truck across 3 states and so far that's my record

like

Hi,
My current company is going out of business next week. I am rushing to get my next job lined up (probably won’t happen in time but I’m trying my best). My question is: should I be honest about why I’m looking for a new job? Is it wrong to not share this info during my interviews? Is this situation going to affect my interview process somehow? Please share your thoughts and wisdom! Thanks!

like

Fidelity Investments i have attended my interview on last saturday but i have not received feedback even i have sent an email to hr. Does it mean i am not selected or shall i wait for some more time?

Dipped my toes in some dumbass hype stock - 60 shares of FMCI, planning to sell within 2 weeks

like

Anyone know what these badges are?

Post Photo
likefunny

(Not frm Accenture)
If you are on notice period and not doing work properly or on time then what can be the consequence ?
They cant put me on performance defaulters as I voluntarily resigned and also got good feedback from client.
The reason I resigned was the sh^^head manager and project.
He said I would be released from project soon and then on bench but after resigning he is saying you have to serve the NP n we cant release early.
This is only option left to get released from this sh^t place

like

Can anyone refer in Oracle for QA Automation Tester?

like

Hi all,

Need genuine opinion.
I have experience of 6 years in performing sast/dast and also managing a small team
Should I take next role in core pentesting as a senior tester or
Lead role to manage security of applications and junior pentesters ?
Let's say I do pentesting for another 2 years, Does core pentesting experience will add more value to take up lead role later?

like

Hi guys, a plea for help here 🙏🏻 have any founders here gotten an O-1 visa or an H1B transfer into their startup? Would greatly appreciate hearing your advice / experience over DM

like

Which are the top consulting firms in the region after MBBK , heard strategy& has a really bad culture so exclude that too?

like

Does anyone want to buy a MacBook Pro 13inch with touchbar from 2017? Like new condition. 8Gb ram, 256gb SSD, very lightly used battery

like

Hi Fishes,
My Appraisal is due this september. Can anyone of you tell me how much hike can i expect.
Cctc:6.5
Designation:Engineer
Exp:2.6
I joined in jan2020 but the training period of our entire batch was extended due to covid. Hence getting first appraisal in sept 2021.
Thanks in Advance😀

like

Additional Posts in Excel Genius

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Still don't have xlookup. #fomo

like

Would anyone be willing to teach me vlookup?

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.

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

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

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

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)

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

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

How do I compare two sheets to make sure they are identical?

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

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

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

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

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

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!

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

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

Post Photo
likehelpful

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