I want the name of highest number of days preset... In this 30 twice how to display the tw

[raji123]

Eg:
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?

[Lemice]

Hello,

First, I suggest you change the title of your thread, so that it will be easier for others to help you / find this post useful if they have similar question.
Second, here is a sample file.
Highest day preset.xlsx
You can change the data however you like.
Remember to drag the formula on D and E down until you see "blank" cell.

Hope this help.

[raji123]

Wow thanks a lot... it works.....