danovkos
11-10-2009, 06:44 AM
hi all,
pls. i have table (2000r and 20 col). It contains data (type of W, R and blank).
This table represent status of names and in column are months. I want to know, when changed status of name to actual status and result add to column B.
I need into column B for each row in table return name from 1st row, where change character from W to R or from R to W or from blank to W or R or oposit. I want to return name (header jan-okt) of column where change character to other one.
The column C is basic value (actual status).
How can do this?
Here is sample.
Thank you for your help.
pls. i have table (2000r and 20 col). It contains data (type of W, R and blank).
This table represent status of names and in column are months. I want to know, when changed status of name to actual status and result add to column B.
I need into column B for each row in table return name from 1st row, where change character from W to R or from R to W or from blank to W or R or oposit. I want to return name (header jan-okt) of column where change character to other one.
The column C is basic value (actual status).
How can do this?
Here is sample.
Thank you for your help.