Biffs formula works perfectly. Press F2 to edit the first formula, enter as
array (ctrl + Shift + Enter) and drag down

If this still does not work look at you original data is the job# exactly
the same on each row?

Regards

Peter

"smonsmo" wrote:

I cant seem to get this formula to work past the first row.
"smonsmo" wrote: