Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same Contents, Regardless of Order
I need a Boolean function that, given two input arrays of equal size, will
return TRUE if the contents of the arrays are the same (apart from order), otherwise FALSE. For example, if array 1 contained: 1,2,3,4 and array 2 contained: 2,3,1,4 then the function should return TRUE If array 1 contained: 1,1,6,7 and array 2 contained: 7,1,6,2 then the function should return FALSE. -- Gary''s Student - gsnu2007xx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change series plotting order without changing legend order? | Charts and Charting in Excel | |||
How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
arrange contents of a table in Alphabetical order in excelsheet | Excel Worksheet Functions | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions | |||
Randomize the order of the contents of an array | Excel Programming |