Related:
- Matching the case in excel cell
- Excel mod apk for pc - Download - Spreadsheets
- Arrow keys not working in excel - Guide
- Excel multiple lines in one cell - Guide
- Vat calculation excel - Guide
- Kernel for excel repair - Download - Backup and recovery
2 responses
mikethedike
Posts
158
Registration date
Saturday 16 August 2008
Status
Member
Last seen
22 September 2012
41
1 May 2009 à 02:44
1 May 2009 à 02:44
the simplest of all is add filter to the cells that contain the data
awaiting acomments
Melisio Masvarenhas
mikethedike
India
awaiting acomments
Melisio Masvarenhas
mikethedike
India
You can do this by either of two ways:
1. Sort the contents and in the blank column put the formula in row # 2 =if(A2=A1,"Duplicate,"") and fill down the formula till the last record... The word "Duplicate" will appear against the values which are duplicated.
2. You can create a Pivot table in another working sheet wherein put the Values in Columns and the count of Values in Data field... this will show you A.K. as column header in pivot and 2 as its count.
1. Sort the contents and in the blank column put the formula in row # 2 =if(A2=A1,"Duplicate,"") and fill down the formula till the last record... The word "Duplicate" will appear against the values which are duplicated.
2. You can create a Pivot table in another working sheet wherein put the Values in Columns and the count of Values in Data field... this will show you A.K. as column header in pivot and 2 as its count.
1 May 2009 à 02:52
Regards,
Ashish Ranjan