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.

ExcelFormualChallenge

Download Sample File

FormulaChallenge5.xlsx (28 downloads)

1 reply
  1. Robert H. Gascon
    Robert H. Gascon says:

    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))

    Reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *