Spreadsheet Formulas

css navigation by Css3Menu.com

Compare 2 Lists


Simply put, I made an array that says, if what is in A2 thru A20 equals A2, then evaluate what is in B2 thru B20 and the number 38 is there, then add 1 else zero.

A new twist came recently with:


Remember, to tell Excel that you are making an array, hold Ctrl+Shift while pressing Enter.

The new one looks at a city in A7 and if it is in B2 thru B622 of the Details sheet; then compare the Details sheet’s D column to the heading in H1. Add one if a match, else a zero.

© 2002-2024

Updated:  01/23/2024 13:34
This page added:  18 July 2002