Hi Excel Experts,

I need a favour to figure out the logic behind this. For example my
table has 3fields,

Field 1 = CategoryID
Field 2 = Category
Field 3 = Item

The data is inserted into this table as raw data like below

6726 Stationary Pen
6726 Stationary Pen
6726 Stationary Pencil
5627 Utensils Spoon
5627 Utensils Knife

Another worksheet will summarize these details with fixed information
as below
but it will count the occurence of the 1st and 3rd field.
Pen Pencil Spoon Knife
6726 Stationary 2 1
5627 Utensils 1 1

I think it can be done using Vlookup and countif but am not sure how it
will be arranged.

Thanks for the help in advance


--
exxon99
------------------------------------------------------------------------
exxon99's Profile: http://www.excelforum.com/member.php...o&userid=34962
View this thread: http://www.excelforum.com/showthread...hreadid=570233