Hi,
I am looking for a formula to set a priority number in F:F based on a job reference in EO3:EO512
The job reference may change in terms of entries as this may be constantly changing and there may be multiple different job references within the range EO3:EO512
ie
AB1234 1...