What function

Copper Contributor

Hi all, 


What I am trying to figure out is what function I can use to cross check that each tenant is paying the same amount across two sets of messy data. any help greatly apricated and please ignore the mess.




2 Replies


Your screenshot is not readable.

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.

Hi Hans, I posted a better explanation and picture in a new post on formulas and functions