Forum Discussion
Excel help sorting.
Good afternoon, hope someone can help. so here goes. i have a spreadsheet that has 8 columns the first Column is a list of companies named and numbered starting in A6 down to A52. Then I have fou...
=FILTER(A6:I52,(G6:G52=K3)+(H6:H52=K3)+(I6:I52=K3))Maybe with this formula. Enter the filter criteria dynamically in cell K3.
That is exactly how I tried doing it. I made a list somewhere else on the sheet with all the account names on it and created a filter box just like you did. So I can click on the box it will show a drop down and I can choose the account I want. The one thing I can’t get done is for it to display every row with set account name. ☹️