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

[freynem]

Part Number & Line Number	SAHLATE
025403 1	-4
025403 1	-3
025403 1	-1
025403 2	0
025403 2	-4
025403 2	1
025403 3	1
025403 3	2
025403 3	0

<tbody>
</tbody>

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!