Hi all
I need to summarze data in this way:
I have a database with items and in Column A and their Category in Column B
plus dta in C
E.G
Item category Data
a X 5
b Z 1
c X 3
d X 6
I want it to look at the item and pick up the data in C and reclassify
according to another table where
Item category Data
a X 5
b X 1
c X 3
d Z 6
But summarised so I have totals for X and Z which would be 9 and 6 as
opposed to 14 and 1.
Needles to say that I have many more categories and much more data for this.
Does anyone know a way to do this bearing in mind that the data table is in
a different file to the table that contains the output and the equivalencies
(e.g d was X and now Z).
Any help would be appreciated. Thank you
Bookmarks