I have data in Column A excel in the format:
I want two things to be done from this data:
1. I want to extract everything from column A before last \ , that means the formula should give result: aaa\bbb\ccc\ddd
2. After this result is in new column, let's say the formula is pasted in Column E, I should be able to compare the whole column E & take out unique values out of it.