Results 1 to 8 of 8

Retrieving top-5 names

Threaded View

versuswhat Retrieving top-5 names 02-16-2015, 12:55 PM
GerryZucca Re: Retrieving top-5 names 02-16-2015, 01:06 PM
versuswhat Re: Retrieving top-5 names 02-16-2015, 01:40 PM
GerryZucca Re: Retrieving top-5 names 02-16-2015, 01:46 PM
versuswhat Re: Retrieving top-5 names 02-16-2015, 01:59 PM
GerryZucca Re: Retrieving top-5 names 02-16-2015, 02:02 PM
Special-K Re: Retrieving top-5 names 02-16-2015, 01:09 PM
versuswhat Re: Retrieving top-5 names 02-16-2015, 01:41 PM
  1. #1
    Registered User
    Join Date
    12-23-2013
    Location
    Hong Kong
    MS-Off Ver
    Excel 2007
    Posts
    4

    Retrieving top-5 names

    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!
    Attached Files Attached Files
    Last edited by versuswhat; 02-16-2015 at 02:01 PM. Reason: query solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Finding and Retrieving Numbers and Names from a Large Workbook
    By disfunctional in forum Excel General
    Replies: 4
    Last Post: 01-02-2015, 04:52 PM
  2. Excel macro for retrieving file names
    By Toadums in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-17-2008, 07:54 PM
  3. [SOLVED] Retrieving Values Saved in Names
    By Steve Drenker in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-03-2006, 11:55 PM
  4. [SOLVED] Retrieving Names of Worksheets
    By Brad Sumner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2005, 02:05 PM
  5. Retrieving Values Using Range Names as References
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-25-2005, 02:16 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1