Filter Function formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1432706%22%20slang%3D%22en-US%22%3EFilter%20Function%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1432706%22%20slang%3D%22en-US%22%3E%3CP%3ETeam%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20know%2C%20whether%20I%20can%20use%20filter%20function%20and%20get%20only%20selected%20column%20in%20the%20results%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecurrently%20it%20is%20reproducing%20all%20the%20column%20in%20the%20original%20table%2C%20with%20filtered%20criteria%2C%20whereas%20I%20am%20looking%20for%20only%20selected%20column%2C%20with%20filtered%20criteria%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20it%20possible%2C%20or%20do%20we%20have%20any%20other%20work%20around%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20and%20Regards%3C%2FP%3E%3CP%3ERavikumar%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1432706%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433287%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20Function%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433287%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F686236%22%20target%3D%22_blank%22%3E%40RavikumarDS%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EPlease%20refer%20to%20below%20image%2C%20hope%20it%20solves%20your%20query%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22saybhatt_0-1591102725717.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195898i39CB8F4F73A0BF90%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22saybhatt_0-1591102725717.png%22%20alt%3D%22saybhatt_0-1591102725717.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433459%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20Function%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433459%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F686497%22%20target%3D%22_blank%22%3E%40saybhatt%3C%2FA%3E%26nbsp%3Bthank%20you%20for%20the%20command%2C%20will%20test%20and%20update%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433507%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20Function%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433507%22%20slang%3D%22en-US%22%3ETo%20filter%20data%20to%20include%20records%20between%20two%20dates%2C%20you%20can%20use%20the%20FILTER%20function%20with%20boolean%20logic.%20In%20the%20example%20shown%2C%20the%20formula%20in%20F8%20is%3A%20%3DFILTER(B5%3AD15%2C(C5%3AC15%26gt%3B%3DF5)*(C5%3AC15%26lt%3B%3DG5)%2C%22No%20data...%20To%20filter%20out%20rows%20with%20blank%20or%20empty%20cells%2C%20you%20can%20use%20the%20FILTER%20function%20with%20boolean%20logic.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433620%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20Function%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433620%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F686497%22%20target%3D%22_blank%22%3E%40saybhatt%3C%2FA%3E%26nbsp%3B%20thank%20you%2C%20your%20formula%20works%20for%20getting%20the%20results%20of%20one%20column%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20I%20am%20looking%20for%20multiple%20selected%20column%2C%20which%20is%20not%20in%20order%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20the%20data%20figure%20and%20expected%20resultant%20figure%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433907%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20Function%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433907%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%2F686236%22%20target%3D%22_blank%22%3E%40RavikumarDS%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3EAn%20easy%20solution%20can%20be%20using%20the%20filter%20formula%20twice%26nbsp%3B%3C%2FP%3E%3CP%3ELet's%20say%20you%20have%20the%20Account%20number%2055004%20in%20Cell%20L2%3C%2FP%3E%3CP%3EThen%20in%20M2%20you%20can%20put%20%3DFILTER(A2%3AB20%2CL2%3DC2%3AC20)%20and%20again%20you%20have%20in%20cell%20O2%20the%20formula%20%3DFILTER(H2%3AK20%2C%26nbsp%3BL2%3DC2%3AC20)%2C%20doing%20so%20will%20update%20the%20desired%20columns%20together%20as%20and%20when%20you%20change%20Cell%20L2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20assumed%20in%20the%20above%20example%20that%20the%20data%20in%20the%20image%20starts%20from%20A1%20and%20there%20are%20only%2020%20rows.%20You%20can%20change%20it%20accordingly.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Team

 

I need to know, whether I can use filter function and get only selected column in the results

 

currently it is reproducing all the column in the original table, with filtered criteria, whereas I am looking for only selected column, with filtered criteria

 

is it possible, or do we have any other work around

 

Thanks and Regards

Ravikumar

5 Replies
Highlighted

Hello @RavikumarDS 
Please refer to below image, hope it solves your query

saybhatt_0-1591102725717.png

 

Highlighted

@saybhatt thank you for the command, will test and update you

Highlighted
To filter data to include records between two dates, you can use the FILTER function with boolean logic. In the example shown, the formula in F8 is: =FILTER(B5:D15,(C5:C15>=F5)*(C5:C15<=G5),"No data... To filter out rows with blank or empty cells, you can use the FILTER function with boolean logic.
Highlighted

@saybhatt  thank you, your formula works for getting the results of one column

 

but I am looking for multiple selected column, which is not in order

 

I have attached the data figure and expected resultant figure

Highlighted

Hi @RavikumarDS ,

An easy solution can be using the filter formula twice 

Let's say you have the Account number 55004 in Cell L2

Then in M2 you can put =FILTER(A2:B20,L2=C2:C20) and again you have in cell O2 the formula =FILTER(H2:K20, L2=C2:C20), doing so will update the desired columns together as and when you change Cell L2

 

I have assumed in the above example that the data in the image starts from A1 and there are only 20 rows. You can change it accordingly.