finding matching records

[Vass]

i have a column (A) of names
these names have values in B and C
those in B may have several smaller values that reconcile to a single figure
in C (all belonging to the same name in A)
I need to find a way to highlight or report those that match off, and those
that are left unreconciled.

there are over 50,000 records so its not an easy manual task.

Any help appreciated thanks

 

[Vass]

i have a column (A) of names
these names have values in B and C
those in B may have several smaller values that reconcile to a single
figure in C (all belonging to the same name in A)
I need to find a way to highlight or report those that match off, and
those that are left unreconciled.

there are over 50,000 records so its not an easy manual task.

Any help appreciated thanks

Pivot groups the matching names meaning I cant gain acces to a single report
shoing all entries that make up the unreconciled items
:-(