Forum Discussion
Formula that moves down a row when you move right a column
In columns C-G I have certain letters, and I want to see whether any letters in row 3 match those in rows 3-100, any in row 4 match those in 3-100 etc. I've sent up the following formula (this is fro...
In J4:
=SUMPRODUCT(COUNTIF($C3:$G3,INDEX($C$5:$G$100,COLUMN(J4)-COLUMN($J$4)+1,0)))
Change 100 if your range extends below row 100.
You can fill this to the right and down.