How do I write a FILTER formula that displays x,y coordinates based on a value from an adjacent cell?

[arthurz11]

How do I write the FILTER formula that will give me the results in cell range A9:B10?

 

[SunnyAlv]

like this ?

=FILTER(A2:B6,C2:C6>=1)

 

[arthurz11]

like this ?

=FILTER(A2:B6,C2:C6>=1)

View attachment 116165

Works great!! Thanks a million!

 

[arthurz11]

like this ?

=FILTER(A2:B6,C2:C6>=1)

View attachment 116165

I forgot to mentioned that when column C is all zeros it should display a blank. I get a ######. How should I revised the formula =FILTER(A2:B6,C2:C6>=1) so it displays nothing and not the ####?

 

[arthurz11]

Works great!! Thanks a million!

However, I forgot to mentioned that when column C is all zeros it should display a blank. I get a ######. How should I revised the formula =FILTER(A2:B6,C2:C6>=1) so it displays nothing and not the ####?

 

[SunnyAlv]

However, I forgot to mentioned that when column C is all zeros it should display a blank. I get a ######. How should I revised the formula =FILTER(A2:B6,C2:C6>=1) so it displays nothing and not the ####?

try with :

=FILTER(A2:B6,C2:C6>=1,"")

or

=IFERROR(FILTER(A2:B6,C2:C6>=1),"")

 

[arthurz11]

try with :

=FILTER(A2:B6,C2:C6>=1,"")

or

=IFERROR(FILTER(A2:B6,C2:C6>=1),"")

=FILTER(A2:B6,C2:C6>=1,"") I used this one. It worked just as great as your help. Thanks again!

 

[SunnyAlv]

No Problem Dude