Results 1 to 1 of 1

Thread: Need help with alternative single formula

  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 2023
    Posts
    14

    Need help with alternative single formula

    Hello,

    I want to check each result of range is in U2:AH97 against whole combinations are finding within the range B6:O97...for that I have used formula SUMPRODUCT in P2 to down check result 1, and Q2 to down check result 2....

    I want to check multi results of range U2:AH97 against range combinations B6:O97 with single formula in column R (Max Match) as shown in the example workbook attached. Does it is possible?

    Please see sheet (Example MMULT-FORMULA) has single formula in the column I which checks multiple results of K:P against B:G...exactly I need single formula for (sheet Multi Check Formula In Col R) does it is possible?


    Regards,
    Moti
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width