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 (109 downloads)

Join Our Premium Group

Because learning right is important 

8 replies
  1. Vikash jha
    Vikash jha says:

    This is a great approach to the learner.
    I want to say only one thing if it is possible then create some challenges of Excel which not so hard but it should be joyful.
    Like assignments of Excel that will help to enhance their knowledge.
    I always wish about this type of platform where some Excel related question will come and we will solve them.
    I know about the WhatsApp group but there are lots of genius who are able to solve any question that group is best to my queries.
    It’s only a suggestion.

    Reply
  2. Naresh
    Naresh says:

    To find row nubmer
    =SUMPRODUCT((ROW(rr)-6)*(rr=M7))
    To find column number
    =SUMPRODUCT((COLUMN(rr)-2)*(rr=M7))

    Reply
  3. 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 *