Results 1 to 2 of 2
  1. #1
    Join Date
    May 2014
    Posts
    1

    Unanswered: Help with counting? Two columns..

    Column A = Customer ID
    Coloumn B = Item ID

    I want to make Column C identifying if that row is a re-order (duplicate)

    Col A .. Col B .. Col C
    101 .. ItemA .. No
    103 .. ItemA .. No
    101 .. ItemA .. Yes
    102 .. ItemB .. No
    101 .. ItemB .. No
    102 .. ItemB .. Yes
    101 .. ItemA .. Yes

    I can't seem to figure out a formula I could put in col c to make it work

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    496
    Provided Answers: 24
    Not sure you can do this with a formula. You would probly need a macro to scan the list and mark C if it existed before.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •