Results 1 to 1 of 1

How do I find the 1st, 2nd, and third largest number when 2 numbers are the same

Threaded View

  1. #1
    Registered User
    Join Date
    02-07-2011
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    5
    I made a chart to track out of stocks by store. I need a formula that will give me the stores with the highest outs. Sometimes there are 2 stores with the same number. How can I get excel to give me the first store with the same number in one cell and the second store with the same number in a different cell? This is the last function I need to make my project complete.

    I have the LARGE function in one cell and an IF in the cell before it for the stores.

    Am I making sense? I feel like the village idiot......

    This is the spreadsheet that contains my data. I'm looking for the the functions to go in the top 2 stores and bottom 2 stores.

    sorry forgot the attachment...
    Attached Files Attached Files
    Last edited by davesexcel; 02-08-2011 at 06:55 AM. Reason: reset replies to zero

Thread Information

Users Browsing this Thread

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

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