You can also use the count function...

=countif(,) will tell you how many times that value exists in the other list...

Posted By: wobbly, Jul 29, 17:39:56

Follow Ups

Sorry =countif(range of large list,cell to compare)
Posted By: wobbly, Jul 29, 17:41:29

Reply to Message

Written & Designed By Ben Graves 1999-2025