Hi,

I just joined this community and looking for some help! I have a set of data from which I am trying to count unique items under certain categories. For example, there are multiple categories and under each of these categories, there are different items. I am trying to count how many unique items are under each category. I tried to combine COUNTIF and UNIQUE functions, but unfortunately not getting the result. What should be the best way to get a correct count of unique items under each category? Any help will be hugely appreciated!

Here is an example of the data set I have:

VendorProductDescriptionRef/serial NbrReasonRcvd DateCategoryAQF1Q44PRODUCT Q TW11831010/19/2021ACCAQF1Q44PRODUCT Q TW11841010/19/2021ACCAQF1Q22PRODUCT Q – FL11851010/19/2021ACCAQF1Q22PRODUCT Q – FL11861010/19/2021ACCAQF1Q22PRODUCT Q – FL11871010/19/2021ACCAQF1Q22PRODUCT Q – FL12621012/23/2022ACCAQF1Q23PRODUCT Q – QN12631012/23/2022BBBAQF1Q23PRODUCT Q – QN56811010/12/2022BBBAQF1Q23PRODUCT Q – QN11391303/03/2013BBBAQF1Q23PRODUCT Q – QN43441302/24/2016BBBAQF1Q23PRODUCT Q – QN43451302/24/2016BBBAQF2Q37PRODUCT Q – KG52681303/16/2023DDDAQF2Q37PRODUCT Q – KG23341306/27/2013DDDAQF2Q37PRODUCT Q – KG23381306/27/2013DDDAQF2Q37PRODUCT Q – KG23391306/27/2013DDDAQF2Q37PRODUCT Q – KG23401306/27/2013DDDAQF2Q37PRODUCT Q – KG23411306/27/2013DDDAQF1B03PRODUCT AQ – FL23432606/27/2013EEEAQF1B03PRODUCT AQ – FL23502607/02/2013EEEAQF1B03PRODUCT AQ – FL23512607/02/2013EEEAQF1B03PRODUCT AQ – FL23522607/02/2013EEEAQF1B03PRODUCT AQ – FL23532607/02/2013EEEAQF1B03PRODUCT AQ – FL23542607/02/2013EEEAQF2F04PRODUCT AQ – TW23553707/02/2013AAAAQF2F04PRODUCT AQ – TW23563707/02/2013AAAAQF2F04PRODUCT AQ – TW23573707/02/2013AAAAQF2F04PRODUCT AQ – TW23583707/02/2013AAAAQF2F04PRODUCT AQ – TW23593707/02/2013AAAAQF2F04PRODUCT AQ – TW23603707/02/2013AAAAQF2F04PRODUCT AQ – TW23613707/02/2013AAAAQF2C22PRODUCT AQ – KG23922607/11/2013BBBAQF2C22PRODUCT AQ – KG23932607/11/2013BBBAQF2C22PRODUCT AQ – KG23942607/11/2013BBBAQF2C22PRODUCT AQ – KG23992607/11/2013BBBAQF2C22PRODUCT AQ – KG24012607/11/2013BBBAQF2C22PRODUCT AQ – KG24022607/11/2013BBBABC1T22PRODUCT T – KG24035007/11/2013ACCABC1T22PRODUCT T – KG24045007/11/2013ACCABC1T22PRODUCT T – KG24055007/11/2013ACCABC1T22PRODUCT T – KG24065007/11/2013ACCABC2T32PRODUCT T – QN24095507/11/2013ACCABC2T32PRODUCT T – QN24105507/11/2013ACCABC2T32PRODUCT T – QN24115507/11/2013ACCABC2T32PRODUCT T – QN24125507/11/2013ACCDEF1A03PRODUCT A – QN918185011/27/2023DDDDEF1A03PRODUCT A – QN918195011/27/2023DDDDEF1A03PRODUCT A – QN918205011/27/2023DDDDEF1A03PRODUCT A – QN918215011/27/2023DDDDEF4A04PRODUCT A – FL918226011/27/2023EEEDEF4A04PRODUCT A – FL918236011/27/2023EEEDEF4A04PRODUCT A – FL918246011/27/2023EEEDEF4A04PRODUCT A – FL918256011/27/2023EEEDEF4A04PRODUCT A – FL918266011/27/2023EEEDEF4A04PRODUCT A – FL918276011/27/2023EEEGHI1R01PRODUCT R – TW918287711/27/2023ACCGHI1R01PRODUCT R – TW918297711/27/2023ACCGHI1R01PRODUCT R – TW918307711/27/2023ACCGHI1R01PRODUCT R – TW918317711/27/2023ACCGHI1R01PRODUCT R – TW918327711/27/2023ACCGHI3S03PRODUCT S – FL959051412/30/2023BBBGHI3S03PRODUCT S – FL959061412/30/2023BBBGHI3S03PRODUCT S – FL959071412/30/2023BBBGHI3S03PRODUCT S – FL959081412/30/2023BBBGHI3S03PRODUCT S – FL959091412/30/2023BBBGHI3S03PRODUCT S – FL959101412/30/2023BBBGHI3S03PRODUCT S – FL959111412/30/2023BBB

