Is there a way to format cells when using modern formulas such as 'unique' or 'sort'?
How you do you do it?
Also, I read about the 'pivotby' formula but can't seem to be able to enable it. Suggestions?

How to get US opportunities being in a product based start-up ?
I've got 1 yoe in NodeJS

Hi guys

This question may not be related. However I wanted to know from personal and family point of view how it is like to relocate from India and live abroad .
Let's say Family consists of husband , wife and a kid . I understand we will get good facilities, education, cleanliness , good air etc , however I wanted to check whether people gel up easily in the new environment? Don't they feel loneliness/ difficult to adjust? Do they look for similar asian nationalities to kill boredom?

Is it worth doing mba from mediocre college with 4+ yrs of job experience?
I can't continue with my job anymore its making me sick

Hi fishes, I want to submit broadband connection reimbursement request via Global Claim System GCS. Is there any chances of background varification regarding the broadband bills??
Thanks in advance.

Currently a staff attorney in US firm, hoping to secure the permanent position as Associate after contract ends. Any advice?

Anyone in consulting and doing OE? Using bench time for J2+ seems like a good opportunity in this environment, considering it wouldn’t look out of place to remain on the bench for quite a while

Just wondering if any Junior designers feel the same but I work as the only graphic designer in a small digital marketing agency and lately there isn't any new projects and work coming in at least in my "department". No one is really touching base on anything but I'm still getting paid a salary ($42k/y). I worry that they may just cut me off any time soon since I feel I haven't been contributing as much as I want despite reaching out for any new requests. Thought?

Hi Fishes,

The Be Well Work Well gifts that some people have been posting about on LinkedIn, is for everyone at PwC AC Kolkata or is it just for Assurance staff?

Any parents under H1B? I was@looking to get an au pair for kids and got to know that I cannot host one because I don’t have a green card yet. Any options? I heard people get au pairs that have another year remaining in their visa but couldn’t find one yet

Does anyone know the salary range for executive director roles in the payments business?

I'm a crypto Twitter influencer, AMA

What is salary range for l07 at TD?

Looking to move into remote work, currently have lots of construction management experience. Would anyone know of any remote jobs that they could refer me to that would be interested in me as a new hire?

Exiting to a boutique for a promo/more comp/WLB? Good idea?

Projects will be focused, long term comp is still great but obv much lower than MBB.

Any thoughts?

Moving from T2 to McKinsey. How do vacation requests work? I have family and friends getting married this fall in weddings delayed because of covid, but I’ll just have started so wanted to get a sense of how realistic taking vacation this fall would be and how to approach taking it (e.g. mention to HR, staffing). TIA!

Fellow MBBers, any of you think the banking raises will trickle over to us (110k starting) or nah?

Any idea if these comp increases will make it to Canada?

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

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

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 🙏

Still don't have xlookup. #fomo

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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?

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

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?

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

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.

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

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

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

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.

Best websites to get more of a handle on Excel as a beginner-intermediate?

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