2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Count Distinct Values only if Separate Column is not Blank

Fairly beginner here. I've searched multiple phrases in a search engine, looked at a dozen+ sites, and searched through this subreddit, to no avail, so I think I must be either misunderstanding what I'm reading, or not using the right magic words. Getting muddled between COUNTA, COUNTA, IFS, UNIQUE, FILTER, and various combinations thereof.

I do have it in a named table, and know how to input that. Example: tblName[ColumnName]

Column A: dates (MM/DD/YYYY). Some are blank; some are dates, some dates are duplicates.

Column B: Regions. None are blank, but there are duplicates.

I need to count the distinct (I think) number of Regions in Column B, only if Column A includes any date.

A B
Date Region
03/10/2026 Region1
Region1
03/10/2026 Region1
03/10/2026 Region2
Region3
03/09/2026 Region2

The right answer is that there are 2 regions. I don't need them listed, I just need to count them.

Thank you so very much.

EDIT for Additional Info:
I've figured out how to count the number of entries with dates: COUNTIF(tblName[Date],"<>"&"")
I've also figured out how to count the total number of region entries with dates: COUNTIFS(tblName[Date],"<>"&"",tblName[Region],"<>"&""), but can't put the two together.

submitted by /u/Admirable-Hornet3673
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#COUNTIF
#COUNTIFS
#COUNTA
#DISTINCT
#UNIQUE
#FILTER
#regions
#dates
#duplicates
#named table
#column
#tblName
#count