Hello everyone, 🙃 i would like to ask for help.

FILTER Function QUERY Function

1 year ago 3 Replies

PS

PS

Petr Svoboda 1 year ago

Hello everyone, 🙃
i would like to ask for help.A you can see on the pictur.
i have dropdown menu E3 and i want add to F3 all people from D:D
if i change E3 it will change F3
I hope that you undrstand a can you help me, please😊

0 Likes

Replies

RV

Ricardo Vicente 1 year ago

To show on column F all people on column D that have a Buddy ID that matches E3 you can use the filter function. On F3 try something like: =filter(D2:D, A2:A=E3)

1 Like

MT

Muhammad Tayyab 1 year ago

I can help you with that inbox me. Share your file

0 Likes

RG

Rudyard Gomez 1 year ago

Just try this.

=query({A2:D},"Select Col4 where Col1 matches '"&E3&"' order by Col4",0)

0 Likes

Relate Discussions

• I want to insert a formula here 27 Replies

• My problem is that I struggle with the formula when F14 is not up to F3 and F4. 2 Replies

• #solved Please Suggest a formula to have a count and sum? 6 Replies

• What formular do I use if I pick a name from a dropdown list to generate a list of employees? 8 Replies

• #Solved Special shoutout to sir Jojo Costillas! L Napaka sakalam mo tumulong all out! 4 Replies

• #solved Hello everyone i have a problem with if fonction , i dont know what im doing wrong , if anyone can help that will be great 12 Replies

• I have a formula in sheets to automatically change column E with the below formula, but some of the items are not working - any help? 6 Replies

• I want to make summary of bahawalnagar town using table in summary sheet on visited column (how to count visited and pending of specific town and show its value in summary sheet) i'have stuck file is attached herewith 17 Replies

• #solved Hello everyone i have a problem with if fonction , i dont know what im doing wrong , if anyone can help that will be great 3 Replies

• Hello friends, How can I apply a function in all column? 17 Replies