Populate Countif values (Offset) into Array and loop through it

Dear all,
I am working with data in attached file.


I am struggling hard to populate few values into array. below is what i am trying to achieve.

1) I am taking countifs values in column E:E
2) For each values, if CountIfs is >= 2, then i need its offset(0,3) values (Column D:D) to be populated into Dynamic array.
3) Later i will loop through this array if any Status has string "Updates on".

Could anyone help advise how can i achieve this.?

Thanks

Array x is the one you are looking for.

Please Login or Register  to view this content.