Hi.,
please find the table.
Here i want the following
1. search values of unique to be picked up from the range or from the column headers (search range J2:M32)
2. Corresponding table will have the unique headers.
3. the unique value in the cell of the search range matches to the column header the corresponding cell value has to be incremented by 10.
2. if the unique value in the next cell of the search range matches to the column header again the corresponding value has to be incremented by 10. like this all the cell value has to be checked. for the each cell value the corresponding cells in the corresponding column has to be incremented.
How to solve this?
please find the table.
Here i want the following
1. search values of unique to be picked up from the range or from the column headers (search range J2:M32)
2. Corresponding table will have the unique headers.
3. the unique value in the cell of the search range matches to the column header the corresponding cell value has to be incremented by 10.
2. if the unique value in the next cell of the search range matches to the column header again the corresponding value has to be incremented by 10. like this all the cell value has to be checked. for the each cell value the corresponding cells in the corresponding column has to be incremented.
How to solve this?
_top_ | _right_ | _bot_ | _left_ | 21091 SF - 0.8mm | 162sf - 1mm | 158SF - 2mm |
21091 SF - 0.8mm | 21091 SF - 0.8mm | 21091 SF - 0.8mm | 21091 SF - 0.8mm | 52 | 0 | 0 |
162sf - 1mm | 162sf - 1mm | 0 | 55 | 0 | ||
162sf - 1mm | 162sf - 1mm | 0 | 55 | 0 | ||
162sf - 1mm | 162sf - 1mm | 0 | 55 | 0 | ||
162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 0 | 10 | 50 |
162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 0 | 10 | 50 |
162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 0 | 10 | 50 |
162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 0 | 10 | 50 |
162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 0 | 10 | 50 |
162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 0 | 10 | 50 |
162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 0 | 10 | 50 |
162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 0 | 10 | 50 |
162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 0 | 10 | 50 |
162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 0 | 10 | 50 |
162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 0 | 10 | 50 |
162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 0 | 10 | 50 |
162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 0 | 10 | 50 |
162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 0 | 10 | 50 |
162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 162sf - 1mm | 0 | 10 | 50 |
158SF - 2mm | 158SF - 2mm | 158SF - 2mm | 158SF - 2mm | 0 | 0 | 2.636 |
158SF - 2mm | 158SF - 2mm | 158SF - 2mm | 158SF - 2mm | 0 | 0 | 2.036 |
0 | 50 | 0 | ||||
0 | 50 | 0 | ||||
21091 SF - 0.8mm | 21091 SF - 0.8mm | 21091 SF - 0.8mm | 21091 SF - 0.8mm | 53 | 0 | 0 |
21091 SF - 0.8mm | 21091 SF - 0.8mm | 21091 SF - 0.8mm | 21091 SF - 0.8mm | 52 | 0 | 0 |
21091 SF - 0.8mm | 21091 SF - 0.8mm | 21091 SF - 0.8mm | 21091 SF - 0.8mm | 54 | 0 | 0 |
158SF - 2mm | 21091 SF - 0.8mm | 21091 SF - 0.8mm | 21091 SF - 0.8mm | 2 | 0 | 1.4 |
21091 SF - 0.8mm | 21091 SF - 0.8mm | 158SF - 2mm | 21091 SF - 0.8mm | 51 | 0 | 0.8 |
21091 SF - 0.8mm | 21091 SF - 0.8mm | 21091 SF - 0.8mm | 21091 SF - 0.8mm | 51 | 0 | 0 |
21091 SF - 0.8mm | 21091 SF - 0.8mm | 21091 SF - 0.8mm | 21091 SF - 0.8mm | 51 | 0 | 0 |
21091 SF - 0.8mm | 21091 SF - 0.8mm | 21091 SF - 0.8mm | 21091 SF - 0.8mm | 53 | 0 | 0 |