finding matching records

  • Thread starter Thread starter Vass
  • Start date Start date
V

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 said:
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
:-(
 
Back
Top