Related:
- Matching the case in excel cell
- Number to words in excel - Guide
- Gif in excel - Guide
- Marksheet in excel - Guide
- How to take screenshot in excel - Guide
- Excel apk for pc - Download - Spreadsheets
2 responses
mikethedike
Posts
158
Registration date
Saturday August 16, 2008
Status
Member
Last seen
September 22, 2012
41
May 1, 2009 at 02:44 AM
May 1, 2009 at 02:44 AM
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.
May 1, 2009 at 02:52 AM
Regards,
Ashish Ranjan