Transform the matrix into echelon kind using the row/column functions. Then the number of non-zero rows in it might give the rank in the matrix. to avoid the reference from switching when the method is copied down though the reference to C5 is relative is often an array, but within https://schwabxchange.com