• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Get Minimum Values Across The Columns

Kenshin

Member
Thank you so far this forum for helping me solve complex problems, but is not over yet, despaerate for helping again guys


thank you
 

Attachments

  • Minimum Cases.xlsx
    10.1 KB · Views: 9
Just me practicing.
= LET(
Hdr, INDEX(headings, {1,3,5} ),
Rates, INDEX(data, @k, {1,3,5} ),
Minimum, MIN(IF(ISNUMBER(Rates), Rates)),
XLOOKUP(Minimum, Rates, Hdr)
)
 
Back
Top