View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default comparison similar rows in Excel



mareks1234 wrote:

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"



That is only same for two column entries and the third is immaterial?



I don't understand ?? I'd like find the rows with only one different
concrete attribute (for 3 attribute)



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.