Results 1 to 12 of 12

Count Unique Text String

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Windows 11 with Excel 2013 & 2016
    Posts
    906

    Count Unique Text String

    I am seeking help on below mentioned formula.

    =IF($A4="","",SUMPRODUCT(--(Master!$C:$C="Dental"),--(Master!$K:$K>=AR6),--(Master!$K:$K<=AR5)))
    Details:

    1. I am counting a unique i.e. Dental in my master sheet in column C.
    2. Then it count the values greater or equal to 0:29 and less then or equal to 0:20


    But the issue is is it not counting the values which is equal to 0:29. what is the problem can any one help me please.
    Last edited by hecgroups; 11-17-2012 at 11:01 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1