NEED HELP WITH FORMULA TO SHOW DUPLICATE AND NEGATIVE AND PO

YANECKC

Board Regular
Joined
Jun 13, 2002
Messages
194
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
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,143,640
Messages
5,719,985
Members
422,256
Latest member
downeybm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top