Replace Lambda Function

[Jululian]

=SORT(UNIQUE(FILTER(FILTER(C4:C33,ISNUMBER(FIND(D433&E4:E33,TEXTJOIN(" ",,K4:K6&J4:J6)))),BYROW(FILTER(C4:C33,ISNUMBER(FIND(D433&E4:E33,TEXTJOIN(" ",,K4:K6&J4:J6)))),LAMBDA(r,SUMPRODUCT((FILTER(C4:C33,ISNUMBER(FIND(D433&E4:E33,TEXTJOIN(" ",,K4:K6&J4:J6))))=r)*1)=3)))))

[td width="194pt"]

Dear All​

[/td]​

[td]

I kindly request, if possible, to replace Lambda function with another Since some of our colleagues are not completely familiar with the Lambda function, I would appreciate it if you could replace it with another​

[/td]​

[td]

this formula pull data from a table if two criteria are met​

[/td]​

[td]

many thanks​

[/td]​

[td]

Formula in Cell G4​

[/td]​

 

[shamimarita]

Hello Jululian,

Here's the final solution using the working formula to extract the desired values based on two criteria:
Formula:
=SORT(UNIQUE(FILTER(C4:C33, ISNUMBER(MATCH(D433&E4:E33, K4:K6&J4:J6, 0)))))

Explanation:

• MATCH: Combines D433 and E4:E33 to evaluate both criteria, comparing them to K4:K6 and J4:J6.
• ISNUMBER: Identifies rows where matches are found.
• FILTER: Filters corresponding values in C4:C33 where both conditions are satisfied.
• UNIQUE and SORT: Eliminates duplicates and organizes the result in ascending order.

This formula effectively pulls all matching data based on the provided conditions.

 

[Jululian]

Hello Jululian,

Here's the final solution using the working formula to extract the desired values based on two criteria:
Formula:
=SORT(UNIQUE(FILTER(C4:C33, ISNUMBER(MATCH(D433&E4:E33, K4:K6&J4:J6, 0)))))
View attachment 1672
Explanation:

• MATCH: Combines D433 and E4:E33 to evaluate both criteria, comparing them to K4:K6 and J4:J6.
• ISNUMBER: Identifies rows where matches are found.
• FILTER: Filters corresponding values in C4:C33 where both conditions are satisfied.
• UNIQUE and SORT: Eliminates duplicates and organizes the result in ascending order.

This formula effectively pulls all matching data based on the provided conditions.

Dear Mrs. Shamima
Thank you very much for your effort and time
the formula which I provided was correct with its result
Each Rank type should have its Rank degree
and should have all three Rank types with their Rank degree
I apologize for any inconvenience I may have caused
Regards