Hello
I have the table below:
01/01/2020; a; 12
02/01/2020; b; 45
I want for a specific value in Col2 (i.e. a or b) and for Col1 dates that are larger than a specific date, to return a string aggregate of Col3.
This is basically a lookup but it uses both an equation (Col2=a) and a larger-or-equal equation (e.g. Col1 >= 03/01/2020). These criteria will return an array of Col3 values which I then want to aggregate them into a string separated by newline.
Any idea?
Thanks!
PS: I cannot use Tables due to working on someone else's workbook.
I have the table below:
01/01/2020; a; 12
02/01/2020; b; 45
I want for a specific value in Col2 (i.e. a or b) and for Col1 dates that are larger than a specific date, to return a string aggregate of Col3.
This is basically a lookup but it uses both an equation (Col2=a) and a larger-or-equal equation (e.g. Col1 >= 03/01/2020). These criteria will return an array of Col3 values which I then want to aggregate them into a string separated by newline.
Any idea?
Thanks!
PS: I cannot use Tables due to working on someone else's workbook.