+ Reply to Thread
Results 1 to 1 of 1

Deciding on 1st place 2nd place etc for a TOP 10 List

  1. #1
    Registered User
    Join Date
    10-02-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    3

    Deciding on 1st place 2nd place etc for a TOP 10 List

    I have a spreadsheet with the following details:

    Header:
    Column A: Team Name (name)
    Column B: FTF (number)
    Column C: Caches Placed (number)
    Column D: Max Found Day (number)
    Column E: Number of Days (number)
    Column F: Total Finds for Month (number)

    Row 3-103 I have details

    In Column H3-H12 I have the numbers 1-10

    I want formulas for the following columns in rows 3-12
    In Column I: I want the names that correspond with the numbers in Column J
    In Column J: I want a list from biggest to smallest of the most FTF (TOP 10) Bear in mind that we can have duplicate numbers
    In Column K: I want the names that correspond with the numbers in Column L
    In Column L: I want a list from biggest to smallest of the most Caches Placed (TOP 10) Bear in mind that we can have duplicate numbers
    In Column M: I want the names that correspond with the numbers in Column N
    In Column N: I want a list from biggest to smallest of the most Max Found Day (TOP 10) Bear in mind that we can have duplicate numbers
    In Column O: I want the names that correspond with the numbers in Column M
    In Column P: I want a list from biggest to smallest of the most Total Finds for Month (TOP 10) Bear in mind that we can have duplicate numbers

    I have attached the spreadsheet if I have not explained myself properly
    Attached Files Attached Files

+ 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. list of individuals at same place, same time
    By erynne in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 06-15-2011, 03:46 PM
  2. Replies: 2
    Last Post: 06-24-2007, 10:16 AM
  3. Big sheet..neeed to jump from place to place
    By RHagerty in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-12-2007, 07:48 AM
  4. Filter list in place if a cell has a keyword within a formula
    By mcnaught@lincoln in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-22-2005, 10:05 PM
  5. [SOLVED] How can I place a condition on a list?
    By Cindy in forum Excel General
    Replies: 1
    Last Post: 08-05-2005, 05:05 PM

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