Filtering required fields in the mentioned excel Sheet

rajeshnulu

New member
Joined
May 19, 2014
Messages
2
Reaction score
0
Points
0
Open the attachment - Look at the First Sheet.
Take the Example of fields which are colored in blue.


You can see multiple entries of same System name.
Every Event ID has different Event Generated Time.
I want to the list of 1202 & 1203 Event ID's of all Systems which has the most recent Event generated time and delete the rest of all old entries of each System Name.


As per the example of System Name: ASHSE642010266


Desired output:
5/12/2014 18:00 1202 ASHSE642010266
5/12/2014 18:08 1203 ASHSE642010266


Delete rest of the Entries of ASHSE642010266


This output should reflect on all the System Names accordingly.

Thanks in advance

Rajesh Nulu
+91 9620475594
 

Attachments

  • ODS_Scan_1202,_1203_19 MAY 2014 - Copy.xlsx
    385.9 KB · Views: 8
Top