Minimum value in all items

[aganesan99]

Hi All,

I need to identify the minimum value in each items and also to select one if all the values are same in a item.

Any help appreciated.

Thanks
aganesan99

[zbor]

Use this, confirmed with ctrl+shift+enter (not just enter):

Please Login or Register  to view this content.

[aganesan99]

In which column do I need to apply this formula?

[zbor]

In C2 and pull down.
(I've edit it now to avoid potential wrong result).

[aganesan99]

Zbor,

It works. Thanks a lot!!!

aganesan99