Results 1 to 8 of 8

countif - issue (no duplicates)

Threaded View

  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