I'm trying to cut down the number of variables I have for solver. I have a large group of cells that could all be changed, but have identified the ones that will actually need changed with a 1 as the value. How do I get the cell range(s) of just the cells with 1 in them?
Here is an example of what I have. The type of output in a separate cell is $A$1:$B$2;$F$1:$F$2;$E$3;$F$4;$A$5:$A$9;...etc.
<tbody>
</tbody>Any help is appreciated!
Here is an example of what I have. The type of output in a separate cell is $A$1:$B$2;$F$1:$F$2;$E$3;$F$4;$A$5:$A$9;...etc.
| A | B | C | D | E | F | |
| 1 | 1 | 1 | 1 | |||
| 2 | 1 | 1 | 1 | |||
| 3 | 1 | |||||
| 4 | 1 | |||||
| 5 | 1 | 1 | 1 | |||
| 6 | 1 | 1 | 1 | |||
| 7 | 1 | 1 | 1 | 1 | ||
| 8 | 1 | 1 | 1 | |||
| 9 | 1 |
<tbody>
</tbody>
