alright, so...
1) Find all rows in sheet 'Base' where columns B and C match columns B and C in sheet 'summary'
2) Test if all columns F:BR for all of those found rows in sheet 'Base' are identical
3) If they are all identical return TRUE else FALSE
Based on that, there are 4 rows found for 00000 and 064 in sheet 'Base'. Those 4 rows do not have identical information in column F:BR so the result should be FALSE. I say they do not have identical information because:
The found rows are 4, 659, 1314, 1969
Row 4 has: column BA ">11" = 2.00%
Row 659 has: column BA ">11" = 2.00%
Row 1314 has: column AB "2-10" = 5.00%
Row 1969 has: column Z "2-6" = 5.00%
So not only are the populated columns different, but the values are also different.
Is that correct?
Bookmarks