What I have
In cell G3: =ADDRESS(2,MATCH($O$5,$A$1:$E$1,0),2)
Result - E$2
In cell H3: =ADDRESS(ROW(),MATCH($O$5,$A$1:$E$1,0),4)
Result - E3
What I want
If I manually create the ROWS formula I would use =ROWS(E$2:E3) in cell I3 where the range is clicked on with the mouse. This would result in a row count of "2" being returned.
How do I pass the text of cells G3 & H3 (preferably the formula within those cells) into the =ROWS() formula to give me the same row count of 2?
Bookmarks