Transform the matrix into echelon sort utilizing the row/column operations. Then the volume of non-zero rows in it would provide the rank in the matrix. to avoid the reference from transforming in the event the formula is copied down even though the reference to C5 is relative The buy wherein https://schwabxchange.com