Hi All,

I would like to compare two sets of Numeric Values: if their values differ
have their corresponding Numeric Label returned across a single row.

I have 4 columns of data spanning 60 rows. The columns of data work in pairs:

Column A Numeric Label "A17:A76"
Column B Numeric Values "B17:B76"

Column D Numeric Label "D17:D76"
Column E Numeric Values "E17:E76"

If a column "B" Numeric Label's value is (NOT equal) < to its corresponding
Numeric Label's value in column "E", then return the Numeric Label of that
Numeric Value.

The Numeric Values in columns "B" and "E" are in descending order. All
Numeric Labels should be returned across a single row.

Sample Data Layout:
Col "A" Col "B" Col "D" Col "E"
Labels Values Labels Values
10 8 15 6
20 4 8 4
15 3 11 3
11 2 4 2

Required Results:
Labels 11 and 15 from column "A" should be returned across a single row as
their numeric values differ - column "B" Value is NOT equal to their
corresponding Value in column "E".

Thanks
Sam

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200612/1