Results 1 to 3 of 3

Thread: Filtering required fields in the mentioned excel Sheet

  1. #1

    Question Filtering required fields in the mentioned excel Sheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Files Attached Files

  2. #2
    Excel 2010 Table, PivotTable
    No formulas, no code needed.
    http://www.mediafire.com/view/vhs4lp.../05_19_14.xlsx

  3. #3
    Thank you very much... I got the result.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •