+ Reply to Thread
Results 1 to 2 of 2

Reorder Values Based on Importance

  1. #1
    Forum Contributor
    Join Date
    12-09-2015
    Location
    Virginia, USA
    MS-Off Ver
    2007
    Posts
    121

    Reorder Values Based on Importance

    Is there a formula that I could use that will return a flag based on the values I dictate are most important? I am trying to draw attention to career days on a basketball spreadsheet. In the summary report I want to flag career points first, then career assists, followed by career rebounds then Season Points, Season Assists, Season Rebounds. Unfortunately, there is only enough space for one flag and the data population is random depending on which was done first. So the order of flags could be CP, SP, SA, CA, CR or it could be SR CR, CA, SP, CP, etc.

    If the order of flags was consistent I could just pull the left two or right two charachters first (that is what I did in my first attempt).

    The flagging data is located in column 11 of my vlookup. Values again can be listed with all flags, just one flag, or no flags in the following options and are only separated by a space (For example: "SA CA SP CP SR"). Using that example, how could I fish out Career Points "CP"?

    Here is the formula I was using:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Here is the idea of the formula I want:

    Vlookup the flag cell
    Find CP if True then "CP"
    Else Find CA if True then "CA"
    Else Find CR if True then "CR"
    Else Find SP if True then "SP"
    Else Find SA if True then "SA"
    Else Find SR if True then "SR"
    Else if Blank then ""

    But I don't know how to combine all that into one statement...


    Hope that makes sense.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Reorder Values Based on Importance

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced next to Quick Post button at the bottom right of the editor box.
    • Scroll down until you see "Manage Attachments",
    • Click the "Choose" button at the upper left (upload from your computer).
    • Select your file, click "open", click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Close the Attachment Manager window.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ensure to disable any Workbook Open/Autorun macros before attaching!
    Ben Van Johnson

+ 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. Reorder qty based on expiration dates
    By Medic1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-11-2015, 09:18 AM
  2. Sorting by importance
    By chuckwag0n in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-29-2013, 02:54 PM
  3. ReOrder Rows in ascending/descending order based on date
    By kurb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-05-2012, 05:42 PM
  4. Adjusted total based on importance of ranking score
    By Jared777 in forum Excel General
    Replies: 1
    Last Post: 07-28-2010, 08:39 PM
  5. Replies: 3
    Last Post: 06-16-2010, 04:23 PM
  6. How can I randomly reorder my values in my array?
    By shapper in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2008, 05:24 AM
  7. Values and Formulas - Problem - High Importance
    By Baapi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-29-2005, 07: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