@Markmzz
I'm curious about the modification. It's not any simpler and seems to return the same values.
Did you find an error in the formula I posted?
A small modification:
Code:=IF(A1="","",CEILING(MAX(A1-MIN(A:A),1)/((MAX(A:A)-MIN(A:A))/5),1))
Markmzz
=IF(A1="","",CEILING((A1-MIN(A:A)+1)/((MAX(A:A)-MIN(A:A)+2)/5),1))