Comparing Lists
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 |
All times are GMT +1. The time now is 09:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com