Hi,
I need to pull a number of names where the dates in a corresponding column are greater than today.
E.g.
<tbody>
</tbody>
I know the following array formula:
=IF(ISERROR(INDEX($A$1:$B$10,SMALL(IF($B:$B=X,ROW($B:$B)),ROW(1:1)),1)),"",INDEX($A$1:$B$10,SMALL(IF($B:$B=X,ROW($B:$B)),ROW(1:1)),1))
However for some reason it does not appear to work with greater than (>) e.g.
=IF(ISERROR(INDEX($A$1:$B$10,SMALL(IF($B:$B>today(),ROW($B:$B)),ROW(1:1)),1)),"",INDEX($A$1:$B$10,SMALL(IF($B:$B>today(),ROW($B:$B)),ROW(1:1)),1))
Is anyone able to help with this?
Thanks.
I need to pull a number of names where the dates in a corresponding column are greater than today.
E.g.
Column A | Column B | |
1 | Name | Date |
2 | Tom | 5/4/17 |
3 | Mike | 30/6/18 |
4 | Jim | 3/3/16 |
5 | Peter | 8/1/17 |
6 | Steven | 9/11/13 |
7 | Melanie | 16/12/17 |
8 | Joe | 19/10/14 |
9 | Stephanie | 25/9/17 |
10 | Michelle | 29/2/15 |
<tbody>
</tbody>
I know the following array formula:
=IF(ISERROR(INDEX($A$1:$B$10,SMALL(IF($B:$B=X,ROW($B:$B)),ROW(1:1)),1)),"",INDEX($A$1:$B$10,SMALL(IF($B:$B=X,ROW($B:$B)),ROW(1:1)),1))
However for some reason it does not appear to work with greater than (>) e.g.
=IF(ISERROR(INDEX($A$1:$B$10,SMALL(IF($B:$B>today(),ROW($B:$B)),ROW(1:1)),1)),"",INDEX($A$1:$B$10,SMALL(IF($B:$B>today(),ROW($B:$B)),ROW(1:1)),1))
Is anyone able to help with this?
Thanks.