LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
vsoler
 
Posts: n/a
Default Equivalence of two sets of data

My problem is as follows:

I have one set of integers and zeroes in A1:Z1 (26 cells)
Another set of integers and zeroes is in A2:Z2

I want to compare the first "n" numbers in A1:Z1 with the first "n"
numbers in A2:Z2; such "n" number is in A3 and may vary depending of
the scenario.

The first "n" integers in A1:Z1 contain no duplicates and no zeroes;
the first "n" integers in A2:Z2 may or may not have duplicates or
zeroes.

I need a formula that gives me "1" if the first "n" integers in A1:Z1
are exactly the same as the first "n" integers in A2:Z2, although they
may be in a different order; the formula would give zero in any other
case.

Can it be done by using one single formula?

Thank you for your help

 
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
multiple scatter graphes how to plot 3 sets of data for x y on th. frances Charts and Charting in Excel 3 May 2nd 23 11:42 AM
Inserting a new line in spreadsheet Rental Man Excel Discussion (Misc queries) 2 January 9th 06 04:55 PM
Question about graphing four sets of data RawlinsCross Charts and Charting in Excel 2 January 5th 06 12:36 AM
anyway to go with excel two sets of data rob Charts and Charting in Excel 2 September 15th 05 04:51 AM
Two data sets, one average SWeyer Charts and Charting in Excel 3 June 11th 05 04:07 PM


All times are GMT +1. The time now is 03:22 AM.

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"