I'm hoping I can get some ideas on how yo accomplish what I'd like to do using excel. I have a report format that exists but I'd like to make it smart and less prone to input error.

Simplified below the pic represents 2 states of the same doc. The waterproof button determines if Test C is needed, and if not it's shaded gray. The size field changes the pass/fail criteria where the user data is evaluated. If only 2 PN then 3rd column shade gray.

Whats the best approach in excel for this?

Currently are we getting work from home for new joiners??

Hi Fishes, Has anyone attended MAKE MY TRIP interview on the QA Automation side recently ? what kind of questions are being asked, any idea would be a great help

Looking for a great Chicago restaurant for our anniversary in a few months. Would be awesome if we could try a Michelin star restaurant, but trying to keep the whole meal under $250 as we just bought a house. Not sure if that’s doable. Open to any recommendations!

What's the hike vp for sse having 5 years experience in Accenture

Day rate v. Hourly I currently accepted a rate for 20 hours a week, which I don’t like doing because I always end up working more. How do you define your hours in these instances and make it known that they aren’t paying you to be available all day long?

2021 FREELANCE RATE THREAD. Let’s share to see how 2021 budgets seem to be. I’ll start, Associate design director, $1200/day

I am looking for the weekend jobs in the production department. I have done graduation in mechanical Engineering and my majors were lean manufacturing and statistics quality control. I am looking forward for these job. Everyone wants experienced employee. Right now I am working in custom machining workshop.

Key West advice. Looking for a 3-4 day stay in February. Hoping to add this as an extension to an already planned trip so don’t want to spend to much money. Everything seems so pricey for not great value. Any recs on stays / best activities, let me know!

I heard Deloitte won't apply Green Card till 2 years after joining. I'm 3 years from H1b max out. 2 years is too late for me. Any possibility to get an earlier start during offer negotiation?

Anyone else stuck here without family? I'm in SF and my roommates are going home to their families tonight and i'm going to be alone, it's going to be a long 3 weeks..... 😭😭😭

Got my PERM approved last week and just submitted all the docs for the I/140/485/combo cards. How long it takes for attorneys to file it now?

For folks who recently got their EAD, how long from the time of filing your I-485 did you get it?

For females, family,

My Parents have 2 BHK at Pimple Gaurav, Pune. Looking for rent from 1st Oct'22

6th floor in 7 floor apartment
Ample sunlight & air
Covered parking
24 hrs water & electricity.
Unfurnished

Rent-19k
Deposit -50k

Please DM if interested

Any Sales tips? What has worked for you all when doing cold calls? And any tips and idea on building your book of biz?

Does anyone know a good trainer in nyc who works with folks with prior injuries (acl/shoulder issues) ?

Unpopular opinion: I’m glad I’m on this Call center project. Remote work that helps others >>>

Obviously hard to predict but how do people think the M&A market will look when restrictions begin to lift and we go back to something closer to our previous “normal”? Increased or decreased activity?

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.

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 🙏

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?

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

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)

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)

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.

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

Would anyone be willing to teach me vlookup?

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.

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

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.

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)

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.

Still don't have xlookup. #fomo

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.

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?

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

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap