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

Name one thing you're thankful for.

Any cyber security folks here? or those interested in systems engineering? Potential role with TC 120-180, awesome team and wlb, at least compared to consulting.

What would you choose between palantir and a small startup with great growth opportunities?

I've been always eating tons of sugar growing up and I've finally decided to stop eating heavily processed food/sweets a month ago. Turns out I was really addicted without realizing it and I truly experienced mental and physical symptoms during the last few weeks (cravings, fatigue, dizziness, etc.), but feeling better every day. Anyone experienced anything similar? I don't smoke and don't even drink coffee (yep, no caffeine at all) so I never realized how dependent on something I was.

What is the name of the credit card that gives you United PQM for each dollar spent?

Hi sharks,
Is it mandatory to deduct amount in NPS in persistent salary slip, even it's having EPF?

Anyone have an extra ticket or know where I can get my hands on a ticket to infinite mirrors? I'm here for work and would love to check it out!

Best happy hour in the Dupont/Logan/Shaw neighborhoods? For a date. Please and thanks.

How long does it usually take to clear conflicts? Mid level. Around 50 client matters.

Hi guys.. would like to know what's the probability to get selected in H1B lottery?

I have an offer from another company with 30 lpa and current company offering H1 nomination next year with 98k usd.. need some suggestions.

Yoe - 13 years

Any tips for the functional interview for Amazon’s Contracts Manager position? Studying the leadership principles but don’t want to overlook the functional portion.

I hope that they swabbed that plexiglass for droplets and then send it to a lab for Covid testing.

Does Bank of America provide cab facility to NOIDA?

For those with experience with Apache Superset, please tell me more. Why do you prefer it, which environment does it work best in, pros/cons, and why should I choose it over Tableau/PowerBI?

Is it burning a bridge for leaving PA after only less than a year working in the company? I am in the verge of giving my two-week notice.

Want to start saving/investing from this year. Got £11K and will have £2K a month to invest - any recommendations? I don’t want to take crazy risks, somewhere where this is steady long term growth. Have already maxed out pension and I assume next step is maxing out ISA? After that, what is best? (From UK)

I am about 100 nights away from reaching the lifetime grandfathered premier access, not sure if I can make it by year end. No longer on travel projects. Any tips? Any new updates from Marriott?

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

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?

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

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)

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

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

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

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!

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

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.

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

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

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

Would anyone be willing to teach me vlookup?