Forum Discussion
Copying a formula down doesn't yield results
Hi, I'm trying to recreate a formula from an excel template that a colleague uses (doesn't make sense to copy the entire template as I only need a few functions from it). I'm not copying and past...
Hi Erin,
Thank you for the screenshot, it's more clear now. In general your formula shall work, but only if you use it as array one (use Ctrl+Shift+Enter to enter the formula). Regular (non-array) formula equivalent could be
=AGGREGATE(15,6,1/(Tracker[Project Name]=[@[Project List]])/(Tracker[Start]>0)*Tracker[Start],1)
Both are in attached file.
That's fantastic, thank you so much!
Would the end formula be the same (obviously using End instead of Start) or would there be other changes? Trying to find the latest End date.
Erin, that's
=AGGREGATE(14,6,1/(Tracker[Project Name]=[@[Project List]])/(Tracker[End]>0)*Tracker[End],1)
, please check https://support.office.com/en-us/article/aggregate-function-43b9278e-6aa7-4f17-92b6-e19993fa26df
File is attached