I have a workbook with 120 rows
Each row has 6 columns, so 6 numeric values per row
I want to add a formula into cells (G1:L1) to sort the first row values into ascending order and then drag the formula down, rather than sorting each row manually.
Im unsure I need to highlight cells G1:L1 and then enter an array formula in the formula bar?
Each row has 6 columns, so 6 numeric values per row
I want to add a formula into cells (G1:L1) to sort the first row values into ascending order and then drag the formula down, rather than sorting each row manually.
Im unsure I need to highlight cells G1:L1 and then enter an array formula in the formula bar?