Page 2 of 2 FirstFirst 1 2
Results 11 to 12 of 12

Thread: If formula to extract data ignoring duplicates

  1. #11
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Change formula in P18 to:

    =IF(H18="","",LEFT(H18,5)+0)

    and in Q18:

    =IF(H18="","",RIGHT(H18,5)+0)

    I am not 100% sure what you are counting in the M2:M14 formulas?


  2. #12
    Thank you this was a great help!

    Quote Originally Posted by NBVC View Post
    Change formula in P18 to:

    =IF(H18="","",LEFT(H18,5)+0)

    and in Q18:

    =IF(H18="","",RIGHT(H18,5)+0)

    I am not 100% sure what you are counting in the M2:M14 formulas?

Page 2 of 2 FirstFirst 1 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •