ExcelBanter - Count number of values

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count number of values (https://www.excelbanter.com/excel-discussion-misc-queries/229416-count-number-values.html)

Count number of values

Hi
Is there a way to count total number of values based on the cell color? If
there are three different colors thru A1 -A50 and the names are color coded,
is there a way to count how many of each color names?
thanks

Gary''s Student

Count number of values

See:

http://www.cpearson.com/excel/colors.aspx
--
Gary''s Student - gsnu200850

"da" wrote:

Hi
Is there a way to count total number of values based on the cell color? If
there are three different colors thru A1 -A50 and the names are color coded,
is there a way to count how many of each color names?
thanks

Gary''s Student

Count number of values

See:
--
Gary''s Student - gsnu200850

"da" wrote:

Hi
Is there a way to count total number of values based on the cell color? If
there are three different colors thru A1 -A50 and the names are color coded,
is there a way to count how many of each color names?
thanks

All times are GMT +1. The time now is 08:39 AM.