![]() ISTEXT function returns a true for all the values that are text and false for other values. In this formula, we have used ISTEXT function. Here, ‘range’ represents the range that contains the values. = SUM( IF( ISTEXT(range),1 / COUNTIF(range, range), "")) This is again an array formula to count distinct values in a range. Method – 4: Using SUM and COUNTIF function
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |