TB's Code Library
If it ain't tight, it ain't right!
Search
Wednesday, October 30, 2013
Count the # of unique items in a column, excluding blanks
Excel Formula to count the # of unique items in a column, excluding blanks
=SUMPRODUCT((B21:B1421<>"")*(1/COUNTIF(B21:B1421,B21:B1421 &"")))
Thursday, October 03, 2013
Excel "IF~OR~AND" Formula
Excel Formula to check if B1 or C1 or D1 contain a value of "1" AND if the E1 = "1". If TRUE, then A1 = "1", otherwise, A1 = "0".
Place the following formula in cell A1:
=IF(AND(OR($B$1=1,$C$1=1,$D$1=1),$E$1=1),1,0)
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)