LibreCalc: select from different sheets

asked 2015-10-12 18:54:51 +0200

PashaT gravatar image

updated 2015-10-14 11:55:57 +0200

Alex Kemp gravatar image

I have three sheets 1,2 and 3. There are three columns on sheet 2 and 3: name (A), surname (B), age(C). How can I select men whose age is >=30 from sheet 2 and 3, order them by age and show resule them on sheet 1 (also 3 columns)? I mean something like SELECT name,surname,age FROM sheet2,sheet3 WHERE age=>30 ORDER BY age and show result on sheet 1.

edit retag flag offensive close merge delete