Formula to select the Lowest and Highest figures in a crow

[Pasadu]

Sir, Please help me with a formula to select the lowest and highest figures in a precise row.
My excel version is Professional Plus 2016.
Thank You.

 

[pecoflyer]

Try the MIN and MAX functions
Also get rid of merged cells, they are nothing but trouble

 

[GraH - Guido]

Since "GHS" is a format, you can do it by the position of the columns.
=MIN(IF(MOD(COLUMN(D7:M7);2)=0;D7:M7;""))
=MAX(IF(MOD(COLUMN(D7:M7);2)=0;D7:M7;""))



I believe you are on Excel 2016, so do confirm the formulae with CONTROL+SHIFT+ENTER.

EDIT:
or using the header line, it could be simply:
=MINIFS(D7:M7;$D$6:$M$6;"<>") // =MAXIFS(D7:M7;$D$6:$M$6;"<>")

 

[Pasadu]

Since "GHS" is a format, you can do it by the position of the columns.
=MIN(IF(MOD(COLUMN(D7:M7);2)=0;D7:M7;""))
=MAX(IF(MOD(COLUMN(D7:M7);2)=0;D7:M7;""))

View attachment 80699

I believe you are on Excel 2016, so do confirm the formulae with CONTROL+SHIFT+ENTER.

EDIT:
or using the header line, it could be simply:
=MINIFS(D7:M7;$D$6:$M$6;"<>") // =MAXIFS(D7:M7;$D$6:$M$6;"<>")

Thank you very much sir

 

[bosco_yip]

Another formula option

=MIN(N(OFFSET(C7,,{1,3,5,7,9})))

=MAX(N(OFFSET(C7,,{1,3,5,7,9})))

 

[Pasadu]

Another formula option

=MIN(N(OFFSET(C7,,{1,3,5,7,9})))

=MAX(N(OFFSET(C7,,{1,3,5,7,9})))

Thank you sir