Identifying duplicate numbers in same row in multiple columns--help!

Well this one has me stumped.

I have unit measures that are converted across four columns (FT, SQFT, SQM and SQY).

THere are three units in rows (BOX, Skid and Roll). I am trying to identify in a column labeled "Duplicate Volume" with a formula stating "YES" if there are duplicate numbers (volumes) in any of the four conversion columns listed above. I tried to attach an excel file here but the system will not accept it. Hopefully the diagram i make below will be enough to help you understand the concept working against me here. Thank you in advance for your help. Here is a quick look at the idea.

Unit Name FT SQFT SQM SQY Duplicate?

BOX 0 0 15 0
BOX 0 0 20 20 YES
Skid 0 10 10 10 YES
Skid 0 0 0 15
Roll 100 10 2 1.5
Roll 0 0 40 40 YES

I have over 50 thousand rows of this stuff...so looking at the data to decide if there are duplicates will not happen.

Gosh...im stuck like a bat in muck. Can anyone help me with a formula that i can put in the column titled "Duplicate" that can identify the duplicates with a "YES" in the cell where duplicates are found?

Thank you soo much!

Here i am trying to post a better diagram of the concept:

Unit Short Name Bill Quantity (Bill UOM) Bill Volume (FT) Bill Volume (SQFT) Bill Volume (SQM) Bill Volume (SQY) DUPLICATE VOLUME (YES)
Box 1.00 0.00 5.00 5.00 0.00 YES
Box 1.00 0.00 10.00 10.00 0.00 YES
Box 1.00 0.00 0.00 20.00 20.00 YES
Box 5.00 0.00 0.00 0.00 0.00
Box 5.00 0.00 0.00 21.20 0.00
Skid 10.00 0.00 42.40 42.40 0.00 YES
Skid 1.00 0.00 50.00 50.00 50.00
Skid 1.00 0.00 0.00 100.00 0.00
Roll 2.00 50.00 50.00 50.00 0.00 YES
Roll 2.00 0.00 100.00 100.00 0.00 YES
Roll 2.00 0.00 0.00 264.41 316.23

THanks Miraun....i am sorry i was unable to include an attachment. I am hoping you can help....thank.s

Hi Miraun...im trying it now.

i wish i had a spreadsheet...witht he formula in it ... Do you think you can upload the formula in an example spreadsheet so i can relate the cells to the formula? Im trying to figure it out as is in this state, but the spreadsheet would work....as im getting some erratic answers. thank.s