Compare Value and Highlight which is not Most Common Value

Dear Experts,

In the attached File

Column A - Part Number, Column B – Description, Column C – Delivery Unit, Column D – Length, Column E – Width, Column F – Height, Column G – Gross Weight Respectively
The Part Numbers Repeats from Minimum 2 to Maximum “N” number of times with the different Parameter like Delivery Unit, Length Etc.,

Cell J1 to N1 I have Tolerance Limit for J2 to N2 Parameter respectively. I am looking for the formula in J3 to N68 like Keeping Part Number as a Reference, Suggested Formula has to Compare individual parameter like Deliver Unit, Length Etc., with + or – Tolerance limit, If the value falls under Tolerance lime it has to Result 1 if not the Result has to be Zero.

With that I could able to create my signal in Column P!

Note:

1. Though attached file contains 66 Rows of Data only, my live file contains more than 25000+ Rows of Data

2. Though attached file data sorted by Part Number, my live file doesn’t sort by any part number

Looking forward your valuable suggestion!

Thanks & Regards,
Rajeshkumar R

[FONT=Century Gothic]Dear Experts,

Could you please provide your suggestions to address by subjected Query!

Thanks & Regards,
Rajeshkumar R
[/FONT]

Dear Bo_Ry,

Thanks for your Quick Response, Your suggested formula works fine when there is a limited Number of Part Number with Know comparison value!

But, In my case as I stated in my original post, there are many Rows of Data where I would like to accomplish subjected Query. So, Please do suggest which take care of "Note" mentioned in Original Post!

Thanks & Regards,
Rajeshkumar R

Dear Bo_Ry,

I am trying to use =MEDIAN(IF(PN=E2,DU)) Array Function to get the closest value than then trying to compare with Data!

Thanks & Regards,
Rajeshkumar R