if-statementgoogle-sheetsgoogle-sheets-formulagoogle-query-languagenested-if
Showing Top 5 Clients at a dashboard
I want to build a dashboard where I can select a year and a application and want to have the top 5 clients shown up.
I build a example Sheet ofr showing: https://docs.google.com/spreadsheets/d/13yk_SIsv52bZbskOkEzkz4f1aOMnb5yLDk2oo5BawXs/edit?usp=sharing
On the left side I have listed all top clients ob every year and per application. On the right side I have a little selection tool and I want in the yellow marked area the correct data from the left side.
Thanks for your help
Solution
use:
=INDEX(QUERY({""&A1:B\ C1:E};
"select Col3,Col4,Col5
where 3=3 "&
IF(I3="";;" and Col1 contains '"&I3&"'")&
IF(I4="";;" and Col2 contains '"&I4&"'")&
"order by Col5 desc
limit 5"; ))
- Unable to use IF statement in plpgsql
- Adding only some data labels and a total value at the top of my stacked bar chart
- Good C-coding style for multiple lines if conditions
- If statement to check if an array is not in another array
- Determining if a string contains a word
- How can I make a def function with my "if" statements?
- How to assign a variable in an IF condition, and then return it?
- Using or in if statement (Python)
- C# Creating a Square
- Return TRUE/FALSE column for checking if a set of columns contains a value/string
- Does Go have "if x in" construct similar to Python?
- Does if (myBool == true) differ computational wise to if(myBool)?
- Write a Basic Car rental program on java / problems
- Writing a "Chessboard" function in Python that prints out requested length of binary
- Will my program execute "else" even if it executed my "if"?
- Why Java does not see that Integers are equal?
- How to have the Xcode 3.1 compiler warn of assignment operator in an if statement?
- Nested if Statement good or bad?
- How to write if statement in .tmux.conf to set different options for different tmux versions?
- is not null Vs != null (Unity C#)
- VBA "does not equal" code not stepping through IF statement as expected
- Avoiding nested if else statement ladder in Python
- I want to take output from a function to use in a IF statement in another function
- What actually happens when we put conditions without [] (brackets) in if else block in a bash script?
- C++ The if statement is still true even when only one condition is met
- Fortran if statement errors
- How can I change certain values in a column based on multiple conditions, leaving others as they are if the conditions aren't met?
- If statements to process a specific numeric value of a variable always fall into the last if statement no matter the value of the variable
- If formula (the sum is less than 30 then roundup tp 30)
- In what conditions is one comparison for "if" and "if-else" at С as at assembly?