I’ve this Excel file on which I’ve to apply specific conditions and filtered it out.
Input Looks like this: (below Image)
- If the “Name of the person” column has characters greater than 40 there should be “Abbreviation”.
- If the “Name of the person” column has less than 40 characters than it is not compulsory to have the “Abbreviation”.
- The “Address” field is compulsory.
Output Looks like this: (below Image)