 SOLVED

# comparing data, and showing only the true ones

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

6 Replies

# Re: comparing data, and showing only the true ones

@Pedro_Ramalho Perhaps like this: File attached.

# Re: comparing data, and showing only the true ones

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))``

# Re: comparing data, and showing only the true ones

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.

best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: comparing data, and showing only the true ones

See new sample attached

# Re: comparing data, and showing only the true ones

Fantastic, thats exatly what i need.

THKS SM....