I have a excel 2003 spreadsheet with a list containing order number, date,
status. I want to create a function to give a value in a new field for all
order numbers if one of the statuses is 'on hold'

My data would be like below
Order# Date Status
1 7/1/2005 Received
1 7/2/2005 Closed
2 7/1/2005 Received
2 7/2/2005 On Hold
2 7/5/2005 Closed

In the new field I would like all that lines for order 2 to have a "Yes"
value in the new field because one of the status was On Hold