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.
Answer: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:
andas mentioned here.
To make reference to a specific Cell instead of a value. You can use
"&F12&", Like this:
If you have better answer, please add a comment about this, thank you!