<div>
Can someone answer, I need it bit urgent....
</div>


Can someone answer, I need it bit urgent....

<div>
Great!!!<br />
<br />
<br />
Thanks a lot.<br />
<br />
A
</div>


<div>
<div class="content wysiwyg-content">
I have data in Column A excel in the format:<br />
aaa\bbb\ccc\ddd\123.xls<br />
<br />
I want two things to be done from this data:<br />
1. I want to extract everything from column A before last \ , that means the formula should give result: aaa\bbb\ccc\ddd<br />
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 &amp;&nbsp;take out unique values out of it.<br />
<br />
Thanks, <br />
A
</div>
</div>


I have data in Column A excel in the format:
aaa\bbb\ccc\ddd\123.xls

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.

Thanks, 
A

Excel extract data

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.