Finding the number of values in one range which are also in another range.
Posted by Graeme on May 28, 2001 8:24 PM
I am a relative newcomer to spreadsheets and I haven't found a way to do this yet. I have 3 columns of numbers (GHI) and I want a formula or formulas which tell me how many of these(in one row) are also in another range (either ABC - return number in J, or in ABCDEF - return number in K). (FIRST RANGE ) ( 2ND ) Results
A B C D E F G H I J K
1 2 3 4 5 6 7 5 1 1 2
Thanks in advance for any advice!