​Hi, I just joined this community and looking for some help! I have a set of data from which I am trying to count unique items under certain categories. For example, there are multiple categories and under each of these categories, there are different items. I am trying to count how many unique items are under each category. I tried to combine COUNTIF and UNIQUE functions, but unfortunately not getting the result. What should be the best way to get a correct count of unique items under each category? Any help will be hugely appreciated! Here is an example of the data set I have: VendorProductDescriptionRef/serial NbrReasonRcvd DateCategoryAQF1Q44PRODUCT Q TW11831010/19/2021ACCAQF1Q44PRODUCT Q TW11841010/19/2021ACCAQF1Q22PRODUCT Q – FL11851010/19/2021ACCAQF1Q22PRODUCT Q – FL11861010/19/2021ACCAQF1Q22PRODUCT Q – FL11871010/19/2021ACCAQF1Q22PRODUCT Q – FL12621012/23/2022ACCAQF1Q23PRODUCT Q – QN12631012/23/2022BBBAQF1Q23PRODUCT Q – QN56811010/12/2022BBBAQF1Q23PRODUCT Q – QN11391303/03/2013BBBAQF1Q23PRODUCT Q – QN43441302/24/2016BBBAQF1Q23PRODUCT Q – QN43451302/24/2016BBBAQF2Q37PRODUCT Q – KG52681303/16/2023DDDAQF2Q37PRODUCT Q – KG23341306/27/2013DDDAQF2Q37PRODUCT Q – KG23381306/27/2013DDDAQF2Q37PRODUCT Q – KG23391306/27/2013DDDAQF2Q37PRODUCT Q – KG23401306/27/2013DDDAQF2Q37PRODUCT Q – KG23411306/27/2013DDDAQF1B03PRODUCT AQ – FL23432606/27/2013EEEAQF1B03PRODUCT AQ – FL23502607/02/2013EEEAQF1B03PRODUCT AQ – FL23512607/02/2013EEEAQF1B03PRODUCT AQ – FL23522607/02/2013EEEAQF1B03PRODUCT AQ – FL23532607/02/2013EEEAQF1B03PRODUCT AQ – FL23542607/02/2013EEEAQF2F04PRODUCT AQ – TW23553707/02/2013AAAAQF2F04PRODUCT AQ – TW23563707/02/2013AAAAQF2F04PRODUCT AQ – TW23573707/02/2013AAAAQF2F04PRODUCT AQ – TW23583707/02/2013AAAAQF2F04PRODUCT AQ – TW23593707/02/2013AAAAQF2F04PRODUCT AQ – TW23603707/02/2013AAAAQF2F04PRODUCT AQ – TW23613707/02/2013AAAAQF2C22PRODUCT AQ – KG23922607/11/2013BBBAQF2C22PRODUCT AQ – KG23932607/11/2013BBBAQF2C22PRODUCT AQ – KG23942607/11/2013BBBAQF2C22PRODUCT AQ – KG23992607/11/2013BBBAQF2C22PRODUCT AQ – KG24012607/11/2013BBBAQF2C22PRODUCT AQ – KG24022607/11/2013BBBABC1T22PRODUCT T – KG24035007/11/2013ACCABC1T22PRODUCT T – KG24045007/11/2013ACCABC1T22PRODUCT T – KG24055007/11/2013ACCABC1T22PRODUCT T – KG24065007/11/2013ACCABC2T32PRODUCT T – QN24095507/11/2013ACCABC2T32PRODUCT T – QN24105507/11/2013ACCABC2T32PRODUCT T – QN24115507/11/2013ACCABC2T32PRODUCT T – QN24125507/11/2013ACCDEF1A03PRODUCT A – QN918185011/27/2023DDDDEF1A03PRODUCT A – QN918195011/27/2023DDDDEF1A03PRODUCT A – QN918205011/27/2023DDDDEF1A03PRODUCT A – QN918215011/27/2023DDDDEF4A04PRODUCT A – FL918226011/27/2023EEEDEF4A04PRODUCT A – FL918236011/27/2023EEEDEF4A04PRODUCT A – FL918246011/27/2023EEEDEF4A04PRODUCT A – FL918256011/27/2023EEEDEF4A04PRODUCT A – FL918266011/27/2023EEEDEF4A04PRODUCT A – FL918276011/27/2023EEEGHI1R01PRODUCT R – TW918287711/27/2023ACCGHI1R01PRODUCT R – TW918297711/27/2023ACCGHI1R01PRODUCT R – TW918307711/27/2023ACCGHI1R01PRODUCT R – TW918317711/27/2023ACCGHI1R01PRODUCT R – TW918327711/27/2023ACCGHI3S03PRODUCT S – FL959051412/30/2023BBBGHI3S03PRODUCT S – FL959061412/30/2023BBBGHI3S03PRODUCT S – FL959071412/30/2023BBBGHI3S03PRODUCT S – FL959081412/30/2023BBBGHI3S03PRODUCT S – FL959091412/30/2023BBBGHI3S03PRODUCT S – FL959101412/30/2023BBBGHI3S03PRODUCT S – FL959111412/30/2023BBB      Read More

​