I need to count the number of Distinct entries in two columns. (table is attached)
Column A has sorted account numbers. There are repeated entries.
Column B has a 'y' or an 'n'.
I need a formula to enter in my spreadsheet to keep the count up-to-date as entries are made.
The three separate formulas will be:
- Total DISTINCT Entries:
- Total DISTINCT Entries with an 'n':
- Total DISTINCT Entries with a 'y':
Obviously, for a value to be Distinct, it will only count the first instance of each instance of [Col-A and Col-B], meaning that at the most there could be one 'n' and one 'y' with each account number in Col-A.
The attachment shows the sample data and the desired results. I just need the formulas to put in E5,E7,E9 to do this for me, without having to manually create a filter every time I want an update.
Any assistance is greatly appreciated. I have found lots of similar problems but none that I could actually use to work this out. Thanks!
Bookmarks