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.
Create a separate sheet for the comments and use VLOOKUP to display the comments in the filtered table. See the attached version,
Thanks for the quick reply.
Is there any other way round this? I didnt really want to start complicating by creating another sheet. The idea was to filter for this very reason or could have done it all on the master data sheet in the first place
Is there any other way round this? I didnt really want to start complicating by creating another sheet. The idea was to filter for this very reason or could have done it all on the master data sheet in the first place