![]() ![]() Count Unique Values Excluding All Duplicates by Formula in Excel In above sample, we do count for unique values and get the result 6, because we have six products A\B\C\D\E\F, and if we want to only count the unique values exclude all duplicates like product A\B\C (they appeared more than one season) how can we do count? See below steps. We can check the result is 6, and the duplicates are not included. Step 2: Click Enter and get the result in E2. B1:B11 is the range you want to count the unique values. Step 1: In E2 which is saved the total product type number, enter the formula “ = SUMPRODUCT(1/ COUNTIF(B1:B11,B1:B11))”. Count Unique Values Excluding Duplicates by Formula in Excel If we just use sum formula to do count, then duplicates will be included, so we need another formula to do count excludes the duplicates. And we want to count the total product type in one year, how can we do count?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |