### 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.

Because learning right is important

8 replies
1. 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.

2. Naresh says:

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

• Anil says:

Hi. what is the use of “-6” for rows and “-2” for columns?

• ROBIN REDHU says:

It’s wrong you are also comparing 1st cell of pattern

3. vishwakarmasameer10 says:

We can use Rows and Column functions in this sheet

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

• ROBIN REHDU says:

It’s wrong dude you are only comparing 1st cell of pattern