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
Join Our Premium Group
Because learning right is important
Leave a Reply
Want to join the discussion?Feel free to contribute!
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.
To find row nubmer
=SUMPRODUCT((ROW(rr)-6)*(rr=M7))
To find column number
=SUMPRODUCT((COLUMN(rr)-2)*(rr=M7))
Hi. what is the use of “-6” for rows and “-2” for columns?
It’s wrong you are also comparing 1st cell of pattern
We can use Rows and Column functions in this sheet
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))
It’s wrong dude you are only comparing 1st cell of pattern
What was required is the STARTING row and column number of the pattern.