Hello all,
I need help to count the following.
- col A --- col B
-- x ------ blank
-- x ------ blank
-- x ------ data
-- y ------ data
-- y ------ data
-- y ------ data
-- y ------ blank
-- z ------ data
-- z ------ blank
-- z ------ blank
-- z ------ blank
-- z ------ data
Can someone please supply me with the formula that will count the
amount of blanks and filled cells for each value in column A.
I need to create the following table
x blank = 2
x filled = 1
y blank =1
y filled =3
z blank =3
z filled = 2
Thank you for your help in advance.
--
greg7468
------------------------------------------------------------------------
greg7468's Profile:
http://www.excelforum.com/member.php...fo&userid=9031
View this thread:
http://www.excelforum.com/showthread...hreadid=382493