Change the matrix into echelon variety utilizing the row/column functions. Then the number of non-zero rows in it would give the rank in the matrix. to stop the reference from changing if the method is copied down while the reference to C5 is relative BSR is perfect for knowledge gathering. https://schwabxchange.com