Formula not working in Google Docs

[SteveNL86]

Dear reader,

I'm running into a weird issue with Google Docs. I'm using this formula:

=IFERROR(INDEX(Tickets!$AB$9:$AB$308;AGGREGATE(15;6;(ROW(Tickets!$AB$9:$AB$308)-ROW(Tickets!$AB$9)+1)/(ISNA(MATCH(Tickets!$AB$9:$AB$308;C$8:C8;0)))/(Tickets!$AB$9:$AB$309<>"No defined output.");1));"")

And its working great on my local pc. But I am also using this file in Google Docs/Sheets, and it won't show any results in Google Docs.
Does anyone know if there are some settings I need to change in order to get it working, or what could possibly be the issue?

Kind regards,
Steve

 

[jasonb75]

Google sheets doesn't support the AGGREGATE function. See if this alternative works.

=ARRAYFORMULA(IFERROR(INDEX(Tickets!$AB:$AB;SMALL(IFERROR(ROW(Tickets!$AB$9:$AB$308)/ISNA(MATCH(Tickets!$AB$9:$AB$308;C$8:C8;0))/(Tickets!$AB$9:$AB$309<>"No defined output.");1E+100);1));""))

 

[Fluff]

Google does not have an Aggregate function, which is why it doesn't work.
Whilst there are other ways to do it, I think you will have a problem finding a formula that works on both systems.

 

[SteveNL86]

Thank you Jasonb75, that does work in Google Docs, but not on my local machine. I guess you are right Fluff, I'll have to think of a different way to tackle this problem.

Thank you both for the help!

 

[Fluff]

If you had Office 365, then there wouldn't be a problem, but not with 2016.

 

[SteveNL86]

Oh right, well I guess it's time to upgrade then haha. Thanks for the tip!

 

[Fluff]

Another option would be to use Excel online, rather than Sheets.