Forum Discussion
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, wh...
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
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.