I have an Excel which has three column. First has name(which might repeat in the coming cells) ,second has condition and the third has color. I want to count the number of color for a particular condition against each name

Thanks
Bhaskar KP

If you have Access this is easier in Access. If not use the Microsoft Query addin under the Data menu.