CODEWITHSUNDEEP
excelopenoffice.orgopenoffice-calcno-duplicates
user3198655
user3198655

Reputation: 9

how to check a row for duplicate ones?

I have a openoffice calculator where I have some transactions... there are 3 columns that I need to compare as one... they can be repeated individually or in peer but never those 3 at the same time by other row... so I need some idea so I can check that there are no rows duplicated.... any idea :D ?????

Example:

columne1..columne2..Columne3....checkcolumne (just and idea)................................. ....111...........222...........333............ok.............................................................................................................111...........222...........444............ok............................................................................................................ 111 ......... 222 ......... 333 ...... Duplicate

there are more than 3 columnes of info, but there are 3 that i need to check

Upvotes: 0

Views: 79

Answers (2)

pnuts
pnuts

Reputation: 59485

To avoid failing to distinguish between 112 with 22 and 11 with 222 I'd suggest concatenating with a delimiter, say: 

=A1&"#"&B1&"#"&C1

and if to identify how many instances a formula such as =COUNTIF(D$1:D$6,D1) with both formulae copied down to suit and the 6 adjusted to suit. If to identify the first of pairs of entries this could be adjusted to =COUNTIF(D$1:D$6,D1)-1, with 0 ignored.

Upvotes: 1

user3216841
user3216841

Reputation: 1

Here's how I would to it in excel. Use =CONCATENATE(column1,2,3) and run a pivot table on it to count how many there are. Assuming you have access to excel.

Upvotes: 0

Related Questions