• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Match not working - help appreciated

    I have two lists of urls i want to compare - but match does not find the matches. Formula is =match(B2,$A$2:$A$4,0) = I only get n/a, although they are the same. I set the format of url fields to text - still not working. vlookup gives me numbers back, but totally wrong numbers Formula...
  2. A

    Need offset in Match / index function

    Thank you Nacky! I had to change it a bit, the row / offset did not work. so I ended up just with IF(L2>=2,SUM(N2,MATCH(J2,INDIRECT(CONCATENATE("$A",(N2+2),":$A$24")),0)),0) where N2 is based on the first match (looking for 2nd match to then index) Never encountered indirect before...
  3. A

    Data Extraction in Excel

    Cannot try right now, but how about import as text or text to column, and you define these two (BL:31 and M:B) as separators? First one of the two (BL:31) and you get two columns. then you do the same with the second column, this time using M:B as separator. Result should be in the middle...
  4. A

    Need offset in Match / index function

    I use index(match) functions to compare two lists. Now I want to use not always the same range for my this, but a shifting range: cell G1: match("andreas", B1:F10) = 4 now I want cell G2: match("Willi", B1+4:F10) =... So the second range is based on the first match.... with only one...
Back
Top