Forum Discussion
S Campbell
Feb 24, 2018Copper Contributor
EXCEL Formula
Stumped again...
I have three rows with 10 cells in each row with numbers in them.
I want formula to look at one cell (not in these rows) and see which row that same number is.
Depe...
Detlef_Lewin
Feb 24, 2018Silver Contributor
Hi,
=AGGREGATE(15,6,ROW(A1:J3)/((A1:J3=A6)),1)*10