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.
|