Thread: [Solved] Countif with 2 criteria
View Single Post
 
Old 05-23-2011, 11:23 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
Hi,

Data validation in H2 would be:
Code:
=AND(COUNTIF($G$2:$G$19,$G2)=1,NOT(ISBLANK($G2)))
When you enter the validation formula, untick the "Ignore Blank" checkbox.
__________________
Colin

RAD Excel Blog
Reply With Quote