Anyone have Excel ideas for the following problem:

Need to basically VLOOKUP multiple records within a comma delimited cell and return multiple matches in a comma delimited cell. For example: France = Paris, Italy = Rome, and UK = London. Cell currently contains France, Italy, and Rome (all in one cell). I want to return another comma delimited cell like this: Paris, Italy, London.

The problem is the iteration over the cell - would this be a VBA answer?

Hi

I have joined IBM and resigned within 50 days.
Reason: project I was allocated not good and I initially rejected project but they forcefully moved to the project.I have asked multiple times to replace the project after that I have resigned.
Now manager is threatening me that I will be placed under no hire to IBM.
Is it ethical?

What is the last date to get H1-B approval decision ?

Has delta ever let anyone change their diamond choice benefits after selecting them?

What are you doing for a retirement plan as an independent consultant? Solo 401K, SEP IRA, etc.? Any recommendations on where to open an account?

Anyone still play Pokémon Go?

any openings for associate (technology) in pwc..??

Has anyone on h1 been able to get global entry? I applied in december and got my police verification done in January and have still not heard back.

What is the average bonus and hike rate?
Team: Model Validation (Credit Risk)

PwC 🐠 - any idea of who an experienced hire should contact if they want to join Forensic Advisory?

Any openings in third party due diligence/ background screening? I am also pursuing CFE. Thanks!!

Do any firms in the forensics world offer to pay for MBAs?

Are there any ea roles hiring (mainly Chi but flex to elsewhere) with chill creatively minded environments? I am great at the work but can’t deal with the typical buttoned up seniority bootlicking LOL

Would anyone in this bowl be interested in participating in live sessions? Perhaps tips and tricks, networking, interview tips, salary negotiation, etc. as topics…

I applied for a Executive Staff Assistant for Kaiser. The range for this position is from $36-42/hr. I’ve been doing Health Admin for 10yrs starting as AD in the AF. I’m also in a Master Program for HCA. Advice on if this is low in CA.

If I have got an offer letter from Infosys and I accepted the offer, then I can be sure right that they will give joining for sure on the said date?

Does your art partner contribute to visual descriptions when you’re working on scripts?

I have an unexpected take home case study interview that requires Tableau. Obviously Tableau is not just something people have on their personal computers due to the cost. How do I go about this?

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

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.

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

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

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?

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

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

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

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.

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.

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.

Would anyone be willing to teach me vlookup?

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?

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

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.

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

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

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?