This paper mainly from matrix elementary transformation' expression gives out a generalized inverse matrix that satisfies a condition, and calculates a generalized inverse matrix of given matrix A specifically with the array formula of Excel, and introduces briefly the application of the generalized inverse matrix in the aspect of linear equation group.