Hi Craig,

You'll probably end up with two of this reply, last time didn't seem to
work, but it will probably turn up eventually.

Anyhow, try this...

=IF(UPPER(AJ2)="N/A",AV2,IF(UPPER(AV2)="N/A",AJ2,IF(AND(ISNUMBER(AJ2),ISNUMBER(AV2)),MAX(AJ2 ,AV2),"")))

Let me know how it goes, I'll get it right eventually.

Did my comment about inputting dates make sense?

Just to satisfy my curiosity, where are you based?

Ken Johnson