LARGE Worksheet function
Posted by Luke on January 28, 2002 12:20 AM
Hi I was wondering if you culd give me some advice on using the LARGE worksheet function. I am using it to find the top 15 values in a list. However it brings the same value up for different ranks e.g the same number for rank 3,4 and 5. However there are definately no equal values in my list. also when i encorporate the vlookup value the name returned for all three numbers is from the same row. ie. the value and name is appearing three times in my ranking. the data to which the large function is linked is live through the Bloomberg financial system but the same problem occurs even when i paste values. Any ideas? Much appreciated if you can help.