Results 1 to 2 of 2

How to get text from multiple work sheet to go on a summary page after calulating values

Threaded View

cher062 How to get text from multiple... 01-01-2014, 04:56 PM
Xx7 Re: How to get text from... 01-01-2014, 06:30 PM
  1. #1
    Registered User
    Join Date
    06-09-2013
    Location
    NH
    MS-Off Ver
    2010 and 2013
    Posts
    13

    Question How to get text from multiple work sheet to go on a summary page after calulating values

    Ok I don't know if this is the right place or if I have the right title but I hope I can describe this so you understand

    Total brain freeze here!!

    Below is the way the summary page for the scores looks after doing functions to fine the top scores and placing them in the grid from 8 other worksheets. What I need it to do now is to put the school and Name of student in the middle 2 columns based on the score. So who whoever has the 12.04 for example will take that school name and put it in column 2 and the students name and put it in column 3. As you can see there are 2 scores that tied so I need to get the school and student for those to fill in too.

    I'm trying to do this with a formula if possible


    Place.......School.......Name.......Score
    1...........................................12.04
    1...........................................12.04
    3...........................................12.00
    4...........................................11.04
    5...........................................11.03
    6...........................................11.00
    7...........................................10.40
    Last edited by cher062; 01-01-2014 at 05:01 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to pull values in multiple page work book
    By SMOKEYSWORLD in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-06-2013, 07:30 PM
  2. [SOLVED] Summary sheet - copy cell contents from multiple sheets to one summary sheet
    By jsmity in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 10:32 AM
  3. Find maximum values from multiple imported sheets into a summary sheet.
    By rageshprasad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-21-2012, 01:31 AM
  4. Replies: 20
    Last Post: 10-19-2012, 04:35 PM
  5. [SOLVED] Summary Sheet from Multiple Worksheets or Creating a Formula based on text
    By dsunter in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-20-2012, 11:12 AM

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