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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 06:11 PM.