Forum Discussion
2013 doesn't have =filter() function. ANY alternate function?
I have Microsoft excel 365 in that filter function is available and i create a follow up sheet linked with database sheet where in database user will store data from the form. In database there is a ...
There is a way to abuse SUMPRODUCT to produce a SQL statement. There is a way to arrange an Excel sheet like an SQL table. My database has plants (across rows by name, each plant occupying multiple rows labelled by attributes like "Production") and associated data (across columns by Dates). When all data be called "DBase" and the column headers "Dates", then your can filter (query) the production data as follows:
1 =SUMPRODUCT((Plants="Apollo")*(Attribute="Production")*ROW(Plants))
to obtain the row number of the total production data for Apollo and
2 =SUMPRODUCT((31-12-2021<Dates)*(Dates<=31-12-2022)*INDEX(Dbase,rowAbove,0))
Hope this makes sense.