Excel now with regular expressions! I rarely use them in code, dreading playing around with something to get the parsing just right. As for why it is included, why not!?

https://hackaday.com/2024/05/24/regular-expressions-finally-come-to-microsoft-excel/

Hi folks! Starting my cloud journey this year. Looking to get certified ACP by Feb end and starting my study now.

Hi ZSers,
Anyone looking for a male flatmate or looking for a flat? I have to move in before 18th of July. Any leads would be appreciated.
Thanks in advance!

I’m still trying to process seeing an agency exec well known for dismissing and ignoring POC held up as an exemplary diversity champion for women at the 3% Conference.

Biggest conflict you've dealt with at work? How did you handle it? Lessons learned?

I was released without cause today but my boss mentioned my battle with mental health and that I’m looking for other jobs before canning me. Should I address this with the board or leave it alone?

I recently found out I was “promoted” or giving a higher title, same pay. I was told HR was updating employees titles based on the work they do… Is that even a thing?? My mid yr review is coming, should I just ask for more money?

Hi People,

Please suggest which organisation to join.

PWC or Fractal. Both are giving almost same CTC.

YOE: 4.5
Tech: Data Analyst

What you prefer to tell when people ask your income?

I usually prefer in hand salary 😇
As CTC and in hand after tax deduction is too much different.😑

If i say i am earning 45 lakh people are like wow man so nice earning...

If i say i am earning 1.5 lakh per month
People are like baju wala builder bhi itna hi kma leta 😂

Par kaise btayein ise ki baju wala builder 12 lakh tax nhi bhrta par ham bhhrte hain 😥

#Tax payers ki khani unhi ke jubani

Does anyone know of any good CLEs that address complex issues re:multi-state employers/remote employees?

Hi How's the bonus payout in crisil for Mumbai?

If someone can help with the benefits in comparison with other companies

KINDLY HELP!! 🙏🏻
Hello Amex Fishes, I have an offer from Amex. If I get a better offer from other companies, Can I re-negotiate here at Amex? ( I have received and accepted the OL, accepted LOI 2 weeks back, and BGV has also started)

Does anyone work or run a satellite office? I’m in a role where our satellite office has no designated leadership that sits regularly with HQ decisions makers. It’s me and an ECD expected to run the day to day with no visibility into the network. We routinely get agency decisions rolling down to us without guidance on how to implement. I’ve never worked in a satellite office before, what are typical leadership structures and processes for a satellite to be successful?

What kind of jobs can one get with a Msc in Chemistry?

Hello folks! Please share your favorite places to get Indian clothes in the US. Kids, women and men. Thank you so much!!

Is it 72 hours within embarking travel to India or 72 hours prior to landing in India for negative PCR test? Need to book but want to be sure.

I’m really into older women, just wish I knew where to meet them

favorite prodcos that can handle sub-100k budgets? sub-50k? any car shooters in that range?

How do you fix microsoft excel cannot paste data error?

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

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

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 😭

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.

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

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.

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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

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!

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.

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

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