LinkBack URL
About LinkBacks
Hi Sir,
Can u please help me with this
Name nO.OF DAYS PRESET
ABCD 30
EFGH 30
IJKL 20
MNOP 22
I WANT THE NAME OF HIGHEST NUMBER OF DAYS PRESET... IN THIS 30 TWICE. HOW TO DISPLAY THE TWO NAMES?
Hi Sir,
Can u please help me with this
Name nO.OF DAYS PRESET
ABCD 30
EFGH 30
IJKL 20
MNOP 22
I WANT THE NAME OF HIGHEST NUMBER OF DAYS PRESET... IN THIS 30 TWICE. HOW TO DISPLAY THE TWO NAMES?
Hi,
Welcome to the Forum.
Assuming your sample data is in the range A2:B5, then try this Array Formula. Since this is an array formula so you need to confirm it with Ctrl+Shift+Enter instead of just Enter.
In D2
and copy down.
=IFERROR(INDEX($A$2:$A$5,SMALL(IF($B$2:$B$5=MAX($B$2:$B$5),ROW($A$2:$A$5)-ROW($A$2)+1),ROWS(D$2:D2))),"")
Is this what you are trying to achieve?
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Hi,
Thank you for your response.
I am able to access the abive Formula in Microsoft Excel however i need formula to use in Google Spreadsheet.
Can you please help me with that.
Regards.
Hemanishu
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks