You would need to add a column to your database, to store the value of your 'mapping', and then use
a pivot table based on the mapped account numbers.

HTH,
Bernie
MS Excel MVP


"olujimisorinola" wrote in message
...
I have over 2000 account numbers, each with it's own account balance.
However, I need to map some of these accounts together such that their
balance is consolidated. e.g. If i have 5 accounts viz 111,222,333,444,555
each carrying a balance of 2. I need to map these five accounts under a
category called 666 such that I can generate report that shows the balance in
666 as 10. I use excel 2003