Giovannicavuccio
New Member
- Joined
- Apr 17, 2024
- Messages
- 1
- Office Version
- 365
- 2019
- Platform
- Windows
Hi guys, a silly question: is it possible to make it so that if I leave the cells with conditions empty, that condition is not counted? Let me explain better:
Right now, if for example I leave cell O8, which would be Hours blank the formula shows me ‘Player not found’ Instead, I would like to be shown all the player that got the other 3 conditions without caring about Hours. At the moment, I have tried to structure it like this, but it works fine only with gender (F/M) cause are only two options, but for the level and availability, things change. Could you help me?
I also tried to maybe put in the condition of the levels instead of
this
but it doesn’t work the same, could you help me? Thank you
K | L | M | N | O |
Player | Gender | Expertise | Weekday | Hours |
=filter function | M | Beginner | Monedy | PM |
Right now, if for example I leave cell O8, which would be Hours blank the formula shows me ‘Player not found’ Instead, I would like to be shown all the player that got the other 3 conditions without caring about Hours. At the moment, I have tried to structure it like this, but it works fine only with gender (F/M) cause are only two options, but for the level and availability, things change. Could you help me?
Excel Formula:
=IFNA(FILTER(Names!A3:A1001;Names!E3:E1001=M8; (IF(L8=”"; (Names!B3:B1001=“M”)+(Names!B3:B1001=“F”); Names!B3:B1001=L8));((Names!I3:I1001=N8) + (Names!G3:G1001=N8) + (Names!H3:H1001=N8) + (Names!F3:F1001=N8) + (Names!F3:F1001=“Every day”)); (Names!J3:J1001=O8));“Player not found”)
I also tried to maybe put in the condition of the levels instead of
Excel Formula:
Names!E3:E1001=M8
Excel Formula:
if(M8=“”;TRUE;Names!E3:E1001=M8)