Filter with multiple rows and columns in Google Sheet
I am working on attendance in a google sheet where I maintain hourly attendance. I record attendance for 5 hours everyday. In column B9:B40 I have a list of names. In Row F3:3 I have the dates. From F3:J3, 19-Jun-2024, from K3:O3, 20-Jun-2024 and so on. In F9:DZ I have marked 'A' for absent and 'P'. I am looking to filter the names with date and hours where 'A' is marked. I am also alright to enter a date manually and get the names with total number of hours and / or the hour number. I have uploaded an image for easy understanding.
Thank you for any help.
=FILTER(B9:B,F3:3=DATE(),F9:DZ="A")
Solution
use:
=INDEX(SPLIT(TOCOL(IF(F9:DZ40="A"; B9:B40&"×"&F3:DZ3&"×"&F4:DZ4; ); 1); "×"))
and format 2nd column as Date
- How to combine multiple conditions in a PowerShell if-statement
- I get an error when I end the if statement with a concluding else statement
- Does PHP have short-circuit evaluation?
- Why is this code still adding 1 to i even when the if statment that does so isnt called in C?
- error compiling in c user input
- R Conditional IfElse With Random Values
- Can not get past illogical line pep8 error
- smarty help with if statement
- 'if' must have both main and 'else' branches if used as an expression
- What is the standard for choosing "when" vs "if/else" in Kotlin?
- Python script continuously repeats the first if - else statement
- Why does python use 'else' after for and while loops?
- Use of ternary operator instead of if-else in C++
- Evaluate boolean environment variable in Python
- How to use if/else statement in terraform for loop
- change number grade to letter grade
- How to debug this substring matching code?
- If condition is getting skipped even if the condition is true
- Assign value to all rows based on condition being fulfilled or not
- Looping through a list in Python
- Why does if (fork() || fork() || fork()) behave differently?
- Python if not == vs if !=
- Discord.py | If statement not working correctly
- Angular 17 - In @if syntax, how to store returned value from a function in a variable and use it in the same @if block
- Angular: ng-content doesn't render with *ngIf then else
- How to get the next Bi-weekly date based on a given start date and today's date in Google Sheets
- What is the best way to refactor an if else branch
- Unreachable code in if-else structure
- Python if/else/elif
- Ternary conditional operator in Scala