Thread
:
Comparing Lists
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Gary L Brown
external usenet poster
Posts: 219
Comparing Lists
Going back to Chip's site, check out
http://www.cpearson.com/excel/array.htm
where he shows how to count items using multiple criteria.
HTH,
--
Gary Brown
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.
"Constantly Amazed" wrote:
Hi
I have frequently used an array formula to compare to lists and to tag
entries that appear on both lists which I originally got from Chip Pearsons
site. The formula is =IF(COUUNTIF($A$1:$A$10,B1)0,"On Other List","").
However, I have now been asked to compare two lists and only tag entries
which match on two counts. For example instead of simply comparing if
identical invoice numbers occur in two lists tag entries where identical
invoice numbers occur and the value is identical in both cases.
Thanks
G
Reply With Quote
Gary L Brown
View Public Profile
Find all posts by Gary L Brown