16
Jul
Jul
I was export from one software, but its comes doublicate. Just i want to know how to find out the dublicates on the list. Any formula for that? That formula have to show which iteam is dulicate. please help me.
Answer:
1.countfi(range,cell)
2.pivot table
data —- pivot table —–
select range next
drag the column heading in rows and data
click on the button created in data and choose count from the list
Book Mark it-> del.icio.us | Reddit | Slashdot | Digg | Facebook | Technorati | Google | StumbleUpon | Window Live | Tailrank | Furl | Netscape | Yahoo | BlinkList
This entry was posted
on Wednesday, July 16th, 2008 at 3:11 pm and is filed under Software.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or TrackBack URI from your own site.