MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by George Grund on February 15, 2001 1:20 PM


I'm new to Excel so I hope somebody can help me.
I have a list of 10 names with a value which is a number between 1 and 20. I am trying to find the percentage of the numbers (names) that are within the number 10 (from 1 to 10). Is there a formula or a macro that I can use?

Thank you

Posted by Mark W. on February 15, 2001 1:37 PM

If your values are in column A, use: