Highlighted
New Contributor

# Filter Function formula

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

# Re: Filter Function formula

Hello @RavikumarDS

Highlighted

# Re: Filter Function formula

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

Highlighted

# Re: Filter Function formula

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

# Re: Filter Function formula

@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

# Re: Filter Function formula

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.