Countif with 2 criteria

		Microsoft Office Forums > Microsoft Excel > Excel
Countif with 2 criteria

05-23-2011, 11:23 AM

Colin Legg Colin Legg is offline

Windows 7 32bit Countif with 2 criteria

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Criteria in Outlook Search	Nancy Grams	Outlook	0	11-12-2009 03:03 PM
Sort by criteria: number of results	p0k	Excel	1	10-22-2009 08:33 PM
How to count cells containing data and meet certain criteria	AdamNT	Excel	1	08-11-2006 11:51 PM
Multiple criteria in SUMIF?	pumpkin head	Excel	1	02-17-2006 09:06 AM
Filtering past or future events in DRW query criteria	jvieille	Misc	1	02-11-2006 06:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:42 PM.