Hi All,
I am just confused on apparently a small technique for filtering my data based on different conditions. For example, I have two text columns which are presented below for understanding. I need to filter out rows which are underline and italicized, but still able to filter out as per attached image only. Please guide how to include further criteria for filtering data as required.
segment product
staff a
staff b
staff c
staff d
consumer a
consumer b
consumer c
consumer d
Hi Abid,
Please, always supply a file so we don't have to recreate your data.
You could do this by creating a merged column then filtering out what you don't want e.g. filter out staffa staffd etc - see attached file.
Regards
Phil
