Anyone ever tried to convert a Google sheet with complex formulas into an Excel file? Is there a way to do this automatically without having to recreate everything?

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

As luck would have it, there’s a one-size-fits-all solution which is to get an analyst to do it.

Oh, wait…

funnylike

Hahaha my thoughts exactly. I unfortunately have always relied on the analysts to do this kind of excel work.. I am working towards figuring out how to solve these problems on my own though. If I were you, I probably would end up just starting over in Excel (rather than spending too much time trying to figure out how to convert everything and jeopardize messing it up)

like

Just save it in a Google drive desktop version and open it as Excel

like

Related Posts

Hello Fishes!
Any idea how long it takes to get a German visa appointment for an EU blue card and dependents? I am based in Chennai and have been trying for 4 weeks, with no luck. I added myself to the waiting list on the 5th of July and have not received any updates since.
Do slots really open up at certain times?
Am supposed to join work by Aug 30th. Please help!

like

Genuinely curious, why do people love Panerai watches so much?! I think there nice but I’ve noticed that their beloved in the watch world

like

I am a conservative who believes in being tough on crime but this is absolutely ridiculous and wrong.

As a lawyer, it troubles me that a public figure would come out and say something like this

Post Photo
like

Hello NYC fishes. If you pay your fares via OMNY for SBS bus, and there is no ticket to show if fare cops ask you for it. Apple Pay history won’t show up immediately after transaction (Chase), then what do you do?

like

Memories flashed back while lying on bed looking at the ceiling fan... 😉

**2007: Used to stay opp. to DLF1 for 4 yrs(b.tech days). Back then, "Bhai, Technopolis chale" used to mean let's go and 'score' some good stuff.🙊🙈

**jumpcut 2022: After staying 10+ yrs outside West Bengal, now Technopolis means my upcoming office. Damn!😀

likefunny

Our small shop in Toronto is hiring for the following roles :
Digital PM
Art Director/Designer
Jr Copywriter
Account Director
Creative Director
UX/UI Designer
Intermediate Full Stack Developer

like

Any seniors in EYP Deal Tech?

Do you think clubhouse will be a hot in the longer run?

like

Did you get an increment during covid year?

like

Any tax saving ninja technique??

like

I am considering moving from US to Canada within EY if my visa doesn’t work out. Joined EY TAS- OTS from MBA as a Senior last year with base of 150k. How much salary should I expect in Toronto?

Anyone succumb to the ads and try Il Makiage make up? Foundation/concealer. Their brilliant ads make me curious, but not sure why not seeing it at Sephora is getting in my way. (while I’m at, how about that Thrive mascara that is everywhere)?

like

How do you know if you have outgrown someone? Known my boyfriend for 2 years but have dated seriously only for 6 months. Confused as why i’m feeling this way.

like

Are you guys as busy as you were pre-COVID? I'm at a no name and have had two transportation clients not want to sell anymore after the massive hit in March and April

like

Do you tell your boss you’re going through a breakup? I’m phoning it in and obviously going to be camera off for awhile.

like
like

Hi Fishes,
Asking for someone else from a different company, if the company’s asset fails to work and we cannot work. Does the company cut leaves? And is it the employees responsibility to get the asset?

Being ‘authentic’ is always good, right?

funnylikehelpful

Hello Folks,

I am really depressed, am the elder child of my family serving notice period and looking forward for financial growth and personal growth as well.
I am really passionate about my career and looking for Accounts receivable profile. I have 3.5 years of experience and having end to end knowledge of #O2C domain can join from 9th of June.

Kindly consider my profile.
It would be grateful,If anybody can refer.

Thanks in advance.

like

Additional Posts in Excel Genius

Would anyone be willing to teach me vlookup?

like

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

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

likehelpful

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

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

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

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 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

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!

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

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

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

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.

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

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

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

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