Display text with highest frequency in range

[JPM]

I have a range D2:D2500 with various names of clients. I am trying to figure out which one appears the most time.

I am able to figure out the occurrence of the repetition by using the function: =MODE(COUNTIF(D2:D2500,D2:D2500)) but I am unable to get the name to display.

Does anyone have any suggestions? A VBA solution would be preferred, but a function will work too.

Thanks

 

[eviljimmy]

Hit the Alt and F11 keys at the same time.
Activate the Insert | Module options from the menu.
Copy the code text and paste it in the empty pane on the right.
Acivate the File | Close and Return to Microsoft Excel options from the menu.

Now the formula with the V function will turn the desired results as advertised.

ok i got that far -
activate the file ?

i closed it and returened to excel
used the formula and ctrl+ shift+ enter - pop up box appeared with

-- removed inline image ---

 

[Aladin Akyurek]

ok i got that far -
activate the file ?

i closed it and returened to excel
used the formula and ctrl+ shift+ enter - pop up box appeared with

-- removed inline image ---

No images please. Are you on a Windows Excel system?

See: https://dl.dropboxusercontent.com/u/65698317/eviljimmy Public.xlsm

 

[eviljimmy]

No images please. Are you on a Windows Excel system?

See: https://dl.dropboxusercontent.com/u/65698317/eviljimmy Public.xlsm

Hi, sorry about the image.
basically error message i got was

box titled
Microsoft Visual Basic for applications
! Ambiguous name Detected: V

 

[Aladin Akyurek]

Hi, sorry about the image.
basically error message i got was

box titled
Microsoft Visual Basic for applications
! Ambiguous name Detected: V

You probably made a mistake with copying and pasting. Try to use the dropbox file if need be.

 

[assad269]

Cool.. Thanks everyone.. was helpful for me too..

But.. I want to display the top 5 with highest frequency in descending order.. Anyway I could do it..?

 

[Aladin Akyurek]

Cool.. Thanks everyone.. was helpful for me too..

But.. I want to display the top 5 with highest frequency in descending order.. Anyway I could do it..?

Would you post a convenient sample along with the desired results?