The right formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2870363%22%20slang%3D%22en-US%22%3EThe%20right%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2870363%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Guys%20!%3C%2FP%3E%3CP%3EI%20looking%20for%20the%20right%20formula%20%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESheet%201%3C%2FP%3E%3CP%3E%3CSPAN%3EColumn%20A%20contains%20person%20names%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EColumn%20B%20contains%26nbsp%3Btheir%20age%20(many%20of%20the%20people%20are%20the%20same%20age)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EColumn%20C%20contains%20their%20adress%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ESheet%202%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3EOn%20this%20page%2C%20I%20want%20to%20have%20a%20list%20of%20the%20names%20of%20people%20and%20their%20addresses%20when%20they%20are%2012%20years%20old.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3ESo%20I%20want%20to%20have%20the%20informations%20on%20sheet%201%20of%20column%20A%20and%20C%20of%20all%20the%20people%20with%20''12''%20in%20column%20B.%2012%20is%20an%20example.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EI%20looked%20everywhere%20and%20I%20can%E2%80%99t%20find%20it.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EThanks%20!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2870363%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2870513%22%20slang%3D%22en-US%22%3ERe%3A%20The%20right%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2870513%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1192235%22%20target%3D%22_blank%22%3E%40Josianeb%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EIf%20I%20can%20recommend%20you%20read%20this%20link%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_self%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EIf%20you%E2%80%99re%20looking%20to%20ask%20a%20question%20or%20start%20a%20conversation%20about%20Excel%2C%20you%E2%80%99re%20in%20the%20right%20place!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EClick%20on%20the%20upper%20link%20fo%20rmore%20Informations.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2870655%22%20slang%3D%22en-US%22%3ERe%3A%20The%20right%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2870655%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1192235%22%20target%3D%22_blank%22%3E%40Josianeb%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20filter%20formula%20is%20available%20in%20your%20version%20of%20Excel%20i%20suggest%20formula%20below%20to%20dynamically%20filter%20datasets%20for%20a%20certain%20age%3A%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DFILTER('Sheet%201'!A2%3AC333%3B('Sheet%201'!B2%3AB333%3D%3C%2FSPAN%3E%3CSPAN%3EF4%3C%2FSPAN%3E%3CSPAN%3E))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EIn%20cell%20F4%20you%20can%20enter%20a%20certain%20age%20and%20the%20filter%20will%20update%20according%20to%20your%20choice.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIf%20you%20can't%20work%20with%20the%20filter%20formula%2C%20advanced%20filter%20would%20be%20my%20recommendation.%20I%20can%20work%20with%20advanced%20filter%20in%20Excel%202013.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello Guys !

I looking for the right formula ;

 

Sheet 1

Column A contains person names

Column B contains their age (many of the people are the same age)

Column C contains their adress

 

Sheet 2

On this page, I want to have a list of the names of people and their addresses when they are 12 years old. So I want to have the informations on sheet 1 of column A and C of all the people with ''12'' in column B. 12 is an example.

 

I looked everywhere and I can’t find it.

Thanks !

3 Replies

@Josianeb 

If I can recommend you read this link:

Welcome to your Excel discussion space!

If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!

Click on the upper link fo rmore Informations.

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

@Josianeb 

If filter formula is available in your version of Excel i suggest formula below to dynamically filter datasets for a certain age:

=FILTER('Sheet 1'!A2:C333,('Sheet 1'!B2:B333=F4))

In cell F4 you can enter a certain age and the filter will update according to your choice.

 

If you can't work with the filter formula, advanced filter would be my recommendation. I can work with advanced filter in Excel 2013.

Nice ! @Quadruple_Pawn 

Thank you so much !