How to use FILTER function to get the previous row data based on certain fixed conditions in google sheet?
Hi everyone,
I'm using the Filter function to get the Category based on 2 conditions below:
- The
Timein column A is greater than/equal toI3 - The
Numberin column E is smaller than/equal to theNumberinI4
Based on the 2 conditions above, it will return category I as the answer. However, I hope to get the Category before I which is Category H. Is there any ways to modified the Filter function so that the answer return will always be the previous category without changing the 2 conditions? First thing came out in my mind is something like =FILTER(...)-1, but it doesn't work that way.
Any help will be greatly appreciated!
Solution
try:
=INDIRECT(ADDRESS(MATCH(FILTER(B3:B19, E3:E19<=I4, A3:A19>=I3), B:B, 0)-1, 2))
- Call a function inside Flutter Widget
- How to use FILTER function to get the previous row data based on certain fixed conditions in google sheet?
- How can I invoke a scriptblock in the caller's context?
- Writing a "Chessboard" function in Python that prints out requested length of binary
- Receive print content of another class at execution time not after the end of the function
- PHP function to increment variable by 1 each time
- Is there a way to use a function which references an object that in turn references that function?
- "Variable" not accessed
- Create a formula from (very) long list
- Writing an independent routine to add a minimization constraint in solnl()
- General way to define JAX functions with non-differentiable arguments
- How do I get the function name inside a function in PHP?
- How to convert a string or char* input to a data type in C++
- Returning strings and floats in python functions
- How should I define 'static' subroutines in Perl?
- Javascript onclick function being called on page load
- What does apply_filters(...) actually do in WordPress?
- The test keeps coming back as failing for a method. Don't understand why
- A helper function for mysqli that dynamically binds params in prepared statement?
- Return value in a Bash function
- How to send an email with Python?
- Is there a way to provide named parameters in a function call in JavaScript?
- Unable to Add Value to a Function & Stop Request from executing (POSTMAN)
- Jquery Get ID using on method
- PyCharm warns local variable might be referenced
- How do I get data from one function to another
- How to only get random letters and not symbols
- Why must the variable used to hold getchar's return value be declared as int?
- How could I implement a function wrapper that supports both void and other types of return value?
- How to store std::complex operator as a variable (C++)