UPDATE: Forget this, just saw your data is in a different order, this wont work.
What does this produce?
in any cell type
=SUMPRODUCT(--(L6586:L7345=P6586:P7345))
It should be 760
If its not then your data is NOT the same.
UPDATE: Forget this, just saw your data is in a different order, this wont work.
What does this produce?
in any cell type
=SUMPRODUCT(--(L6586:L7345=P6586:P7345))
It should be 760
If its not then your data is NOT the same.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks