0

I have a table like following

Market   Date1  Date2 Date3 Date4 Duplicate

1068     $1     $2    $3     $4   3

1630     $5     $6    $7     $3   4

 190     $9    $10    $11    $12  0

i want to get number of Markets having duplicate sales of different dates and also the location of that duplicate in Duplicate Column. Here i added a column Duplicate to store the duplicate date column number. For example 1068 and 1630 have $3 duplicate sales. 1068 has $3 in Date3 so a 3 should be placed in Duplicate Column similarly 4 goes in 1630 Duplicate column.

Daniel E.
  • 2,029
  • 3
  • 22
  • 28
Ahmed
  • 5
  • 3
  • 1
    normalize your data to 3 columns, `market, price, date` – Daniel E. May 29 '14 at 17:03
  • 1
    And what if a row has several duplicates? @DanielE.'s suggestion could help to eliminate that issue (in addition to being a more sensible design). – Andriy M May 29 '14 at 21:38

0 Answers0