Hi,
Am having a brain fade. Am after a formula which returns the number (ie. count) of dates which are greater than a variable date , and where a unique identifier is met.
For example:
SHEET 1
A B
1 APPLE 10/10/2019
2 PEAR 10/05/2020
3 ORANGE 10/12/2019
SHEET 2
A B
1 APPLE 2/04/2020
2 APPLE 11/12/2019
3 PEAR 18/06/2020
4 PEAR 6/02/2020
5 PEAR 27/11/2019
6 PEAR 11/12/2019
7 ORANGE 1/10/2019
8 ORANGE 31/10/2019
9 ORANGE 9/01/2020
10 ORANGE 10/12/2019
I want to count the number of times a date shows in Sheet 2, which is greater or equal to the date in Sheet 1, where the fruit type matches. In this example, the return would be Apple - 2 ; Pear - 1 ; Orange - 3
In my sheets I have dates formatted as 'dates'.
Any help appreciated.
Thanks,
Shaun.
Am having a brain fade. Am after a formula which returns the number (ie. count) of dates which are greater than a variable date , and where a unique identifier is met.
For example:
SHEET 1
A B
1 APPLE 10/10/2019
2 PEAR 10/05/2020
3 ORANGE 10/12/2019
SHEET 2
A B
1 APPLE 2/04/2020
2 APPLE 11/12/2019
3 PEAR 18/06/2020
4 PEAR 6/02/2020
5 PEAR 27/11/2019
6 PEAR 11/12/2019
7 ORANGE 1/10/2019
8 ORANGE 31/10/2019
9 ORANGE 9/01/2020
10 ORANGE 10/12/2019
I want to count the number of times a date shows in Sheet 2, which is greater or equal to the date in Sheet 1, where the fruit type matches. In this example, the return would be Apple - 2 ; Pear - 1 ; Orange - 3
In my sheets I have dates formatted as 'dates'.
Any help appreciated.
Thanks,
Shaun.