Scribd
Upload
34 views2 pages

Absentees List

The document provides instructions to extract timestamp and email ID information from a cell containing both, then extract just the student ID from the same cell and sort the data to remove duplicate entries.

Uploaded by

ravikumar rayala
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
34 views2 pages

Absentees List

The document provides instructions to extract timestamp and email ID information from a cell containing both, then extract just the student ID from the same cell and sort the data to remove duplicate entries.

Uploaded by

ravikumar rayala
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Assume your data having Time Stamp and email I.d.s Starts in C7.

1. Then go to a Empty column let us say D.


Let us say D7 is the 1st Cell.
1. In D7 use
=LEFT(C7,FIND("@",C7))
---> Gives Time stamp and I.ds ending with @

2.Go to next column Let us say E.


In E7 use
=RIGHT(E7,11)
---> Gives Data with student I.ds
3.Now you can Select all data and SORT in Ascending order

4. Go to “DATA” in Menu and Choose “Remove Duplicate Entries”

You might also like