Results 1 to 12 of 12

Count Unique Text String

Threaded View

hecgroups Count Unique Text String 11-17-2012, 10:50 AM
jeffreybrown Re: Formula issue 11-17-2012, 10:59 AM
Pete_UK Re: Count Unique Text String 11-17-2012, 11:01 AM
hecgroups Re: Count Unique Text String 11-17-2012, 11:02 AM
hecgroups Re: Count Unique Text String 11-17-2012, 11:12 AM
Pete_UK Re: Count Unique Text String 11-17-2012, 11:36 AM
hecgroups Re: Count Unique Text String 11-17-2012, 11:43 AM
Pete_UK Re: Count Unique Text String 11-17-2012, 11:59 AM
hecgroups Re: Count Unique Text String 11-17-2012, 12:02 PM
Pete_UK Re: Count Unique Text String 11-17-2012, 12:36 PM
hecgroups Re: Count Unique Text String 11-17-2012, 12:45 PM
Pete_UK Re: Count Unique Text String 11-17-2012, 12:50 PM
  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