Forum Discussion
Solved
Selecting data from one table based on criteria
Hello experts, Hope you are well & happy new year! Can you help me with the below? I have a table of large data that requires selected information being pulled out into another table, bas...
Hello, I don´t know if this formula works.
Is doing the same as the formulas that you had but with just a dynamic array formula.
=SORT(FILTER(FILTER(Sheet2!A5:F20,COUNTIF(Example!H2,Sheet2!F5:F20)),{1,1,0,0,1,0}),3,1)
The new information is going to be sorted by the date, so the comments are not going to change.
Attached is the excel file.
Hello, I don´t know if this formula works.
Is doing the same as the formulas that you had but with just a dynamic array formula.
=SORT(FILTER(FILTER(Sheet2!A5:F20,COUNTIF(Example!H2,Sheet2!F5:F20)),{1,1,0,0,1,0}),3,1)
The new information is going to be sorted by the date, so the comments are not going to change.
Attached is the excel file.