Return a value to other cells based on the value in a different cell

[freynem]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Part Number & Line Number[/TD]
[TD]SAHLATE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]025403 1[/TD]
[TD]-4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]025403 1[/TD]
[TD]-3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]025403 1[/TD]
[TD]-1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]025403 2[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]025403 2[/TD]
[TD]-4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]025403 2[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]025403 3[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]025403 3[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]025403 3[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Hi there
I need some help please,
My first column contains a part numbers (3 sets).
The second column is quantity of days, days early is negative, and days late is all numbers >=0.
I need to return data in the third column that shows if one day is >=0 than all part numbers in that set are "LATE"

Thank you

 

[Joe4]

Welcome to the Board!

Let's say that your header is in row 1, so that your data is in the range A2:B10.
Then place this formula in cell C2 and copy down to C10:

=IF(COUNTIFS($A$2:$A$10,$A2,$B$2:$B$10,">0")>0,"LATE","")

 

[oldbrewer]

surely 0 means on time ?

 

[freynem]

Thank you, worked a treat!

 

[Joe4]

You are welcome!