liabilityquek
Member
Hi All
with regards to my attachment, I have 2 sets of invoice no data with their respective cost Centers; DGW file and ZAP file.
there are multiple duplicate invoices numbers as each invoices is mapped to their respective cost Centers for these two sets of data and I would like to do a check the cost Centers in the DGW file is correctly reflected from the ZAP file. I tried using the index and small formula and didn’t display the results I want.
please assist, much appreciated.
with regards to my attachment, I have 2 sets of invoice no data with their respective cost Centers; DGW file and ZAP file.
there are multiple duplicate invoices numbers as each invoices is mapped to their respective cost Centers for these two sets of data and I would like to do a check the cost Centers in the DGW file is correctly reflected from the ZAP file. I tried using the index and small formula and didn’t display the results I want.
please assist, much appreciated.