NEED HELP WITH FORMULA TO SHOW DUPLICATE AND NEGATIVE AND PO

[YANECKC]

I HAVE SPREADSHEET WITH 9 COLUMNS.
IN COLUMN C (I HAVE ID CODES).
IN COLUMN E (I HAVE QUANTITIES).
IN COLUMN B (I OVERLAYED A FORMULA LOOKING FOR DUPTLICATE ID CODES. A TRUE WOULD APPEAR IF DUPLICATE ID CODES WERE IN COLUMN C. IF NONE A FALSE WOULD APPEAR. HERE IS THE FORMULA I INPUT IN COLUMN B
=COUNTIF($C$1:$C$3800,C2)>1
IT WORKS BOTH I WANT TO MODIFY THAT FORMULA TO SAY IF DUPLICATE ID CODE IN COLUMN C AND QUANTITIES IN COLUMN E ARE NEGATIVE TEXT WOULD APPEAR AS "DUPT NEGATIVES"
IF DUPLICATE ID CODE IN COLUMN C AND QUANTITIES IN COLUMN E ARE POSITIVE TEXT WOULD APPEAR AS "DUPT POSITIVES"
IF DUPLICATE ID CODE IN COLUMN C AND QUANTITIES IN COLUMN E ARE POSITIVES AND NEGATIVES TEXT WOULD APPEAR AS "DUPLICATE BOTH"
IF NO DUPLICATE ID CODE IN COLUMN C TEXT WOULD APPEAR AS "NO DUPLICATES"

THANK YOU FOR YOUR ANTICIPATED RESPONSE
YANECKC

 

[PaddyD]

Hi!

1) No need to shout! (Take the caps lock off)
2) No need to duplicate posts:
http://www.mrexcel.com/board/viewtopic.php?topic=24704&forum=2&3

Paddy