1

I have one sheet with a list of phone extensions in which some have names associated with them and some do not. I am trying to use a function to display one the extensions with names onto another sheet, but I can't wrap my head around the correct formula. I've tried to use the isblank function or the len function, but it doesn't seem to work the way I want. If anyone has any advice on how to make this work without using dozens of if statements, I would appreciate the help.

Here is a link to a practice sheet I am using (Edited to a public sheet): https://docs.google.com/spreadsheets/d/e/2PACX-1vQz4seYTcXraVkjMI2FJrLu0xRfdTEc6Fef-OESWbKwuPw_HHu4gy4Dyzk_4HvVQQbXeW5Hjbhhf5KO/pubhtml

  • your sheet is private – user0 Apr 1 at 13:44
  • I fixed the sheet to make it public, sorry – Anil Banatwala Apr 1 at 13:53
0

=QUERY(Sheet1!A1:C, "where A is not null", 1)

0


=QUERY(Sheet1!A1:C, "select C where A is not null", 1)

0

  • Thank you, I have never used the query function, and I am glad to add it to my knowledge base. This function worked perfectly for my sheet. – Anil Banatwala Apr 1 at 18:58
0

=FILTER(Sheet1!A1:C, A1:A<>"")

0


=FILTER(Sheet1!C1:C, A1:A<>"")

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.