Formula Help

		Microsoft Office Forums > Microsoft Excel > Excel
Formula Help

10-19-2017, 08:01 AM

Debaser

Windows 7 64bit Formula Help

Office 2010 32bit

Competent Performer

Join Date: Oct 2015

Location: UK

Posts: 221

AND(COUNTIFS($D$2:$D2,$D2)>1,COUNTIFS($E$2:$E2,$E2 )>1)
doesn't actually determine that the duplication happened on the same row for both columns.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with an IF Formula	Cbate	Excel	1	08-17-2017 07:29 AM
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula	innkeeper9	Excel	2	09-13-2016 08:59 PM
Help With a Formula	OTPM	Excel	3	05-26-2016 03:42 AM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM
Help with formula please.	AndrewSE	Excel	3	04-05-2011 08:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:51 PM.