1. EJ42955

    Formula to change row number to value of different cell.

    If that isn't clear. I want this formula to change the Row reference $G$533, to the value in cell AK1. When I change the value in AK1, to 534, I want the formula to change the row 533 to 534. Automatically, on change, a macro button, whatever. =COUNTIF(DATA!$C$524:$G$533,AE2) Ideas? Thanks.

Some videos you may like

This Week's Hot Topics