Write a accurate function

[hasankacd]

hi,

Can any one help me to write a accurate function to this.

I have an excel file that has 3 columns Description, Color and Size
I read the excel file and put it into a data table. Using that data table I want to count the number of colors and size for each description.

eg:

Description Color Size
aaa wht 5
aaa wht 6
aaa wht 7
aaa blu 5
bbb wht 5
bbb wht 6
bbb blu 5
bbb blu 6

I want to get the number of color count and number of size count for each description

i:e according to the above example the output should be
aaa -
color count 2 (wht,blu)
size count 3 (5,6,7)

bbb -
color count 2 (wht,blu)
size count 2 (5,6)