I get error when using the formula in a new sheet, but the same formula works in google`s example sheet.
What am i doing wrong?
1 Answers
your sheets are of different locale - English / Non-English
English sheets use , while in Non-English you need to use ;
therefore:
=QUERY(A1:B5; "select B"; 1)
Related