+ Reply to Thread
Results 1 to 2 of 2

Formula to sort data from sheet 1 to sheet 3

  1. #1
    Forum Contributor
    Join Date
    02-11-2016
    Location
    tanzania
    MS-Off Ver
    2007
    Posts
    217

    Formula to sort data from sheet 1 to sheet 3

    Hi friends
    i hope you are doing well
    iím pasing through a big challenge of simplify may work here for a long time.
    I have a data in sheet 1 to sheet 3 and i have the sheet named male and another sheet named female.
    I need a formular to sort data from sheet 1 to sheet 3 by considering column i where by there is number(total marks) in each sheet. I need to get out the first 10 highest numbers with their names from all work sheets to be in sheet named female. In column d there is number 1 and 2. Number 1 stand for male and number 2 stand for female.
    I need also to get out the first 10 highest numbers with their names from all work sheets to be in sheet named male. In column d there is number 1 and 2. Number 1 stand for male and number 2 stand for female.
    Iím beg anyone who have an idea to help me. Thanks a lot
    see the attached file
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365
    Posts
    1,327

    Re: Formula to sort data from sheet 1 to sheet 3

    issa,

    Sorry for not answering sooner, but only just seen your thread!

    Rather than creating a single "Range" covering the three sheets and "ranking" that, attached uses a Macro to do what you want.

    Click the button on the sheet, and it filters the names and scores of the Males in each of the three worksheets, adds them to the next free row on the Male page, sorts the page into Score order, and deletes those from position 11 onwards.

    Then does the same for the Females.

    Hope this still helps you.


    Ochimus
    Last edited by Ochimus; 08-16-2020 at 08:53 PM.

+ 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. If/OR formula, criteria met on Sheet A, show data from Sheet B onto Sheet A
    By GerrardYNWA in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-07-2020, 07:57 PM
  2. [SOLVED] vba code to sort data in two sheets and copy and paste sort data in output sheet
    By UPA in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-03-2017, 05:13 AM
  3. [SOLVED] Sub CallMacro to copy data to dest sheet is deleting formula in destination sheet
    By 962371 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2017, 12:38 PM
  4. match/sort - lookup data from one sheet and link to other sheet -
    By javaidmr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2015, 10:04 AM
  5. Sort data on one sheet by a list on another sheet
    By derpygoat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-06-2014, 01:42 PM
  6. Replies: 1
    Last Post: 06-05-2013, 07:03 AM
  7. Replies: 0
    Last Post: 01-10-2013, 01:39 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