different value | same value to match | result in one cell |
05/Oct/2021 | 29/Apr/2022 | text |
29/Sep/2021 | 28/Sep/2021 | text1 |
10/Oct/2021 | 05/Oct/2021 | text2 |
29/Apr/2022 | 29/Mar/2022 | text3 |
13/Oct/2021 | ||
11/Oct/2021 | ||
15/Dec/2021 | ||
23/Aug/2022 |
How to match each row from `different value` with the date from 'same value to match'. If there is a match then in one cell to result text from column 3 'result in one cell'.
For eg. from column 1 date 05/oct/2021 and 29/apr/2022 match with column 2 'same value to match' and the result should be: 'text, text3'. I tried with index and match but show only the first result. Thanks.
Last edited by a moderator: