+ Reply to Thread
Results 1 to 2 of 2

Multiple data requires ranking

  1. #1
    Registered User
    Join Date
    02-18-2014
    Location
    Leeds, England
    MS-Off Ver
    Excel 2003
    Posts
    1

    Post Multiple data requires ranking

    HI I work in Loss Prevention in Retail and i am trying to sort out some data.

    firstly the data requires poor performing stores from 3 regions to be ranked by their region as the worse performing in that region.

    the sample i provide is just 30 stores where i actually have 800 but keeping it simple for now.

    as you can see from the attached,

    the Performance tab has all the data flowing in to it from other document but the vlookups are removed.

    the bottom 10 tab you can see requires the stores to be ranked with the worse 10 per division.

    we need to judge the stores that are performing well in sales Column Q with the lowest % in Column s.

    if possible i'd like to also say the lowest in column T but not essential.

    would appreciate any help

    thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,847

    Re: Multiple data requires ranking

    How would you reach your desired result with pen and paper? Where do you want the results? Please calculate a couple manually, put them WHERE you want them in your sheet, and re-post the sheet.
    Glenn



+ 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. Ranking without zero & ranking on multiple factors
    By Navin Agrawal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-13-2014, 06:05 AM
  2. [SOLVED] Ranking data with multiple columns
    By johnrlalor in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-14-2014, 12:52 PM
  3. Ranking Data based on multiple variables...
    By jasonkbu in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-08-2013, 10:00 AM
  4. Replies: 14
    Last Post: 05-23-2012, 08:09 PM
  5. Ranking Data with multiple criteria
    By pauldtaylor2 in forum Excel General
    Replies: 6
    Last Post: 05-16-2011, 04:07 PM
  6. Ranking Data from Multiple Worksheets
    By lukela85 in forum Excel General
    Replies: 2
    Last Post: 09-29-2010, 11:02 AM
  7. application that requires multiple statements
    By chrish8 in forum Excel General
    Replies: 4
    Last Post: 02-01-2009, 11:19 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