Hello!
I am able to get the lowest value in columns using =min() but I to return the header of the lowest value instead the value itself.
The following are my Headers:
A1 = Visual
B1 = Auditory
C1 = Kinesthetic
The following are the values:
A2= 2
B2 = 1.5
C2 = 3
instead of showing 1.5 in D2, The header "Auditory" should be returned.
This is my minimun function
Please Login or Register to view this content.
INDEX / MATCH will do the trick:
Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thank you very much sir!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You may also 'add reputation' to those who helped you. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks