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?
Very helpful, I am one doubt if we have few blanks in source dada and when we apply pivot distinct count, it will also count blank cell. How to avoid blank cell count in this situation. Pls guide
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.
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.