I'm using Excel 2016. I can easily do what I need to with a filter function, but that isn't available to me in 2016.
In column A, I have alphanumeric strings.
In column C, I have dates.
For each row, I would like to check and see if any other row both has a value EQUAL to the one in column A, and is also GREATER than the date in column C. It would be nice if the formula returned the number of results, but I'd be fine with a TRUE if there are any at all, and a FALSE if not.
I can post some sample data but I'm new here, not sure how to make the pretty snippets of spreadsheets I see... so sorry for the plain table. And thanks in advance for any help!
In column A, I have alphanumeric strings.
In column C, I have dates.
For each row, I would like to check and see if any other row both has a value EQUAL to the one in column A, and is also GREATER than the date in column C. It would be nice if the formula returned the number of results, but I'd be fine with a TRUE if there are any at all, and a FALSE if not.
I can post some sample data but I'm new here, not sure how to make the pretty snippets of spreadsheets I see... so sorry for the plain table. And thanks in advance for any help!
b10000999 | 6/6/2014 | 1/9/2018 |
b10001207 | 6/6/2014 | 4/20/2018 |
b10001335 | 6/6/2014 | 1/27/2018 |
b10001347 | 6/6/2014 | 11/29/2017 |
b10001384 | 6/6/2014 | 2/11/2017 |
b10001438 | 6/6/2014 | 11/7/2019 |
b10001463 | 6/6/2014 | 6/14/2018 |
b10001487 | 6/6/2014 | 6/9/2020 |
b10001487 | 6/6/2014 | 6/21/2019 |
b10001517 | 6/6/2014 | 6/29/2018 |
b10001542 | 6/6/2014 | 5/25/2018 |
b10001542 | 6/6/2014 | 6/8/2020 |
b10001840 | 6/6/2014 | 11/9/2019 |
b10001888 | 6/6/2014 | 6/8/2020 |
b10002133 | 6/6/2014 | 7/17/2019 |