Formula that lists out a unique value

**ChemistB** · 01-23-2015, 01:31 PM

Try in H4 copied down

=IF(AND(G4<> {"base",""}), G4, IF((COUNTIFS($C$4:$C$23,C4, $G$4:$G$23, "Base")+COUNTIFS($C$4:$C$23,C4, $G$4:$G$23, ""))=COUNTIF($C$4:$C$23, C4), IF(C3=C4,"","No WC"),""))

You didn't put anything in H16 and I think that should have "No WC" If not, explain.

**JasonNeedsHelp** · 01-23-2015, 01:37 PM

Originally Posted by ChemistB

Try in H4 copied down

=IF(AND(G4<> {"base",""}), G4, IF((COUNTIFS($C$4:$C$23,C4, $G$4:$G$23, "Base")+COUNTIFS($C$4:$C$23,C4, $G$4:$G$23, ""))=COUNTIF($C$4:$C$23, C4), IF(C3=C4,"","No WC"),""))

You didn't put anything in H16 and I think that should have "No WC" If not, explain.

Awesome! This works perfectly. H16 was my human error (hence why i love excel).

this is great "(AND(G2<> {"base",""})"

Just for my own reference what does the { and } do?