Hi I have never really used excel for programming and im a little stuck.
My problem; I have a set of data in two columns, I need to search column B for values < -1 or >1 and then register the equivalent range of cells in column A that the condition was satisfied. I tried SUMIF and then I was going to try find an average using COUNTIF but that was no use.
It needs to be able to say conditions were met for A23:A45 and A67:A88 or something like that, better yet would be it outputting the values of the first and last cells of each range that the conditions were satisfied.
Thanks in advance for any help.
Paul
My problem; I have a set of data in two columns, I need to search column B for values < -1 or >1 and then register the equivalent range of cells in column A that the condition was satisfied. I tried SUMIF and then I was going to try find an average using COUNTIF but that was no use.
It needs to be able to say conditions were met for A23:A45 and A67:A88 or something like that, better yet would be it outputting the values of the first and last cells of each range that the conditions were satisfied.
Thanks in advance for any help.
Paul