Excel Formula Challenge #5
In this formula challenge, we need to find out the pattern starting row and column by using only Excel Native formulas and without any helper columns. lets get the fun started.
Download Sample File
FormulaChallenge5.xlsx (16 downloads)Leave a Reply
Want to join the discussion?Feel free to contribute!
For the row number, my formula is:
=SUMPRODUCT((ROW(C$7:K$25)-6)*
(C$7:K$25=M$7))
For the column number, my formula is:
=SUMPRODUCT((COLUMN(C$7:K$25)-2)*
(C$7:K$25=M$7))