Results 1 to 8 of 8

countif - issue (no duplicates)

Threaded View

step_one countif - issue (no... 07-14-2011, 01:19 PM
NBVC Re: countif - issue (no... 07-14-2011, 02:09 PM
step_one Re: countif - issue (no... 07-14-2011, 04:54 PM
daddylonglegs Re: countif - issue (no... 07-14-2011, 05:04 PM
step_one Re: countif - issue (no... 07-14-2011, 05:15 PM
NBVC Re: countif - issue (no... 07-14-2011, 05:06 PM
step_one Re: countif - issue (no... 07-14-2011, 05:15 PM
NBVC Re: countif - issue (no... 07-14-2011, 09:03 PM
  1. #1
    Forum Contributor
    Join Date
    04-27-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    113

    countif - issue (no duplicates)

    Hello

    Can someone tell me what im doing wrong with this?

    =IF(ROWS($52:52)>COUNTIF(Data!$CX$12:$CX$75,Calculations!$E$51),"",INDEX(Data!$CW$12:$CW$75,SMALL(INDEX(ROW(Data!$CX$12:$CX$75)+(Data!$CX$12:$CX$75<>Calculations!$E$51)*10^10,0),ROWS($52:52))))

    there should be a total of 13 entries.

    so after 13 entries, the formula should give a zero result.....but this appears to not be happening, any ideas why?

    basically, this lets me not get any duplicate values from the list taht i have. thx you so much!
    Last edited by step_one; 07-14-2011 at 05:16 PM.

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