Results 1 to 15 of 15

Rank Excel File Identical Dollar Amount Issue

Threaded View

  1. #1
    Registered User
    Join Date
    05-03-2013
    Location
    Winchester, VA
    MS-Off Ver
    Excel 2003
    Posts
    9

    Rank Excel File Identical Dollar Amount Issue

    Good Evening Excel Users and Experts,

    Typically I'm pretty handy with most excel files, however i've hit a snafu which I haven't been able to resolve.

    I have all the formulas pulling for employee sales (all names are ficticious in this excel file for privacy) in a certain catagory successful from the data entry to the calculator tab, to the final results tabulation showing the rankings. However I uncovered a issue where if two or more employees sell the exact same dollar amount it does not pull and double rank the data as I would prefer it to. If anyone can point out a resolution to this more then likely easy to fix issue that I'm overlooking I'd be eternally grateful.

    Thanks in advance for any assistance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 09-14-2011, 06:23 PM
  2. index row, return dollar amount adding amount together
    By desk.doc in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-27-2007, 12:11 PM
  3. [SOLVED] Excel Function for max of percentage or dollar amount
    By Keeprogoal in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2006, 04:35 PM
  4. [SOLVED] How do I add the same dollar amount to all cells in excel?
    By CNewman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-09-2006, 09:50 PM
  5. Replies: 3
    Last Post: 08-22-2005, 01: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