Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining rows with similar data robertlewis Excel Discussion (Misc queries) 4 January 27th 07 06:19 PM
Aligning similar rows Nadeem Excel Worksheet Functions 3 October 18th 05 06:32 PM
similar vs. exact comparison dave in Toronto Excel Discussion (Misc queries) 1 August 31st 05 10:36 PM
How do I sort (or group?) a spreadsheet by similar rows? steve Excel Worksheet Functions 3 August 27th 05 06:33 PM
How can I delete similar rows in excel workbook with many sheets? JSchrader Excel Worksheet Functions 1 April 26th 05 06:40 PM


All times are GMT +1. The time now is 06:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"