Hi,

I'm sure there's a fairly easy way to do this, but in looking through Excel 2007 help and around the web, I haven't discovered how.

What I have is a column which has 4-5 different values which repeat throughout the column. As an example in a column labeled "Completed Requests" I would have the following -
Brown
Smith
Brown
Johnson
Johnson
Brown
Gadly
Smith
etc.

I want to automatically calculate the percentage of completed requests by each name or value; e.g. if there's 38 entries in the column and a specific value shows up 7 times, I'd like the percentage automatically calculated in another summary cell.

Any assistance would be greatly appreciated, and please let me know if my explanation isn't clear.

Thanks.