Anyone got a good form to count distinct values in a table with conditions? I can use countifs to get the total number of rows but I also need one that gives me a number of distinct values in another column.
Eg countifs(Foods[[#All],[Breakfast], ""Apple"] gives how many rows have apple for breakfast but I also want to a number of how many distinct values (e.g. customer column) match this condition. ChatGPT says to use sum with the column I'm checking but the result is definitely wrong.

I teach British Lit. For anyone else who teaches this, what are some of your favorites to teach? I have been doing Beowulf, The Canterbury Tales, Macbeth, Etc., but want to add something new this year

Is it worth it to exit for pharma sales? I know some people have made the switch. The money is tempting but I can't help wondering if it's just a "grass is greener" situation

What is the starting salary for an entry-level Procurement Coordinator in SF?

What is market standard for pega dev with 8 yrs of exp,?
What should minimum and maximum can get?

So, recently got put on a PIP after six months at my new job., two days after I told my boss and HR I recently learned I have a cognitive disability caused by an illness. The PIP was mostly because I forgot some deadlines, but also they said I need to be more professional in emails (even though others use zero punctuation and a lot of emojis. To clients.) and simultaneously ask more questions and ask fewer questions. Should I just assume this is unattainable and look for a new job again?

Colleague said “oh hello, who the fuck are you?” When I brought up what I guess was an unwanted opinion. This was years ago when I was more junior.

Is there any not very expensive black tie gown shops near Toronto downtown? New to the city and office party has black tie dress code!

If you had a mentor for your tech career what kind of things would you be most interested in learning about? If you already have a mentor, can you share the most valuable things you have learned?

Hi all. I’m a ux designer at a small company and need to recruit a few people for usability testing. Our target demographic is people over the age of 35 who’ve been in leaderships positions. If you’re interested I’ll send the link- the test will take about 15-30 minutes and pays 20$. No human interaction required.

How long is it taking for new joiners to receive their laptops if they asked it to be shipped?

im 27 and could possibly retire if I kept my spending low. However you never know what’s going to happen, do you? How do you deal with the uncertainty?

Does anyone know how much 1st year associates are making ($$) in tech risk at Goldman Sachs?

Hello,
Why there is so much of hatred towards Kyndrl all over . Is it really such a bad company .

Hi Everyone!

I am looking at hiring a Sr. Salesforce (Sales and Service Cloud) and Sr. Salesforce (Marketing Cloud) Consultants. They can be based anywhere in North America. If anyone is interested or knows someone who might be. Please shoot me a message or comment below.

PS - Open to Full Time Permanent opportunities or someone looking for contract work is also okay.

I give the clients gold, but they decide instead, they want me to paint it with sh*t.

What is the salary range for Senior Software Engineer in Oracle India? And can anyone explain the general designation hierarchy in Oracle?

Has anyone taken the CAIA ? Any tips ?

Anyone who said no to a prospect because of personal reasons? Going through a rough patch and would really appreciate some advise on how to do it without burning (that many) bridges.

Snowbird here, heading down soon. What fun things are happening Labor Day weekend?

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

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

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

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

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

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

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.

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

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

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 😭

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

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?