+ Reply to Thread
Results 1 to 2 of 2

How to group different values in a column, then check if date is in sequence.

  1. #1
    Registered User
    Join Date
    04-05-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    88

    How to group different values in a column, then check if date is in sequence.

    Hello,

    I need help. In attached picture, I have data in 3 columns A,B,C. I need help finding a way to group same values in column B into batches, then filter them out. Then i need to see that the dates are in sequence for each of the batches, however the position of the dates must still be in order of POS in column A.

    In short, I need to find a way to to "filter" out the dates that are not in sequence for each of the different groups of ACC_ORG values in column B. I cant do it manually as there are almost 200,000 rows.

    sheet1.JPG

    I have been trying to solve it, already two days, but cant do it.

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: How to group different values in a column, then check if date is in sequence.

    Can you attach either a copy of the workbook or a smaller sample of it?

+ Reply to Thread

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