View Single Post
  #3   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