Google Sheet Query Function - Combine 2 Steps together in Query

Question

Pl. refer the Sheet shared below - https://docs.google.com/spreadsheets/d/1r0_oHLTcT9tmTJPgKVgkGwGWhooBM8uluwmWcC92eOk/edit?usp=sharing

Rank for diff. factors is calculated in Rank Sheet in Table A. Rank!ColL calculates combine score (D+ G + J). PF Sheet Range - Z:AE have Step wise calculation and results expected.

1 - Objective is to get results of used Query(Rank!C8:L220,"Select C,L where D > F12 & L > 0.5 order by L desc",1) (ref. cell PF Sheet!AE17). Query is referencing RANK Sheet's Cols.

2 - Possibility of merging Combine Score calculation as base data in Query.

Do revert is more clarity is reqd.

please, share a minimal reproducible example stackoverflow.com/help/minimal-reproducible-example — Mike Steelson
– Mike Steelson, Commented Jun 16, 2022 at 15:10

Giselle Valladares · Accepted Answer · 2022-06-17 01:17:11Z

2

I reviewed the Sheet, and I can make some suggestions.

Since you are calling 2 columns with the Query, add 1 column to the right of AE, and that one will be the new AF.

After that, modify the formula from:

=query(Rank!C8:L220,"Select C,L where D > 0.25 & L > 0.5 order by L desc",1)

to:

=query(Rank!C8:L220,"Select C,L where D > 0.25 and L > 0.5 order by L desc",1)

The reason it was not working is the use of & instead of and as mentioned here.

To make reference to a specific Cell instead of a value. You can use "&F12&", Like this:

Reference

QUERY function

edited Jun 17, 2022 at 1:17

answered Jun 16, 2022 at 20:14

Giselle Valladares

2,2791 gold badge7 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Robin U Over a year ago

Thanks Giselle. How to put greater than (or less then ) condition referenced to a cell value....i.e. ?D > cell value of F12", in this case.

Giselle Valladares Over a year ago

I edited the answer with the change.

Collectives™ on Stack Overflow

Google Sheet Query Function - Combine 2 Steps together in Query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related