Deleting duplicate rows

  • Thread starter Thread starter Ranju
  • Start date Start date
R

Ranju

Hi,

I have a table of in/out times drawn from a attendance device. This data is
too big and it has repeatition of one name for eg. Ramesh is repeated
continously for each day of jan along with his in and out timings, in this
way there are almost 900 people in our org.
Now what i want is each persons name only once along with all other details
and the remaining rows i want them to be deleted as they are of no use. So
this way i want only 900 names each in one row.
Is there a short cut to this may be a short cut key or a macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

shortcut-> deleting entire row (not just the data) 5
Add columns to reach a predetermined value 2
Deleting blank rows 4
Sorting multiple rows... 4
Copy all Rows from Several Sheets to 1 Sheet At Once 1
Locating row with no duplicate matching amount 1
Merge the same group of cells down a column quickly 9
VBAscript for data matching excels 0

Back
Top