Hello guys
This is my first post here, but i went over previous posts searching for assistance with the following issue:
I need to remove duplicate values and leave only unique values. Remove duplicates function in Execl2010 is stating that no duplicates were found, although the selected data were correctly identified, and no spaces existed in different cells - i used func. LEN to verify this.
The example data looks like the following:
<tbody>
</tbody>
xlsx version available here: https://dl.dropboxusercontent.com/u/57324527/dupblic1.xlsx
Thank you for all those who are familiar with such questions and are willing to help
Thanks!
<tbody>
</tbody>
This is my first post here, but i went over previous posts searching for assistance with the following issue:
I need to remove duplicate values and leave only unique values. Remove duplicates function in Execl2010 is stating that no duplicates were found, although the selected data were correctly identified, and no spaces existed in different cells - i used func. LEN to verify this.
The example data looks like the following:
Col1 | Col2 | Col3 | Col4 | Col5 | |
Row1 | a | he's | since | anybod | hed |
Row2 | about | highly | singl | anyone | he'd |
Row3 | above | him | six | after | her |
Row4 | absolutely | himself | so | everybod | hers |
Row5 | across | his | after | everyone | herself |
Row6 | actually | hopefully | somebod | everything | hes |
Row7 | after | how | somehow | hed | his |
Row8 | again | however | someone | he'd | him |
Row9 | against | hundred | something | her | again |
<tbody>
</tbody>
xlsx version available here: https://dl.dropboxusercontent.com/u/57324527/dupblic1.xlsx
Thank you for all those who are familiar with such questions and are willing to help
Thanks!
<tbody>
</tbody>
Last edited: