Client had provided an updated data dump PnL for 100+ assets with the quarters of each year going in descending order. I have built my working sheet in ascending order. Instead of redoing a new worksheet, I’d like to copy the new numbers over to my working sheet, but I will have to “flip” the numbers ofc. Is there a formatting option in excel that allows for this? Chatgpt hasn’t been help haha.

What do you think it takes for a PPD to get a utilization bearing WBS for proposal work? I know it is rare...

I don't see myself making it to PPD. Work seems like bs and things can definitely be more efficient and effective but politics gets in the way. Contd.

Anyone who plays badminton or squash casually here?

Any thoughts on 0x.. ?

Junior associate here, should I ask for more money if my firm is about 10-15 percent less hours but about 30 percent less pay? The gap will never be closed to the top pay scale at my firm but when I decided to come to this firm the pay difference was about 15 percent and not 30. Would appreciate any thoughts on how to go about bringing this up without pissing people off because I love the firm and do not want to leave

It’s been so quiet in here... anyone was able to fly recently?

Having a baby and looking for consulting exit opps. I’ve been in strategy consulting for two years and recently promoted to manager. All projects were in tech or LS. Prior to consulting I have 10 yrs of Pharma experience with a MS in Engineering (non-CS) and data science. Fluent in Python, Ruby and Java but never coded professionally. Spent several years in process engineering and then project management. Interested in tech or digital health. Any advice on companies, roles and levels?

Have an employment law-related question if someone would like to help. Don’t need you to do research just would love to run an issue by you to see if you’ve seen it before. TIA.

Is it good to join Lexmark india as a QA.?
Location Kolkata
Exp- 8.5 years.

Hi fishers,

Current: 20 lpa
Yoe : 7.5 years
Technology: automation java selenium api
Cleared ofss interview
Can u please suggest how much should i ask depending on my current ctc and yoe.

Anyone from Nationwide? I’d like to hear feedback from current and old employees about the work environment, salary (G3), development, diversity etc. I completed an interview for Claims Manager position.

Recently joined cognizant. Current location is Pune, joining location is kolkata.
Recruitment HR has confirmed in the email that I can collect the asset from pune and work from pune for few days until I go to kolkata.
Onboarding HR is like you have to come down to kolkata for collecting the laptop. Has Anyone faced similar experience?

Today is my LWD at Cognizant but assets are not picket yet from my location.
I am receiving emails for pending ITasset clearance.
Can it be possible after my LWD?
Has anyone faced the same ?

Still don't have xlookup. #fomo

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)

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

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

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

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

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

What are your top Excel ninja tricks? Ones that few people know...

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

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

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.

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

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?

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”