I have two tables. I want to add a Start Date for the actions in Table 2, by looking up values in Table 1. Start Date is the date when the number in Table 1 is >1 the first time. So for Action 1, Start Date is 9/1/2024, and for Action 2, it is 10/1/2024. Any recommendations on the formula? Thank you.

Why are we as a group not so active in helping each other ? I understand there are many members who joined with aspirations to learn DS. But existing members from DS are not active. sad sorry

I am a Management Information Systems grad student from University of Memphis, with a cumulative experience of 5 years ( 2years - Quality Data Analyst, 3years - Human Resource Co-Ordinator). I'm looking out for Summer Intern'22 in and around companies in Memphis and Nashville, specifically looking for recommendations for applied positions in FedEx. Any leads will be graciously appreciated.

Hello,I’ve 11 years of experience in hardware verification. I know SV, UVM. How can I change my career field to AIML? Please guide

Anyone buying Btc or GBTC? Thinking about selling all. Any recommendations??

Such a Boring session today! 30 mins left. Any drama big movers?

This is our first holiday season in the Nashville area, any suggestions on family activities/light displays we should check out? Our kids our 8, 5, and 3.

Where did you come from? How has your onboarding experience been?

Is RPA a bubble and will soon fade away? How much valuable is it as a skill set?

When it comes to therapy do I look up a place online and make an appointment or do I need some sort of referral? Not sure if I need to see a therapist or physiatrist really.

Is it bad to apply to 2 different roles in different service lines at the same firm?

Remember to be grateful: if you’re healthy, there are 100’s of thousands sick from COVID, if you have a job, millions just lost theirs, if you have a home, 10s of thousands are close to missing a pmt

Any reviews about working at the Telegraph Media Group? What’s the culture like?

Can anyone please share any information related to the insurance and benifits provided in Deloitte India?

I can’t anymore I can’t 😭

What do you think is the actual income ceiling for software engineering, broadly? I'm genuinely curious and don't even know what's possible

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

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 🙏

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

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

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(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.

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

Still don't have xlookup. #fomo

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

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

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?

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.

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

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)

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.