Feb 24 2022 03:09 AM
Hello.
This is an exemple:
I need compare two factors, If A4 = A2 and B4 = B2, if the result of two factors is true - true, show in another table, but only show the true results.
Can help me to solve this problem?
Thks
Feb 24 2022 03:22 AM
Feb 24 2022 03:47 AM
Not sure how you want in another table, but only show the true results...
in E4 (Excel 2021/365):
=FILTER(A4:C13, (A4:A13=A2) * (B4:B13=B2))
Feb 24 2022 06:50 AM
Thks @L z.
i will try explain.
I have this budget sheet:
Largura ( width ) x Altura ( height )
and i need check if cutting exist in another BD.
If exist, and we can have more than one with same width and height,
we put the results have the same width and height in the first sheet above the calculations.
Feb 24 2022 07:41 AM
SolutionFeb 24 2022 08:16 AM
Feb 24 2022 07:41 AM
Solution