Hi,
I am currently working on some excel workbooks and am struggling with how to proceed further. I have data that come in to excel, data that is in decimals and also in +ve and -ve format. This data is constantly changing. What i would like to do is select the column where the data input changes value from nagative to positive, find the row/s where the changes in value have happened, then go to a seperate column in the sheet but the same row and extract the value that lies in the other column and same row.
How can this be done ? Any online help or online tutor who can show me via web or conference facility would be grea.
Many Thanks
Razor
I am currently working on some excel workbooks and am struggling with how to proceed further. I have data that come in to excel, data that is in decimals and also in +ve and -ve format. This data is constantly changing. What i would like to do is select the column where the data input changes value from nagative to positive, find the row/s where the changes in value have happened, then go to a seperate column in the sheet but the same row and extract the value that lies in the other column and same row.
How can this be done ? Any online help or online tutor who can show me via web or conference facility would be grea.
Many Thanks
Razor