Hi

I need assistance with a task. I have an excel spreadsheet with rules for a platform. I have another excel spreadsheet that is an audit of how that platform is currently setup. Is there a way that I can check the rules against the audit to determine if it’s set up correctly?

Any good books or recommendations on sales? Sales tactics trips and tricks?

Any advice on switching from litigation to a more advisory role? I like legal research but don’t like the stress of litigation anymore and feel like it’s taking too long for me to get “good” at it.

Has anyone here worked (or does anyone currently work) for Bernstein Litowitz (aka BLBG)? Very interested to learn what inside associates feel about the firm, its culture, work-life balance, billable hours, etc.

Fishies—does anyone know of a way to convert a deposition transcript to remove all page:line numbers? I’d like to use text-to-speech to listen to transcripts but I can’t in the normal format.

Any one ever worked at Clean Energy Counsel LLP? Have any insights on the firm, career advancement there, business development, etc. Thanks!

Pretty quiet in here. Anyone do anything cool recently? Any spring/summer plans?

Got an offer for Sr. Financial Analyst for 85k & 10% annual bonus. What's a good counteroffer? I told the recruiter 95k-110k when I first interviewed. This position is 100% remote, headquartered in VA. I live in NYC. Have roughly 2 YOE.

Thanks.

How strict is Jio background verification?? My wife has not shown her previous company in CV and now HR has asked to share last 3 months salary slip to release offer letter. Is it fine if she skip this company??

I heard promotion of higher management is already announced?
When will the promotion of level 11 and 10 will be announced?

What skills needed for data engineer role in FAANG companies?

Is there any bench policy in amdocs. My project will end in january. What will happen after that?

Any knowledge about Montessori schools in Portland? Childpeace in particular, but info about any would be appreciated. MSB? Sunstone? West Hills? Thank you

Just lost my job. Has the job market started to cool down? What should I expect for leadership roles in I.T.

PwC S3 in FS audit NYC, up for promo this year. What’s the M1 and M2 base range? M1 more specifically. Thanks!

Any insights on compensation for a US based role with the Public Investment Fund? Looking to make a career shift and hard to find anything since PIF’s US footprint is so small.

Pune people! Anyone up for a badminton game in LSBI this week? Ps. If you guys already are a group and one player short, text me!

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!

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.

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.

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

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.

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)

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.

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

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.

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.

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

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.

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?

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?

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.

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