Hi all. I have an Excel table, where I need to filter away all the rows where the field "Admin" is empty. I have made the filter this way:
But when I have a look at the body all the rows with blank admins is still present. Can anyone tell me what I am doing wrong?
Thanks in advance
/Frank
Solved! Go to Solution.
Please use the is not equal to condition:
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
Hi @venseben ,
Please try the following to see if this gets the results you need:
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
Dear Partner,
Created Excel with blank Name
Added filter array
Result:
+++++++++++++
I am able to fetch only the blank values
Did I answer your question? Please consider to mark my post as a solution to help others.
Regards,
Mohamed Sanuj Basheer
Please use the is not equal to condition:
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
Jesus Christ - was it that simple??? How embarrassing 😐🙄
Thank you SO much
/Frank