If you have an excel workbook with duplicate records in a column.
e.g.
FMBSMOV
FMBSMOV
FMBSMOV
FMBSMOV
FMBSMOV
FMBSMOW
FMBSMOW
FMBSMOW
FMBSMOW
FMBSMOX
FMBSMOX
FMBSMOX
FMBSMOX
In order to list only the unique records in the column you could use the advance filter option in excel:
Select check-box Unique Records Only and click OK
This will list all the unique records in the column in excel workbook.
Issues faced - solutions identified - shared with community.
Subscribe To AppMuncher
Posts
Comments
Popular
-
To export DDL. 1. Access the database on TOAD. 2. From Menu options Select DATABASE --> EXPORT --> EXPORT DDL ... -
Recently had an issue installing the .NET Framework 3.5 on a win 2016 server hosted in Azure. Tried adding it using Roles and Features, Fai... -
I had to compare data between two different sheets, then fetch the data from a specific cell in sheet B and copy it to another cell in Sheet...
Copyright 2023, App Muncher. All rights Reserved.
| Designed by AppMuncher
No comments:
Post a Comment