Forum Discussion

RavikumarDS's avatar
RavikumarDS
Copper Contributor
Jun 02, 2020

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

Formulas and Functions

5 Replies

  • Lewis-H's avatar
    Lewis-H
    Iron Contributor
    Jun 02, 2020
    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.
    • RavikumarDS's avatar
      RavikumarDS
      Copper Contributor
      Jun 02, 2020

      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

      • saybhatt's avatar
        saybhatt
        Brass Contributor
        Jun 02, 2020

        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.

Resources