Hii Team,
How can we filter Excel File which is in Tis format
Client Id | Client Name | Total-Cost | Email-Id
1 | Ankit | 1000 | ank******
2 | Jay | 0 | ja*****
3 | Avneet | USA | avk@yahoo.com
So in this table only Total-Cost containing Values should be Kept
Any other string value such as Client Avneet Contains Total-Cost USA so that must me removed using filter
Also Before removing a mail should be sent to avneet at avk@yahoo.com specifying the value in Total-Cost is incorrect
Required Values from table after filter
Client Id | Client Name | Total-Cost | Email-Id
1 | Ankit | 1000 | ank******
2 | Jay | 0 | ja*****