How can I pull the text before a certain set of characters?

Experienced Hires, how do you feel about the recent $1500 “thank you” from Deloitte?

Is that possible to select different regime while filing ITR?

Example: For FY Apr 2021- Mar 22, I selected new regime in the company portal and hence more tax deducted. I have submitted the rent receipts to the company for tax exemption. Hence during filing ITR, can I select old regime and get tax return?

Hey Portland!!!
Wondering cost of living in and around portland?
I’m thinking about moving from SF to Portland for a great job salary starting around 90k. I’m 30 years old with 1 child who lives with his mother.

This is awesome. Thank you to whoever started this. Yes let's keep helping each other.

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

I'm currently looking for a junior project management position, Can anyone give me some recommendations? Preferably remote or in Jacksonville, FL

Has anyone tried the prose shampoo company? I see ads about it all the time and they seem to have great reviews. I just want to be able to wear my hair natural 😩

Currently I work for a mid-sized InsureTech that’s had 2 rounds of layoffs in the past 6 months. Salary is 100k, with no defined bonus. I have close to 4 years of PO experience. I am debating whether I want to leave since my boss is very chill and I have amazing WLB. Benefits are eh. 15 PTO days and healthcare premiums are okay. Should I jump ship? What could I be making at a bigger company? What types of companies are most stable right now?

Anyone ever had a pending asylum case and got an employer to sponsor them? TIA!

Currently filling DS 160. My parents are currently in US on B2 and will go back in July. When I go for my H1 stamping, they will not be in US. Should I answer the question on whether they are in US based on where they will be when I go for stamping or where they are when I am filling the DS 160?

What shall I choose and why?

IBM 22.5 LPA Fixed + 0-10 % Variable
PWC SDC 23 LAP Fixed + 0-17% Variable
Oracle Consulting 25 LPA Fixed + 0-10% Variable

Role is almost same in all three.

Which has better OnSite opportunities outside india?

Is is okay to have dates mentioned in offer letter for PwC like below -

Date: {{Dte_es_:signer1:date}}

How is PwC SDC kol if we compare it with EY GDS and D USI?
In terms of project and Hike %?

How often does your HR communicate to you regarding the interns in your team and what do they usually talk about?

Anyone go to One Medical Midtown? Or the other locations? Thinking of making a switch.

ZS leave karne ke baad FnF amount 2 parts me aata hai kya?

I completed PGDM (Finance) and am currently working as a Oracle Functional Analyst (Consulting) at Deloitte USI with 1.25 YoE. My area of Interest is Corporate Finance, Equity research, Valuations, Mergers & Acquisition, Investment Banking.
During Internship worked on Feasibility of start-ups and real estate property, Analysis of Mutual Funds, DCF Valuation, Altman Z Score, etc.
I am looking for a job change in the above mentioned areas and would appreciate any kind of help with it. Thanks 😊

I have a simple formula outlining the condition that if the range of values for each row is greater than a particular cell within the same row, then highlight. Need to find a shortcut to replicate

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

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

I have a date I need to match to an array of strings (that represents dates). Eg matching 6 nov 20 to (20201106, 20201107, etc. ). I can convert my date into this format using text(date,”yyyymmdd”) but then my lookup tried to match “20201106” with that list and the “ causes a mismatch. Any hints, and I would prefer not to change the array format?

Anybody know if you can access an older version of an excel file (like from version history) using vba?

Trying to write a script to compare old versions and list changes since a given date

I have a big data set, which is compiled via power query. The source data gets updates every now and then. As the client isn't consistent with his organizing, I get a problem with my pivot. (Cont)

Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

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

Too many format error, already tried the XLStylesTool. What next?

I have a spreadsheet that pulls data from rest APIs into power query. Is there anyway to make this sheet work for people on Mac?

why is index match superior to vlookup?

This isn’t exactly an excel question, but is there a way to clear the “last modified by” history on an excel document in SharePoint? Accidentally opened a file i shouldn’t have.

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

Anyone know the shortcut to format selected cells as short date IE mm/dd/yyyy?

Hello Excel Genius!
How do I calculate the monthly average of items returned and credit return by each division in a year?
Thank you!

Is there a way to color a cell based on the color of another cell? I have Sheet one with green, yellow, red used to denote progression status on 20 tasks, which constantly changes based on client input. Sheet 2 is a summary dashboard of each of those 20 tasks. If sheet1 C3 is green, how can I get the respective sheet 2 dashboard cell to also turn green?

Had an interesting issue this past week. Batch of client data looked normal in Excel, but when imported into our analysis software that we use for larger data sets and their manipulation (cont.)

Best way to learn Spotfire? Just watch YouTube videos?

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