I have a large binary file (20mb) . When trying to reference another workbook in formula, excel won’t recognize the other workbook. Any fixes? I’ve been trying to reduce size

What is the max CTC that can be asked for 4+ yoe on AWS cloud +terraform tech stack ?

H4 EAD extension for wife got RFE. They need my 3recent pay slips to make sure I am still employed. If I am not employed how can I be in US on H1B? Do they ever apply some logic? Crazy uscis.

How often should you be making rounds at the office? Please help me understand the politics of being seen (especially if there are different rules for different levels) and tips on how to master it.

Just asked my spg ambassador for free shit. He gave me pricing for flowers and meals....any of you have a good ambassador that you recommend? Kind of annoyed spg hypes up such a shitty reward. Might just move to marriott

Hi, does anyone know how much is a salary for a Workplace Manager based in Paris? Merci!

Hi Fishes. When will we get eletter and when bonus amount will be credited?

Curious what other opportunities are out there for licensed insurance agent in P&C, Health/Life/Medicare. No sales.

NYC 3 night visit

150K IHG points
150K Marriott points

Which hotel would you recommend? Willing to pay for the third night if we end up staying in a high end hotel. But not sure if it's worth it.

30’s, M, East Asian. I’m pretty good a excel, powerpoint, and talking while in mute. Who wants to slide into my DMs haha.

Hi all
I have received an offer from Wissen for the client Morgan Stanley at Mumbai.. I was recently laid off from Publicis Sapient.... There is news that Morgan Stanley is planning to lay off people in the coming weeks. Is it good to consider this offer? Are there any layoffs going at wissen?

Looking for a young rockstar to be a Coordinator for an experiential agency, bridging the gap between creative and production and reporting directly into leadership. Message me if you know of anyone!

I’m an associate at a personal injury firm in FL where I’ve been able to learn tons about litigation and get to help people every day….but I also want to get into entertainment law (it’s a dream that I can’t let die yet).
It’s the beginning of my career, any input on how to pursue both areas of law?

Wedding venues you recommend in NYC/NJ area?

Anybody in with Discover? Looking at their AML / fraud risk roles (both remote and in South Dakota).

After 4+ weeks of quarantine, wife says I use the word "caveat" way too many times at work.

I'm like, my whole dang job is a big caveat

Is it possible to make a lot of money in Canada and if so in which companies? Compared to the US market, I have a feeling consultants are left with breadcrumbs north of the border.

You know I thought the day that Covid-19 wasn’t the top news story would mean the world finally healed.... boy was I wrong... I hope everyone is ok during this awful year

Anyone from FCB Chicago: how’s your return to office going ?

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.

Hi! I’ve got a number thats 6 digits and I’d like to make this 4. However, everytime I do my beginning and ending zeros disappear. Any suggestions? Or how do I shorten to 4 and keep zeros

Has anyone had any success here with recording a macro to set up a pivot table? For context, I am just looking to run a pivot and then run the macro and have it show the pivot table completed with the right fields in columns, rows, and values and then also formatted how I want. I tried to just record doing the setup of the macro, but I got an error message when trying to rerun.

Hi, two of my colleagues keep getting a run-time error 91 when trying to run a macro on this worksheet. However, I am unable to detect the issue nor find a solution as this does not happen to me when trying to run the same macro. Any way I can find a solution?

I have a large dataset and when I filter, I keep getting up pop ups that say “fixed objects will move”. How do I get this to stop?

Can anyone recommend good learning resources for excel? I’ve used it for years and am familiar with all the vlookups & index matches but would like to grow my skills beyond that... TIA

To all heavy Excel users, what brand laptop are you using and how’s it working for you?

Can you use the SUBTOTAL feature with formulas as well? Such as IF statements

So i have a list of companies in a list (column A), and a “Y” next to them (column B) if i want to include them in my dataset.
Is there any way i can make a variable list, ie below the full dataset, of just the companies with “Y”, and it being dynamic?
Can post a screenshot tomorrow if useful to explain

Anyone know of an excel Add-in (preferably free) that lets tracking formula in a cell?

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

Does EY’s version of excel have Xlookup? I don’t see it

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?

How do you make defined name ranges stay the same when the source is changed in power query? I’ve been really struggling.


I have a model with many defined name ranges in it that are referenced throughout. Each named range is set to be 250 rows long that way it works as long as the data set has less than 250 responses. However, when I switch the data source in PQ, it inexplicably shortens all my named ranges by around 4-6 rows (for example, one that was $B$3:$B$252 becomes $B$3:$B$246). Help?

I know this is for excel, but any Tableau experts here can let me know how to present my mixed (countries, states, provinces) data on a map. I’ve tried dual axis but still not where I want it to be.

I have a huge (12,000 plus row) healthcare dataset. Each line is an individual procedure and the date that it happened, per patient. I want to figure out the times each patient came in for one procedure per date or more than one. Can someone remind me how I can best do this?

Looking for a shortcut key that is the equivalent of PowePoint's Ctrl + Shift + Up/Down arrow.

Essentially a way to switch row positions w/o replacing or inserting cells...