I would like to verify whether client records grouped based on an unique identifier tallies with bank record.
For example, in the below screenshot, records highlighted green indicate “Bank” records and can be identified using “BK” term in the string. Whereas non highlighted records are client(customer) records.
In the example below, I would like to verify whether records grouped by KID tallies with their respective bank record. For example : Records grouped by A1 would result in 7 records. out of which 6 are client records and 1 bank record. When you sum the client record values(Column3), it tallies with the Bank record(green) which is 270.
Please note that records can be in any order. For example , record with KID = “A2” might be in between two records with KID = “A1”
Can you please help me with this on how it can be done?
Test1.xlsx (8.9 KB)