Hi Excel Guru,
Today I was trying to remove duplicates for analysis purpose and I came across a situation where I couldn't remove any duplicate using built-in duplicate remove.
I believe this issue is caused by inclusion of integer and integer+txt data in the list, excel is getting confused ?
I have attached the list for your reference. Please have a look at it and if you could point me how to overcome this issue that would be great.
http://www.mediafire.com/view/?cc36ekd8y2l7e0g
Regards,
Z.
Today I was trying to remove duplicates for analysis purpose and I came across a situation where I couldn't remove any duplicate using built-in duplicate remove.
I believe this issue is caused by inclusion of integer and integer+txt data in the list, excel is getting confused ?
I have attached the list for your reference. Please have a look at it and if you could point me how to overcome this issue that would be great.
http://www.mediafire.com/view/?cc36ekd8y2l7e0g
Regards,
Z.