Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
multiple scatter graphes how to plot 3 sets of data for x y on th. | Charts and Charting in Excel | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
Question about graphing four sets of data | Charts and Charting in Excel | |||
anyway to go with excel two sets of data | Charts and Charting in Excel | |||
Two data sets, one average | Charts and Charting in Excel |