Filer

[yoosuf)_(2020]

Hi, I have a table (table2) containing data across columns 1-14. I need to filter this table to only include rows where the data in column 3 matches the value in cell D1. Additionally, I only want to display columns 1, 2, 3,4,5,6 and 8 in the filtered results. Could you suggest how to develop the appropriate filter formula for this? Please consider that table2 is my data range. I have attached a working similar this question

 

[Logit]

Your Invoice Numbers do not match anything else oin the data table.

You'll need to restate your desired outcome and how you intend to reach that goal.

 

[AliGW]

If you have Excel 365, this does EXACTLY what you've asked for:

=CHOOSECOLS(FILTER(Table2,Table2[Invoice No]=D1),1,2,3,4,5,6,8)

Your Invoice Numbers do not match anything else oin the data table.

There are TWO matches.

 

[yoosuf)_(2020]

If you have Excel 365, this does EXACTLY what you've asked for:

=CHOOSECOLS(FILTER(Table2,Table2[Invoice No]=D1),1,2,3,4,5,6,8)



There are TWO matches.

Thank you , at the mean time I came up with this formula,
=FILTER(FILTER(Table2,Table2[Invoice No]=$D$1),{1,1,1,1,1,1,0,1,0,0,0,0,0,0,0,0})