how to get minimum & maximum from the given list

[Shayeebur]

Hi,

Request you to please check and answer where I am making mistake as I am not getting the correct answer for the same. I tried but I am getting wrong answer using sumproduct. if there is other formula which I can use to get the answer then please let me know the same.

 

[Somendra Misra]

Hi,

See the file. Two alternate solution via array formulas.Cell H1 has name drop down.

Regards,

 

[Shayeebur]

Thanks a lot Somendra have a nice evening.