Compare Cells

[SalamanderSam14]

=IF(M7=(M5:M6),"",M7)

This formula looks at a description in Cell M7 compares it to other descriptions before it and returns a value if it cannot find a match. The only problem is the formula doesn't work it returns #value. Any help on this maybe a different formula, someone mentioned pivot tables but i dont know how these work so any other suggestions would be great

[amotto11]

yes, you could use a pivot table, but this formula should do what you would like:

=if(or(M7=M5,M7=M6),"",M7)

Hope this helps

[Steve0492]

Hello SalamanderSam,

Try this:

=IF(COUNTIF(M5:M6,M7)<>0,"",M7)

If you want to increasing your range, just change "M5:M6" to something larger.

Let me know if this works for you!

Steve

[SalamanderSam14]

Hello SalamanderSam,

Try this:

=IF(COUNTIF(M5:M6,M7)<>0,"",M7)

If you want to increasing your range, just change "M5:M6" to something larger.

Let me know if this works for you!

Steve

Thanks for both your comments, i have used Steve's Idea as i need to copy this formula down for a lot of cells and this seems the easiest to do.