Forum Discussion
How to filter the data
If some of the Employees give cash and some of them are given by bank transfer.
The remaining people are not to give the money.
How to filter the employees who are not given the money for the party.
Click the drop-down arrow in the CASH column. Clear the check box for 100, then click OK.
Do the same for the TRS column.
If you want to return the numbers and names to a different range, use the formula
=FILTER(A3:B75, (C3:C75="")*(D3:D75=""))
