non linear cell alignment calculations

**kents86** · 09-03-2009, 04:32 AM

Hello,

I run upon a problem in my work. I got a 2 columns of many sets of numbers. There ar 2 tipe numbers that must be identified - 0 or any other number [except negatives]

check attached file, it has a set of sample values and a column of result what I need. I need this automated because I have a large set of data.

In my opinion the priciple of automated calculation is to pick first value in column A that is >0 and also pick first value that is >0 in column B. Then calculation value(columnA) - value(columnB) = result. After that repeat with second value >0 in column A ..... and so on till there are no values in lets say colun A.

Any help would be apreciated,

Thanks

**DonkeyOte** · 09-03-2009, 05:53 AM

I'm still not really clear as to where you want your results... if you want them to appear in G2 onwards then:

Please Login or Register  to view this content.

If your datasets are large however the above will be hideously inefficient and you would be best served using helpers to remove the need for Array functions.