Posted on 2014-03-13
I have a basic spreadsheet with 11 columns. In columns A-C there are 500 rows of numbers (0-50), one number per cell. In columns E-K row 2 is a single row of 6 numbers (again 0-5), again one per cell.
In column D I need a formula I can copy down, which compares numbers in columns A-C (rows 1-500) which checks for matches with the numbers in row 2 E-K.
So for example if
A2 = 13
And the data in rows E-K were
F2 = 19
G2 = 18
Then D2 should say "1", as there is 1 match.