thanks, i figured out a way....long way but it works, i made 4 set for each entry.....
If("OCCASION 3" = "OCCASION 2", ' ', "OCCASION 3")
If(IsBlank("OCCASION 3"), "OCCASION 4", "OCCASION 3")
If("OCCASION 3" = "OCCASION 4", "OCCASION 3", "OCCASION 3")
If(IsBlank("OCCASION 3"), "OCCASION 4"...