In excel Im trying to count Items not listed
An example of how I am trying to achieve this would be:
Item Name ---------- Listed Date
Example Item 1 ----- 12/12/12
Example Item 2 -----
Item 2 has not yet been listed. so when it's all said and done i would like to see how many items are not listed.
I have tried using the following formula to no avail.
=IF(A:A <> "",COUNTBLANK(B:B))
Is there any way I can get the count of items not yet listed?
02 Answers
How about
=COUNTA(A:A)-COUNTA(B:B)If column B is actually full of formulas which return a "", this won't work as COUNTA will include the cells with formulas. In which case use:
=COUNTA(A:A)-(COUNTA(B:B)-COUNTBLANK(B:B))Please try INDEX function:
Type the following formula in a blank cell and press Ctrl+Shift+Enter. Then fill the cells down.
=INDEX(A:A,SMALL(IF(B:B="",ROW(B:B),4^8),ROW(A1))&"")
