I am creating a summary table that is derived from a large table.
I am pulling data from this large table of data which contains numbers and has the potential to have the same number repeated. I am using LARGE to retrieve the top three numbers. I am using Vlookup to retrieve the header for each of these numbers. A problem arises when there is two occurences of the same number. The same heading is retrieved for both of these. I'm not particular that the headings be in alphabetical order, I just need both of the headings there.
Bookmarks