Unique Number But Different Letter want to one

[ilayaraja]

Hi,


I have the details of unique number but different letter like OA,OC...

How i find out the unique number but Pure OA

the unique number but pure OC

The unique number combination of OA&OC using Excel formulae

200057706 OA

200057706 OC

200057706 OA

200057706 OB

800001312 OA

800001312 OC

800001312 OD


Thanks

 

[vasim]

Have you tried using a Pivot table????


Cheers

 

[sdsurzh]

Hi,


Combine 200057706&" "&OA then remove duplicate 2007 excel as.


Thanks,

Suresh Kumar S

 

[bobhc]

Good day ilayaraja


If you do not feel comfortable with pivot tables turn your data in to a table. If you have headers to the columns then they will become searchable. Use the "Text Filtes"--"Ends With" then just enter the text combination.


For the second part of your question just uncheck the values you do not want in the search drop down