ExcelLearner00
New Member
Is there a way to find out the row number of the cell that the information the formula finds?
I am using a Max formula and I need to know the row number that the answer was found in.
I have included my example I am looking to ultimately have in the Level of Counseling column populate the corresponding level in column B from Sheet1 populate here.
I am using a Max formula and I need to know the row number that the answer was found in.
I have included my example I am looking to ultimately have in the Level of Counseling column populate the corresponding level in column B from Sheet1 populate here.