Hello again,
I need a slight adjustment to a formula. Currently when applied the formula allocates a PB notation when a time is <= to a previously recorded time. What I now need is for the formula to allocate a PB for a time that is < than a previous time and allocate a =PB for a time that is equal to a previously recorded time. I have tried variations on the formula but cannot get it to work.
{=IF(OR($B11={"REGION","OPEN"},$C11=0),"",REPT("PB",$C11<=MIN(IF(($B$10:$B10<>{"REGION","OPEN"})*(ISNUMBER($C$10:$C10)),$C$10:$C10))))}
I have used just one formula from the spreadsheet. If an attachment would better serve please let me know.
Any help appreciated.
Bolter
Bookmarks