View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
mareks1234 mareks1234 is offline
external usenet poster
 
Posts: 5
Default comparison similar rows in Excel



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