+ Reply to Thread
Results 1 to 2 of 2

Return minimum values from columns across multiple worksheets

  1. #1
    Registered User
    Join Date
    08-03-2014
    Location
    New York, New York
    MS-Off Ver
    2010
    Posts
    1

    Return minimum values from columns across multiple worksheets

    I have a large workbook in which each sheet contains data on securities held by a different investor; one column holds data on the discount to par at which this security is trading. I'd like to create a cover sheet which shows the fifty securities trading at the largest discounts to par across all of the investors, without needing to consolidate all of the securities into one sheet and sort. Ideas on how to do this? Thanks!

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Return minimum values from columns across multiple worksheets

    Please Login or Register  to view this content.
    That is a good way to go.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 03-14-2014, 06:46 PM
  2. [SOLVED] How to match data (ID value) in 2 columns in two worksheets, and return multiple values
    By awonghope in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-01-2013, 05:58 PM
  3. How to find minimum sum of row values across multiple columns
    By jaykrao999 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-01-2013, 07:08 AM
  4. Match Columns in 2 Worksheets, return only changed values of other columns
    By cheynooki in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-17-2011, 01:19 PM
  5. How to return multiple minimum values
    By jrocchio in forum Excel General
    Replies: 1
    Last Post: 10-20-2006, 05:27 PM

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