With MobiSheets, you can easily search and remove any duplicates of data in columns.
1. Open your MobiSheets document.
2. Select a column or a range of columns (left-click and drag).
3. Click Data from the main ribbon, followed by Remove Duplicates.
4. After the selection of columns, confirm with OK.