If you're not using xlookup instead of vlookup, please come to Jesus and watch this tutorial that breaks down xlookup. Then never look back 😎

I only have limited time in Copenhagen, and can only choose between Glyptoteket or National Gallery of Denmark. Which one would you recommend and why?

Want a job? Want to work at S&? Are you a manager or above? Send me a DM! We’re in a big hiring push… specifically for our digital strategy team, but can always direct you to your preferred team.

Chances at SOM, Tuck, Fuqua, Darden? 3.7 from T100, 324 GRE (162/162), white lgbt male, 4 YOE with two promotions, on “young executive board” and 6 years of committed extracurricular

What are you most excited about for the start of the season?

Who’s still on the old DPW scale? 🥲

This couldn’t be more timely as I’m sitting in the waiting room after just being diagnosed 😆 welcoming tips for adjusting to Adderall!

Hello all, I'm currently negotiating salary for an Associate Business Manager role at JP Morgan, London. Can anyone please help me with what base salary should I quote?

Anyone commute on PATH from NYC to Jersey City or the other way around? What part of either city do you live and where's work, how long is your commute, and do you feel like your commute is practical with what you're getting in return, or do you wish you lived closer to work?

Anyone here from Hitachi Vantara NICE Ltd Larsen & Toubro Infotech

I have offers from above organisations and have some queries. Please help to understand which organization to join.
Tech stack: .Net FS. YOE: 6

Any good spots for live music?? New to the area

It's the end of an era: what's your favorite thing about Obama? #ObamaFarewell

How do I measure what I'm "worth" in the market? I know YOE play a role, but I don't know how to measure based on perf or whatnot. What makes one person worth more than another for the same role?

Hi friends,

I am an immediate joiner. I have 7 years of experience in automation and manual testing.
Can anyone please refer me. I am in need of job.

I need a mentor to guide me for a job role in MBB. I have 5 YOE (4.5 years in Manufacturing & Automation 6 months in SaaS) any volunteers?

Anyone have insight into the Microsoft Office of Responsible AI job postings? Three different titles and one has been reposted for six months. Are they looking for a real person or some sentient AI 🙃?

What's a simple way to explain data organization to people who don't use formulas very often? People on my team love creating many tabs instead of adding columns for recording the same type of data...

Hey everyone! I am working on a report with the intention of updating the products that a specific customer uses. Currently, the data is arranged with the unique ID in Column A, and associated products in Column B. However, each product has its own row so company 1234 might have 5 rows and company 5678 might have 20. What I need to do is collect the product data for each unique company and put it into a single row, separated by a comma(s). I am at a crossroads, any suggestions?

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?

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

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

Help unhiding columns A-D in excel. I've tried putting A1 in the select cell selecting unhide columns and also youtube to no luck. Please 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?

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

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

Today I encountered the strangest bug I have ever seen with Excel+Thinkcell. I have, as always, a separate Thinkcell sheet where I gather and structure the data (from other sheets) I want to make charts of. However, when linking this data to charts, all formulas in the sheet turns into values. This has never happened before. Anyone else seen this and knows what is going on?

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”

Any book recommendations on excel modeling for real world business applications?

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

Anyone have suggestions on where to start learning how to program add-ins with office.js?

I rarely have to use formulas in Excel, so please be kind to me.

Apart from conditional formatting cells, what formula can be used to display a word whenever a cell contains a range of numbers? Contd

I have 1 sheet with names and sheet 2 with a large list of names that may or may not be those names - which also have corresponding unique identity numbers. How do I easily match the names with the same names and keep the unique identity numbers for importing later?

Anyone know why a SUMPRODUCT cell would return to zero?

The error said ‘inconsistent formula’... (cont’d)