comparison similar rows in Excel

  • Thread starter Thread starter mareks1234
  • Start date Start date
M

mareks1234

Hello,

How (with Excel) I could compare rows with equal contents ? For example:



row A: 1 1 1
row B: 1 0 0
row C: 1 1 1
row D: 1 0 0
row E: 0 0 0


attention: every value in row is in seperate column !



I'd like to create formula which for above exampel indicates: row A is equal
to row C, row B = row D. Row D in the above exampel hasn't similiar row.
In my work I have combination a few dozen rows and I must search out rows
with equal contents in columns. However purpose of my work is analogous to
above exampel. My work differ from the exampel number of the columns (in my
5, above - 3).

I'd like further develop above model, e.g.: to search for rows with
different of given column, in above exampel it will be:

row D: 1 0 0
row E: 0 0 0



Best regards
 
row A ???? - do u mean column A ? like this :

A..B..C..D..E
1..1..1..1..0
1..0..1..0..0
1..0..1..0..0
 
row A ???? - do u mean column A ? like this :
A..B..C..D..E
1..1..1..1..0
1..0..1..0..0
1..0..1..0..0
Click to expand...


Yes, every letter in seperate column, every value in seperate row. In above
example (for clear worksheet - on the assumption that letter A is in field
A1) - location of value in column A: 1 in field A2, 1 - in field A3, 1 -
A4; for letter B (B1): 1 in field B2, 0 in field B3, 0 in field B4 ......
and so on
 
mareks1234 said:
Yes, every letter in seperate column, every value in seperate row. In above
example (for clear worksheet - on the assumption that letter A is in field
A1) - location of value in column A: 1 in field A2, 1 - in field A3, 1 -
A4; for letter B (B1): 1 in field B2, 0 in field B3, 0 in field B4 ......
and so on
Click to expand...

Do the row have to remain in the same order or are you allowed to "sort"
them?
 
Do the row have to remain in the same order or are you allowed to "sort"
them?
Click to expand...


It is allowed to sort the row. Only column couldn't be mixed. Order is
important for the result. So:
row A: 1 1 1
row B: 1 0 0
row C: 1 1 1
row D: 1 0 0
row E: 0 0 0

could be sorted for example like this:

row A: 1 1 1
row C: 1 1 1
row B: 1 0 0
row D: 1 0 0
row E: 0 0 0

The row represent the item and the column - feature of this item
regards
 
mareks1234 said:
It is allowed to sort the row. Only column couldn't be mixed. Order is
important for the result. So:
row A: 1 1 1
row B: 1 0 0
row C: 1 1 1
row D: 1 0 0
row E: 0 0 0

could be sorted for example like this:

row A: 1 1 1
row C: 1 1 1
row B: 1 0 0
row D: 1 0 0
row E: 0 0 0

The row represent the item and the column - feature of this item
regards
Click to expand...

In that case the "like" rows are adjcent. you may then see them easily.
If you want you may use a helper cell to make them stand out more, by
flagging duplicates.
 
In that case the "like" rows are adjcent. you may then see them easily.
If you want you may use a helper cell to make them stand out more, by
flagging duplicates.
Click to expand...

What about my second question ?
"I'd like further develop above model, e.g.: to search for rows with
different of given column, in above exampel it will be:

row D: 1 0 0
row E: 0 0 0"
 
mareks1234 said:
What about my second question ?
"I'd like further develop above model, e.g.: to search for rows with
different of given column, in above exampel it will be:

row D: 1 0 0
row E: 0 0 0"
Click to expand...

That is only same for two column entries and the third is immaterial?
 
That is only same for two column entries and the third is immaterial?
Click to expand...

I don't understand ?? I'd like find the rows with only one different
concrete attribute (for 3 attribute)
 
mareks1234 said:
I don't understand ?? I'd like find the rows with only one different
concrete attribute (for 3 attribute)
Click to expand...

You have 3 columns/attribute. If two column must be the same then the 3
column is changing but sorting on the unchanging columns will group the
sets that are the same and the changed attribute will be randomly mixed
thru the set.
 
Back
Top