Get A Distinct Count Report With Dynamic Array Formulas!

Hello - I've watched this video and several others multiple times, but can't figure out the best way to get the results I need. Can anyone help? Thank you.
I reworked the formula and see that I can't capture 2 columns of data. The Unique formula must not be what I need. I have been trying to figure this out for 2 days.
I have 1,200 line items. I need to see how many are a specific Type, then Series Name, then the number of times held, etc.
Example: Column A = TYPE = lecture, conference, skills lab, education;
Column B = NAME = Cardiac Care, Crticial Care, Trauma, etc.;
Column C = DATE;
Column D = ATTENDEES;
In Col A there may be 24 conferences, 3 education Series but they are held a variety of ways - "A" is held every month; B every week and C every 2 weeks. How many total Series: 3; how many times held in a year for each series - A=12; B=52 and C = 24. This is so simple in my head but so difficult to figure out in excel.

blank columns show 1 in excel distinct count...how to rectify this issue.if you make any video please sent the link.

Wow... Never have seen spill ranges or that notation! Thanks!

What is the equivalente to dynamic arrays in VBA? I mean, I am not sure if ".currentregion" works the same way.

U mentioned that u may use the pivot to resolve this issue, cn u plz send the link fr dat, i cant find dat video n by the way thank u sooo mch

Thank you Jon, for all the excellent info you provide.
The IFS functions (among others) only accept a range as input for the criteria range.

So how do I count distinct values when the input is an ARRAY, not a RANGE?

HI John. Awesome.. as always! Thanks for the great tips and tricks in this video and in the series. Learned a lot and had fun too :)) Thumbs up!!

Apparently new functions like unique are "spill" aware - Any other functions which could take advantage of "spill"

Cool!

It is a nice idea

Asslam-o-Alaikum Sir please help me that how can check my Internet is Connect or Not Connect with the the help of VBA Code. Please reply me.

Your all videos, content, qualities are very good a request you can you create a chennal where you answer our queries of any of your videos contant or trubalshoot or any live session in a week for this if you have convenience time for it. It will be greate for us.

nice overview of UNIQUE!

Great video sir

Good video.

Inspiring tutorial, thanks Jon

Great Tutorial Using Dynamic Arrays,Really Nice To See The COUNTIF FUNCTION..Thank You Jon :)

Very nice and quite close to my solution. Thank you for this challenge.