mareks1234 wrote:

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



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

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



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




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.