Hi there,

I am new to this group. Nice to meet everyone!


I wish to write a formula in excel to pull data according to the
following algorithm:

For each filled row in Column I] do
If row[Column I] = "Automation Done" Then
get the contents of row [Column E]
End
End