+ Reply to Thread
Results 1 to 3 of 3

Count how many string (left rows) that not match any cell reference

  1. #1
    Registered User
    Join Date
    10-14-2017
    Location
    Miami, Florida
    MS-Off Ver
    2016
    Posts
    83

    Count how many string (left rows) that not match any cell reference

    I need a formula To Count how many strings are before any reference located (PV2:PZ2)
    I tried to find the right formula but no luck

    Example :
    PU5:QR5 Have 0 match on First 5 string that not match any of the 5 reference (PV2:PZ2)
    PU7:QR7 Have 0 match on First 2 string that not match any of the 5 reference (PV2:PZ2)
    PU10:QR10 Have 0 match on First 9 string that not match any of the 5 reference (PV2:PZ2)


    Col_____PQ______________________pu_pv_pw_px_py_pz_qa_qb_qc_qd_qe_qf_qg_qi_qq_qr
    Row
    2____________________Reference-->___06_12_15_18_19

    5____0 on first 5____________ColNam_16_13_10_11_24_06_05_04_09_08_07_12_02_15_14

    7____0 on first 2____________ColNam_17_21_12_04_05_06_11_08_10_08_07_15_13_14_02

    10___0 on first 9____________ColNam_01_25_23_04_05_22_07_08_09_06_11_13_18_14_16


    Thank you so much
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Count how many string (left rows) that not match any cell reference

    Hey AndyJr,

    See if this formula works for you...
    =MIN(MATCH($PV$2:$PZ$2,PU4:QS4,0))-1
    in the attached...
    Min Match IfError.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    10-14-2017
    Location
    Miami, Florida
    MS-Off Ver
    2016
    Posts
    83

    Re: Count how many string (left rows) that not match any cell reference

    Thank you MarvinP

    Is funny because i tough it was suppost to be a big formula, (might be a nested formula)


    Thank you so much!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to use cell reference to match character string
    By shanteshmnnit in forum Excel General
    Replies: 6
    Last Post: 05-07-2015, 10:52 AM
  2. [SOLVED] Macro to match left string
    By tuneloon in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-17-2013, 11:32 AM
  3. [SOLVED] find word in string, count how many special characters are to its left
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2013, 06:46 PM
  4. [SOLVED] Count if - not exact match - from cell not string
    By s_twigge in forum Excel General
    Replies: 2
    Last Post: 06-27-2012, 10:44 AM
  5. [SOLVED] UDF to return string of values of all rows with cell matching reference cell
    By oemgacaesar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2012, 12:43 PM
  6. Replies: 2
    Last Post: 10-23-2010, 04:54 PM
  7. Count rows with a string in any cell
    By andy62 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-08-2006, 12:35 AM

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