Hi I would Like to count the number of simultaneous blanks in a Row
For eg: I have 3 columns A B C.
Now I want to know the instances of
a) 3 blanks together
b) cells having text value U and T (among value of U ,T and H)
Hi I would Like to count the number of simultaneous blanks in a Row
For eg: I have 3 columns A B C.
Now I want to know the instances of
a) 3 blanks together
b) cells having text value U and T (among value of U ,T and H)
=COUNTBLANK(A1:C1)=3a) 3 blanks together
copied down
Please elaborate further. Perhaps a sample worksheet with desired results...b) cells having text value U and T (among value of U ,T and H)
Life's a spreadsheet, Excel!
Say thanks, Click *
For b) I am getting false for every combination?
I will elaborate on the question further
3 Columns----Each cell can take values either U or T or H or remain Blank.
I want to count the number of instances where entire row is blank
number of instances where row has U in 1st column and T in 3rd column
hope that helps?
see if this helps:
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks