- 1 (19.23 KiB) Viewed 35 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
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
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
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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!