Is there any formula where I can change the last comma to be "and"?

Londoners, I am considering relocating from Munich to London. If you have lived in both cities, can you please share your experiences? I love Munich but looking for a better social life.

Hi Fishes

My compa ratio is 0.798 current band 6A. How much hike should i expect in april? Current ctc 4.89 lpa

P.S i joined ibm in oct 2021

How is WLB in AMD?

Any F 🐟 in Chicago ? 30M here

How do you determine what issues in your relationship deserve working on and staying despite feeling disrespected/frustrated versus ending it? Definitely have a tendency to not give second chances out of fear my kindness is being taken advantage of, but I notice many people work through it and don’t take it so personal.

Soda Stream was a simple idea and fun.

Do you prefer to be on a larger long-term engagement or various small short-term engagements?

Hello fishes
how much I expect for 2.9 years of experience, @cognizant HR offering me 11LPA. current ctc- 8.2LPA tech stack- Java, Angular

Hi folks!

I'm looking for entry level (0-2 years of experience) product roles as a Data/Business/Product Analyst or Associate Product Manager.
If there are any openings for the same in your org., please let me know!

Thanks in advance!

Hi Fishes,

I’m here to seek some guidance over a doubt of mine. I am joining a new company and they wants me to join on 21st November . But I have a notice period of 30 days which I’m supposed to serve in my current company.

I’m looking for some tips and ways to negotiate with the new company for granting me a new joining date or to buy me out of notice period and thereafter join in for the new job

Sharing my story: I carry an abnormal gene in which me and my wife's first child was affected. We decided with our second child to use IVF. We started our journey in January 2021 and my wife went through 4 IVF cycles using my sperm in a 9 month span (her choice). We decided after the 4th round failed to go a different route and use sperm donation to rid us of the gene. During 2022, she went through 4 rounds of IUI and finally got one that stuck. She is now 14 weeks pregnant and due in April 😊

Hey there i got an offer from UNESCO paris as an financial budget monitor intern( in admin department) , while knowing that i like the life in Sweden better than in Paris as an outsider. (i don't speak French) can anyone tell me if it is a good opportunity? Or is it better to stay in Sweden and do ny current intern to be a consultant?

Hi Sharks!
I had interviewed with PwC India for Business Analyst role at Pune location, my both Manager round and Client round went well. However I have still not received any call/ offer from HR. I did call the HR she told me that they have not heard back from the Client.
Any idea how much time does the HR can take if they want to give offer.
My last working day is on this Friday and will have to join other company on Monday if dnt received offer from PwC. Please guide me.

As I'm moving to a new role in a small company, I have a doubt about my salary structure like the Basic salary part is only 20,000 while my take home is 62k after all deductions.

I'm concerned because the leave encashment & other things totally depends on the basic salary.

Are there not any rules for the Basic salary to be at a certain % of CTC or it depends totally on the company?

Also PF deductions they are offering only 1800 p.m but considering 20000 basic it should be 12% of 20000 right?

What’re UX designers making at big tech?

Does anyone know when the recruiting cycles for consulting start (for a spring/summer start date)?

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Is there a better tool than than Excel for making models? What do you use?

Hey guys, did you ever encounter the following problem & know a solution:
Whenever I reference another tab in any given formula in my model, XLS first calculates everything as it should be. However directly afterwards (or sometimes only after saving) the formula vanishes and only the resulting value is left. Hence, all automation etc in the xls does not work.

Any ideas what's happening and how I can solve it without rebuilding the whole model?

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

Anyone have recommendations for a 5 year forecast model and/or template for a private company? (For a small fintech company)

Can anyone recommend a specific video on pivot tables?

Hey all, for VBA what would the code be for searching for a specific value in column A and once that value is found go to the next row, do a loop that basically copies and pasted that value into Column C, the next row would then be copied and pasted in column D, then next to E, F, and G then back to C…. Until another specific value is found?

Is there a way to easily create all the permutations of 315 possible combinations of numbers in excel?

Can somebody help me with the IF formula here please? I want to match Column K and Column O with No as the select values. I’ve tried =IF(K6=O6=“No”, ”match”) but it didn’t work. Thanks in advance for your help!

Is it selfish and immoral of me not wanting to share the complex formulas or tricks I know in excel? I want to be clear I don’t mind sharing online, but don’t like sharing with teams I work with since I think of it as my IP.

Hi guys!

I need help with something: I recently started using xlookup in excel to automate recurring tasks (accounting) but I have found that my peers and supervisors have difficulties understanding how the numbers are pulled, which makes their understanding of the files difficult.

What would be the best way to convert the result of an xlookup cell to a reference to the found cell?

Is there any way that could be applied to all the xlookups in an excel file?

Thanks in advance!!

Just wanna say thank you to this group of beautiful people, always willing to help each other reach a solution!

Anyone have a easy formula to turn “2 years 6 months” into 2.5? Thanks!

Bit of a vague Q - but folks who do a volume of DD’s: what best practices for data cleansing & modeling do you employ? I’ve done several DD’s now and feel like a huge chunk of time is due to me re-creating the wheel / not being as smart as I could be in Excel.

Excel gurus I need help ASAP! Is there a way to convert a process flow into a checklist in excel? The main confusion I’m having is how to take the diamonds of the process flow and based on the response convert that into a checklist.

Best way to learn Spotfire? Just watch YouTube videos?

Not really excel - trying to convert a “text formula” result into a number result but I’m stuck

IF (AND(Monthly_Unique_Visitors__c  >= 0, Monthly_Unique_Visitors__c <= 50000), "-50",
IF (AND(Monthly_Unique_Visitors__c  >= 50001, Monthly_Unique_Visitors__c  <= 100000), "-20",
IF (AND(Monthly_Unique_Visitors__c  >= 100001, Monthly_Unique_Visitors__c  <= 250000), "0",
IF (AND(Monthly_Unique_Visitors__c  >= 250001, Monthly_Unique_Visitors__c  <= 500000), "7.5",
IF (AND(Monthly_Unique_Visitors__c

I'm trying to analyze some data on Excel. I have no idea what these column headers mean: SI GREV, GTN P/SI GREV, ST BMC GP

Any ideas?

Anyone work on a Mac and use parallels when in need of excel? If so, does it work or is it a big no-no? My work going forward will not primarily be excel, but I have to use it on weekly/monthly basis. Might also have to use some Power BI. Would love to go back to working on a Mac but excel has stopped me from buying one…