What formula to get the unique value with two criteria.

[felixpanganiban]

FRIENDS,

please help me to make the formula to get the unique value with two criteria.

see attached sample.

thanks.

[felixpanganiban]

Should be result true and false. Thanks.

[AliGW]

You will need to explain the logic behind your expected answers. Why is G7 TRUE and G12 FALSE?

Excel 2016 (Windows) 32 bit

	D	E	F	G
6	CRITERIA 1	CRITERIA 2		ANSWER SHOULD BE BELOW
7	abc	123		TRUE
8	cde	213		TRUE
9	cde	213		FALSE
10	fgh	542		TRUE
11	ijk	678		TRUE
12	abc	123		FALSE
13	fgh	542		FALSE

Sheet: Sheet1

[felixpanganiban]

mam,

thanks for your response.

false if double mentioned. i need one time only.

[Glenn Kennedy]

In G7, copied down:
=COUNTIFS($D$7:D7,D7,$E$7:E7,E7)=1

[felixpanganiban]

solved. thank you.

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.