SOLVED

comparing data, and showing only the true ones

%3CLINGO-SUB%20id%3D%22lingo-sub-3208846%22%20slang%3D%22en-US%22%3Ecomparing%20data%2C%20and%20showing%20only%20the%20true%20ones%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3208846%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%3CBR%20%2F%3EThis%20is%20an%20exemple%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Pedro_Ramalho_1-1645700463991.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F350971i3A01AFD3070E3EBE%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Pedro_Ramalho_1-1645700463991.png%22%20alt%3D%22Pedro_Ramalho_1-1645700463991.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20need%20compare%20two%20factors%2C%20If%20A4%20%3D%20A2%20and%20B4%20%3D%20B2%2C%20if%20the%20result%20of%20two%20factors%20is%20true%20-%20true%2C%20show%20in%20another%20table%2C%20but%20only%20show%20the%20true%20results.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Pedro_Ramalho_2-1645700802326.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F350975i3C6E8C68A34946B2%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Pedro_Ramalho_2-1645700802326.png%22%20alt%3D%22Pedro_Ramalho_2-1645700802326.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ECan%20help%20me%20to%20solve%20this%20problem%3F%3CBR%20%2F%3EThks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3208846%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3208907%22%20slang%3D%22en-US%22%3ERe%3A%20comparing%20data%2C%20and%20showing%20only%20the%20true%20ones%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3208907%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1316647%22%20target%3D%22_blank%22%3E%40Pedro_Ramalho%3C%2FA%3E%26nbsp%3BPerhaps%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Riny_van_Eekelen_0-1645701718211.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F350977i8214CE0F95581025%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Riny_van_Eekelen_0-1645701718211.png%22%20alt%3D%22Riny_van_Eekelen_0-1645701718211.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EFile%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3208987%22%20slang%3D%22en-US%22%3ERe%3A%20comparing%20data%2C%20and%20showing%20only%20the%20true%20ones%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3208987%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1316647%22%20target%3D%22_blank%22%3E%40Pedro_Ramalho%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20how%20you%20want%20%3CSPAN%3E%3CEM%3Ein%20another%20table%2C%20but%20only%20show%20the%20true%20results%3C%2FEM%3E...%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F350979i1289A3DBDCFA53E9%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screenshot.png%22%20alt%3D%22Screenshot.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3Ein%20%3CSTRONG%3EE4%3C%2FSTRONG%3E%20(Excel%202021%2F365)%3A%3C%2FSPAN%3E%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DFILTER(A4%3AC13%2C%20(A4%3AA13%3DA2)%20*%20(B4%3AB13%3DB2))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3209651%22%20slang%3D%22en-US%22%3ERe%3A%20comparing%20data%2C%20and%20showing%20only%20the%20true%20ones%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3209651%22%20slang%3D%22en-US%22%3E%3CP%3EThks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F75890%22%20target%3D%22_blank%22%3E%40L%20z.%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3Ei%20will%20try%20explain.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20this%20budget%20sheet%3A%26nbsp%3B%3CBR%20%2F%3ELargura%20(%20width%20)%20x%20Altura%20(%20height%20)%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Pedro_Ramalho_0-1645712249780.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F351010i03D964A28673F434%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Pedro_Ramalho_0-1645712249780.png%22%20alt%3D%22Pedro_Ramalho_0-1645712249780.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3Eand%20i%20need%20check%20if%20cutting%20exist%20in%20another%20BD.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Pedro_Ramalho_1-1645712373357.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F351011iEC75D48CD12CFB04%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Pedro_Ramalho_1-1645712373357.png%22%20alt%3D%22Pedro_Ramalho_1-1645712373357.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20exist%2C%20and%20we%20can%20have%20more%20than%20one%20with%20same%20width%20and%20height%2C%3CBR%20%2F%3Ewe%20put%20the%20results%20have%20the%20same%20width%20and%20height%20in%20the%20first%20sheet%20above%20the%20calculations.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello.
This is an exemple:

Pedro_Ramalho_1-1645700463991.png


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.

 

Pedro_Ramalho_2-1645700802326.png


Can help me to solve this problem?
Thks

 

6 Replies

@Pedro_Ramalho Perhaps like this:

Riny_van_Eekelen_0-1645701718211.png

File attached.

 

Hi @Pedro_Ramalho 

 

Not sure how you want in another table, but only show the true results... 

Screenshot.png

 

in E4 (Excel 2021/365):

=FILTER(A4:C13, (A4:A13=A2) * (B4:B13=B2))

 

 

Thks @L z. 


i will try explain.

I have this budget sheet: 
Largura ( width ) x Altura ( height )

Pedro_Ramalho_0-1645712249780.png

and i need check if cutting exist in another BD.

Pedro_Ramalho_1-1645712373357.png

 

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

@Pedro_Ramalho 

 

See new sample attached

Fantastic, thats exatly what i need.

THKS SM....
Glad I could help