Results 1 to 2 of 2

HELP I need find to get an exact match. When it searches for "1" it counts 11, 21, 1 etc

Threaded View

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    Flint, Mi
    MS-Off Ver
    Excel 2003
    Posts
    2

    HELP I need find to get an exact match. When it searches for "1" it counts 11, 21, 1 etc

    HELP I need find to get an exact match. When it searches for "1" it counts 11, 21, 1 etc

    here is my formula

    =IF(ISERROR(INDEX(APPROVED!$A$3:$A$1002,SMALL(IF(ISNUMBER((FIND(G$4,APPROVED!$D$3:$Q$1002))*(FIND($H$1,APPROVED!$C$3:$C$1002))),ROW($C$3:$C$1002)-MIN(ROW($C$3:$C$1002))+1,""),ROW(G1)))),"",INDEX(APPROVED!$A$3:$A$1002,SMALL(IF(ISNUMBER((FIND(G$4,APPROVED!$D$3:$Q$1002))*(FIND($H$1,APPROVED!$C$3:$C$1002))),ROW($C$3:$C$1002)-MIN(ROW($C$3:$C$1002))+1,""),ROW(G1))))
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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