Thread: SMALL function with multiple IF statements (or alternative suggestion)
View Single Post
 
Old 02-05-2018, 09:59 AM
garymon9AX garymon9AX is offline Windows 10 Office 2013
Novice
  
Join Date: Feb 2018
Posts: 9
garymon9AX is on a distinguished road
Default SMALL function with multiple IF statements (or alternative suggestion)
Ah yes sorry xor, I forgot to mention that.
There are some jobs with an 's' prefix which would also need to be ignored (as with the suffix hyphen and it's following numbers).
We need to match only the part of the job numbers after any 's' prefix and before the hyphen.
Thanks for your patience with the newbie

Regards,
garymon9AX
Reply With Quote