Forum Discussion
Solved
Array formula SUMIF no responding
Hello! I insert an array formula in cell x40 down to x47 (sets as general format) looking for a specific word from a table m38 to t57, in order from number12 down to 6. Columns M, O Q, and S are num...
Hi Analytic_JCPS,
You may trying using the below formula & it should work fine
=INDIRECT(ADDRESS( MAX(IF(LARGE($M$38:$T$57,$W41)=$M$38:$T$57,ROW($M$38:$M$57))),MAX(IF(LARGE($M$38:$T$57,$W41)=$M$38:$T$57,1+COLUMN($M$38:$T$38))),1,1),TRUE)Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more
Hi Analytic_JCPS,
You may trying using the below formula & it should work fine
=INDIRECT(ADDRESS(
MAX(IF(LARGE($M$38:$T$57,$W41)=$M$38:$T$57,ROW($M$38:$M$57))),MAX(IF(LARGE($M$38:$T$57,$W41)=$M$38:$T$57,1+COLUMN($M$38:$T$38))),1,1),TRUE)
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more
- Hi Shaikh!
Thank you.
I appreciate a lot your help. The formula just fit fine and ease!!
