Repeated Number in a Colum

[felkis]

I'm trying to make something like this (I'm a noob on excel don't know if this is possible):
If beetween J33:J54 the number 4 repeats then show the number 3 on J55 but if it doesn't repeat show the lowest number on that column,
Also
if there's a number lower then 4 in j33:j54 even if 4 repeats show that number instead.

 

[Fluff]

How about

=LET(m,MIN(J3:J54),IF(m<4,m,IF(COUNTIFS(J3:J54,4)>1,3,m)))

 

[felkis]

How about

=LET(m,MIN(J3:J54),IF(m<4,m,IF(COUNTIFS(J3:J54,4)>1,3,m)))

Perfect thanks!

 

[Fluff]

You're welcome & thanks for the feedback.