Hi,

I have 4 columns (Campaigns, start date, end date, rev)

I need to pull all the campaigns where the start date is lower than today(), the end date is greater than today() and the revenue so far for the live campaigns.
How can I use the Index & Aggregate formula to retrieve all live campaigns? I have around 20k rows.

Thanks
EL