hi - I have a table that pulls up daily trading values for a bunch of stocks in Europe. I am trying to write a function that will retrieve the top-5 traded values and the corresponding name in a separate table on the same sheet i.e. the 5 largest values from column E and the corresponding names from column B. The original sheet pulls data from 2 other applications which need separate log-ins so I'm attaching a sample with this question.
Thanks in advance!
Bookmarks