I have two lists that I want to compare to see if they match, but in one list the numbers are broken down into individual lots so I need to sum them first to make sure they match the other list which only shows the total amount.
Here's an example:
5 ABC 18 ABC 6 ABC 7 ABC 1 CDE 8 CDE 5 CDE 2 CDE
So I want to make sure that the sum of the ABC and CDE on the left matches the total amount of ABC and CDE on the right. I can do this using multiple columns, but I am trying for a more...elegant way (one nested formula).
Aucun commentaire:
Enregistrer un commentaire