• 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. H

    conditional format 2010 return the cell reference not value, if 2 cells same val

    Hi my name is Henk and I'm in Melbourne. I was wondering now that I have Office 2010 whether I can do a conditional format to compare a range of cells that have all different values in them to a row of 15 cells. Range being C14:G150 and Row being M4:X4. If a cell in the range is the same number...
  2. H

    compare two arrays a1:a7 compare to b1:b7, count how many are the same?

    a b 1 11 17 2 12 10 3 13 8 4 14 3 5 15 11 6 16 12 7 17 6 answer = 3, as both columns have 3 numbers the same 11,12,17 What is the formula someone please?
Back
Top