Greg,
One way:
in C2 =if(isblank(B2),"Blank","Data")
copy down col C
Use a pivot table with ColA as rows, colC as columns, count of ColB as data.
HTH
"greg7468" wrote:
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