How to check if the total for a repeated value matches in every instance

New Contributor


I have a list of IDs in one column, and their total books in another.  The IDs are in the column multiple times.  I am trying to find a way in excel to check if the total balance for one ID matches in every instance the ID is listed.

Any ideas on how I can accomplish this?

3 Replies
Thank you. This did not help me identify IDs whose values did not match.

@Gdis_Lebron You're welcome. But perhaps you can clarify what you really need.