+ Reply to Thread
Results 1 to 3 of 3

Validate if values associated with the same part number are in descending order

Hybrid View

  1. #1
    Registered User
    Join Date
    10-20-2011
    Location
    Boston, MA
    MS-Off Ver
    Excel 2003
    Posts
    5

    Validate if values associated with the same part number are in descending order

    Hello,
    I tried posting this question in General Excel, hoping that I could solve this with a formula--but I didn't have any luck. I will go an give my sincere thanks to the chap who tried to help me. I think I may need a VBA script, and I have only created simple VBA programs in the past.

    I have a data dump from another external database. It looks something like this:

    Part_ID Value
    101 1
    101 2
    101 3
    102 2
    102 1

    I have to verify that the values are in descending order for each part number and flag the rows that are not. So in the example above row 5 would be flagged.

    I have a dump of about 1000 rows of data.

    Any assistance would be greatly appreciated!
    Cheers!
    Forbes

  2. #2
    Registered User
    Join Date
    11-16-2013
    Location
    OK
    MS-Off Ver
    Excel 2013
    Posts
    33

    Re: Validate if values associated with the same part number are in descending order

    I think using Conditional Formatting would be your best option here.

    For this example, I'm going to assume this is a list that starts in cell A1 and runs down column A. Create a new conditional rule for the range of cells, and type the following into the rule:

    "=A2>A3"

    Then change the format to whatever kind of text formatting you want to highlight the error.

    Edit: Adding attachment as example.
    CondFormat.xlsx
    Last edited by emp1346; 06-03-2014 at 03:50 PM. Reason: Attachment

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,088

    Re: Validate if values associated with the same part number are in descending order

    Perhaps try, assuming data in columns A and B starting at row 1
    C2=(A2&B2)*1
    D3 =C3>C2
    copy fomulas and paste down to the end of your data

+ 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. [SOLVED] Count number of instances and then display in descending order
    By gtudor in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-12-2013, 11:59 AM
  2. [SOLVED] Rank values in descending order with duplicates
    By mcain1981 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-14-2012, 01:15 PM
  3. Sorting in descending order and show duplicate values
    By cceze in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-19-2012, 09:33 AM
  4. Replies: 14
    Last Post: 04-17-2012, 05:18 PM
  5. count number of occurances in descending order
    By nazimscr in forum Excel General
    Replies: 2
    Last Post: 05-11-2011, 12:31 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