Anyone knows how to use goal seek function that can be used on a column? Or a formula that would do the same job?

Anyone have experience with Nomos? Don’t have a lot of exposure there but a client recommended looking at them. Scrolled through their selections and loved the Lambda but it’s way out of my range.

Losing friends to play with. Anybody down to play? ASL? 1.19KD lol

I NEED MORE PLANT PICS ON HERE!

I work in a firm that is known for litigation defense. I’ve been developing my own plaintiffs practice as well. I am able to pay the bills with my hourly defense work, which gives me time to focus on a handful of high value PI case a year on contingency. I was recently negotiating a case and was told part of the reason the claims rep/OC was jerking me around was because they didn’t see me as a plaintiffs attorney. Is there any way to change this perception or does it just come over time?

Just started Prozac a week ago. Do the side effects diminish? If so, when....any first hand experience?

I wanted to get your thoughts on the following:
1. Health Insurance for your parents (assuming they are 60+)
2. Term life options for myself (under 30)

I recently went through a medical family emergency and realised how important insurance is. Any suggestions will be appreciated.

Nurses in biotech/pharmaceuticals/medical device sales: I am interested in making a switch and growing my career in one of these fields. Love the idea of making greater scale impact on patients. Looking for tips and advice on how to break into the industry as I start the process. Currently have 10 years of experience as an RN ranging from Multi-system/transplant, cardiac, and burn/trauma ICUs, to NICU and currently pediatric ED. Please feel free to DM me instead. Thanks in advance!

What % of the Fixed CTC is paid as Variable in Crisil ??

I am a Salesforce developer with 4yoe currently working with tech Mahindra.

I recently got offers from wipro and Capgemini

Wipro - 17 lpa(fixed)
Capgemini - 16.9 lpa (fixed)

Suggest me which among them have good work life balance , scope of learning and career growth.
If you want to suggest any companies other than the above two , with good wlb and scope of learning please let me know.

Any fishes here born in 2000’s ? How do you adjust yourself to the generation gap in your team?

Does your school allow you to send out a supply list? I have to buy all the student supplies for my SPED classroom.

What’s a typical salary for a Director of Operations in the NYC area?

I dint feel happy when my bf proposed me for marriage.. i am not able to understand why..he is very nice guy, we have been dating for almost 4 years but honestly, in these 4 years, i never had that butterflies feelings with him never ever. Its just that we are comfortable with each other as a person thats it and we started dating.
Whats wrong with me..i am also not sure if i want marry him..

Best part about being single: Not having to hold in my gas ! What is the best part of it for you??

Has anyone been through a situation that you were in a terrible relationship ( stress,anger, fights, swears, physical abuse, ego clashes) and how did you resolve it? Some might have worked on and stayed in the relationship and some might have broken up. I am looking for answers from both sides. How did you stay/work on it and how did you break up and move on? Me and my partner have strong feelings for eachother and are almost inseparable despite going through so much.

How are hours in CMAAS?

Best self-help books on the market? I've been consistently unhappy lately. Something needs to change.

What makes a start-up successful?

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

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

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

Would anyone be willing to teach me vlookup?

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.

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

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

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

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

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)

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

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?

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

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!

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 😭

Any book recommendations on excel modeling for real world business applications?