Geniuses can you please share some ideas/creative ways to track the following..

Case: have around 25 companies and associated info. Part of that info includes company contact point info (name, email) each company may have 1-8 contacts. Contacts change frequently. Ideally I’d like my columns to be |comp name | contact name| contact email |etc, but the issue is I need to track when people leave a company, can’t delete the data.

Rn I have 1 sheet holding comp info, another, contact info.

Question!
* Anyone ever feels like when their salary gets credited -> “This figure is disappointing!” vibes *???

Hi fishes,
1. I heard that few people received promotion mails last week. Is it true?
2. Also I got a mail about promotion requirement compliance status pending, does that mean I am getting promoted or is it a default mail.
3. Also I joined pwc ac bangalore around 10 months back as associate 2 , how much hike and bonus can i expect with/ without promotion

Current CTC 12LPA
YOE 4.6

Thanks in advance

Anyone know the CD salary range for American Express’ in-house agency, OnBrand?

Can anyone tell about the Business transformation consultant role in IBM? What is the salary range?

What's the salary range of a SAP FICO Consultant (5-7 yoe) at companies like Wallmart, Mercedes Benz, Autodesk? Can anyone please enlighten me?

Finishing up a clerkship & trying to negotiate a clerkship bonus with my firm. Anyone and everyone - drop the clerkship bonuses you’ve heard of (or received) & firm size (small/medium/large is enough) so I can come with some numbers/averages. Much appreciated!!

I have 5+ years of experience and having 3 offers

1. Infosys -9.5 lpa
2. Wipro - 12.0 lpa
3. Mphasis -13.0 lpa

If I consider salary as secondry criteria ,Which one I should choose so that I wouldn't regret later. Please suggest ?

Hi fishes, urgent. I have offers from two companies. One is offering x. Another x + 6. While telling the company (with x offer) that i have got offer from another company, do i have to show the whole offer letter to negotiate? And if i'm showing only the salary breakup page, should i hide the company logo?
Can HRs talk internally to mess with your offer from another company?

What would be a reasonable salary for a 3rd year lawyer in house at a real estate development company with a total of 3 lawyers (they are co-gcs for different parts of the company)? I’d be the 4th lawyer in the department as a whole. HCOL area.

What is considered a good day/hourly rate for a freelance senior motion graphics designer in LA?

Hello...

Can anyone tell me what is the salary structure like allowance , facility , or other things in American express apart from CTC offered.@

Who has experience being successful with a counter-offer for a role based on another companies offer? I want to accept the lower salary role but with a pay nudge - the higher salary I don't care for. I'm worried I could lose out on both

Hi everyone. Is 15000 AED per month a good salary for a Marketing Manager role in Dubai?
Also Is it standard to have a 1 year bond in UAE?
My current CTC is 18 lpa.

Hi All, I have cleared all rounds for GSK and am being offered grade 7, and HR Hasn’t released the offer yet and asking my expectations. He hasn’t given me the full range. I have 9 + years of exp, and CCTC is 20.7 fixed, last year I got 40% bonus on top of my CTC. What is the range which GSK can offer for grade 7? And will it offer 7a or 7b or anything else? Please help!

Visiting New York next week and have a reservation at the sushi counter for lunch at Nakasawa. How rude will it be if I started working at the counter? I’m doing everything in my power to close a deal the day before but it ain’t looking good…
Normally, I wouldn’t have issues working in a restaurant, but I feel like in this setting it may be really disrespectful the chef.
And yes, I only want to eat at the sushi counter for a full omakase experience.

I've taken all the exams twice and only passed BEC... got a 71 on REG and 66 on FAR. I really feel like giving up. What are some tips to stay motivated?

Anyone looking to join a rapid growth boutique strategy firm with great culture, great clients, and great compensation? Our Dallas office is looking for an experienced Manager with ~8 years of experience. I joined about 3 yrs ago after a decade in B4 and couldn’t be happier in terms of comp, WLB, and professional growth. DM me if interested

My portfolio literally went up 15 pc in the past 2 hours

Has anyone been terminated from Novartis?

Hello,

How much should I target in the market with following:

YOE: 3.9 years (first job)

Data scientist

CCTC: 9.5 FIXED

Offer in hand :18+1(variable) I'm confused about should I stop here or try more? 40 days on notice period left.

So I'm an older student with 10+ years of career experience. I am trying to update my resumes, yes plural, because I have experience in many industries. My biggest struggle right now is keeping my skills list concise for Marketing Analyst. What is an appropriate number of listed skills for both hard and soft

Is firm travel back up to pre covid levels?

I've been a government attorney for nearly three years now and have worked in the same office/division since I passed the bar. I've yet to receive a promotion other than two cost of living increases (in sum, a pay increase of 6k over 3 years). I know this is meager, but I'm mostly ok with it, I just want to see some recognition. On the other hand, it's hard for me to imagine negotiating because (given my inexperience), I don't feel I'd be able to do better anywhere else. Any advice?

Hi friends,,
How many are going to Chennai ofc in Taramani.. i will be joining coming Monday

Thinking of heading to Maui (for the first time) for thanksgiving and seeking recommendations for a hotel (considering Ritz but open to others) and things to do. TIA!!

I have an offer from fidelity investments and Amadeus labs. Pay is almost same. Please suggest which is good in terms of learning, wlb, job security, growth.

As a GC holder I’m planning to travel abroad for 2,5months starting late September.

My lease is up on 8/31 and I don’t want to commit to another lease, to save money until I’ll be back to the US in December.

Is this going to jeopardize my resident status? Can I go without a lease?

Any place to go few hours drive from Austin? Have a 3.5 yo so want to keep it enjoyable/relaxing for us at the same time keep the kiddo engaged and happy. We just need a good change of scene.

Thoughts on Prime Ocean here?

Anyone refer for java 6 years experience for ford? Lwd 22 aug

Hi,
Joining SAP labs, Bengaluru on 8th of August.
Looking for a share of accommodation. Female preferred.
Thank you..

How have you evaluated moving to a totally different t career/industry then the one you were in?

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

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

Would anyone be willing to teach me vlookup?

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”

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!

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

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!

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

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

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

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)

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

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?

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

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?

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?