Hi,
I've got this formula
=IF('Products and tests'!D5=Sheet1!A2,1,0)+OR(IF('Products and tests'!E5=Sheet1!A2,1,0))+OR(IF('Products and tests'!F5=Sheet1!A2,1,0))+OR(IF('Products and tests'!G5=Sheet1!A2,1,0))+OR(IF('Products and tests'!H5=Sheet1!A2,1,0))
It works fine but I want to apply it to multiple colums but all referencing the same colums just different rows.
I.E.
=IF('Products and tests'!D6=Sheet1!A2,1,0)+OR(IF('Products and tests'!E6=Sheet1!A2,1,0))+OR(IF('Products and tests'!F6=Sheet1!A2,1,0))+OR(IF('Products and tests'!G6=Sheet1!A2,1,0))+OR(IF('Products and tests'!H6=Sheet1!A2,1,0))
At the moment I'm changint the D6, E6 etc manually. Is there a faster way?
Thanks,
trio
Bookmarks