After much scouring of the threads I have found nothing similar enough to this that I can steal from. I am trying to pull Space and Manifold ID from a chart on a separate sheet based on the date the manifolds were repaired on. The manifolds and space repeat a lot as there are multiple valves attached to manifolds. See below for example.
<tbody>
</tbody>I have gotten the array to function for filtering out the "unknown" lines and placing them in their own table. I cannot convert the array formula to handle dates older than (today()-720). Basically I want to create a list of all the manifolds by space that have at least one valve with a service date more than 2 years ago. Below is my formula as it stands right now. Cell D4 has the equation "=today()-720". Any assistance in how to change this formula would be much appreciated.
=INDEX(Inventory_Table, MATCH(0, COUNTIFS($H$3:$H3,Inventory_Table[SPACE], $I$3:$I3,Inventory_Table[MANIFOLD ID / EQUIP NO.])+IFERROR(NOT(SEARCH($D$4, Inventory_Table[REBUILD DATE])=1), 1)+0, 0), COLUMN(A2))
space1 | manifold1 | valve1 | 9/9/99 |
space1 | manifold1 | valve2 | 9/8/99 |
space2 | manifold1 | valve1 | 9/9/99 |
space2 | manifold1 | valve2 | unknown |
<tbody>
</tbody>
=INDEX(Inventory_Table, MATCH(0, COUNTIFS($H$3:$H3,Inventory_Table[SPACE], $I$3:$I3,Inventory_Table[MANIFOLD ID / EQUIP NO.])+IFERROR(NOT(SEARCH($D$4, Inventory_Table[REBUILD DATE])=1), 1)+0, 0), COLUMN(A2))