Hi,
I have a large spreadsheet (a few hundred lines long).
Please reference the data set called "now". I need to calcuate the values shown in "need" as follows:
1) Search the values in Column "A" and focus on only those rows having the lowest value(s). In the example below, rows 4 and 7 are ignored, and corresponding column, B, C, D values are set to zero.
2) Of the remaining rows (3, 5 and 6 in this case), choose the highest value remaining in column B, C, D and set all other remaining values to zero.
Thanks.
3) Lastly, is there any way to do a macro for this. I need to apply this condition to parts of a spreadsheet...not always all of it.
I have a large spreadsheet (a few hundred lines long).
Please reference the data set called "now". I need to calcuate the values shown in "need" as follows:
1) Search the values in Column "A" and focus on only those rows having the lowest value(s). In the example below, rows 4 and 7 are ignored, and corresponding column, B, C, D values are set to zero.
2) Of the remaining rows (3, 5 and 6 in this case), choose the highest value remaining in column B, C, D and set all other remaining values to zero.
Thanks.
Book1 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
2 | Now | Now | Now | Now | Need | Need | Need | Need | |||
3 | 2 | 2 | 3 | 1 | 2 | 0 | 0 | 0 | |||
4 | 3 | 2 | 4 | 1 | 3 | 0 | 0 | 0 | |||
5 | 2 | 3 | 4 | 2 | 2 | 3 | 4 | 0 | |||
6 | 2 | 1 | 3 | 4 | 2 | 0 | 0 | 4 | |||
7 | 4 | 6 | 2 | 1 | 4 | 0 | 0 | 0 | |||
Sheet1 |
3) Lastly, is there any way to do a macro for this. I need to apply this condition to parts of a spreadsheet...not always all of it.