I have an excel file with some data. in column E i have two values “TRUE” and “FALSE”.
I need to filter TRUE and if the filtered value is TRUE is found in column B i need to perform some action or if value FALSE is found i need to perform a different action. Someone please help me on this.
Note: the value True may not be there in column B always. The excel data is dynamic.