Page 1 of 1
A5 fx query(studentlist, 'select B.C.G.L.M where I="8018" and Me* 8028",1) 분 А c D 1 33 out of 500 records year Degree 3
Posted: Sat May 14, 2022 7:30 pm
by answerhappygod
- 1 (19.23 KiB) Viewed 36 times
A5 fx query(studentlist, 'select B.C.G.L.M where I="8018" and Me* 8028",1) 분 А c D 1 33 out of 500 records year Degree 3 2 L-2nd 3 4 5 Result 6 "=query(studentlist,"select B.C.G.L.M where l="&D18" and M="&D2&™,1) forename surname postcode Degree Josh Chan YO30 6HM 58.0 L-2nd Christopher Knight YO28 1HR 58.0 L-2nd Pheobe Marshall YO35 5NU 50.0 L-2nd 7 8 -Explain the syntax of the formula highlighted above and what QUERY does.