I have data with multiple columns and need to suppress whole row if `Reference` is repeated and `Condition ID` is latest number (this might repeat, but I need all repeated columns).

Following is my data. I want only the lines which say `Con-ID` is 13. Can anyone help with code?


    Status     IDFix     Reference      T/S     IDX     TEXT                Con-ID
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      1.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      2.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      3.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      4.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      5.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      6.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      7.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      8.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      9.00
    Granted     VP01     19751228     Y     2.00     PCT 2 - lights         9.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      10.00
    Granted     VP01     19751228     Y     2.00     PCT 2 - lights         10.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      11.00
    Granted     VP01     19751228     Y     2.00     PCT 2 - lights         11.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      12.00
    Granted     VP01     19751228     Y     2.00     PCT 2 - lights         12.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      13.00
    Granted     VP01     19751228     Y     2.00     PCT 2 - lights         13.00
    Granted     VP01     19751228     Y     3.00     PCT 1 - No Sign      13.00
    Granted     VP01     19751228     Y     4.00     PCT 2 - lights         13.00

I want the result as following: CON ID might change in next phase to 14, so i want only results that are latest CON ID. made it into groups based on reference and CON _D (Decreasing value) But unable to suppress repeated groups (Con ID) please help !!!!

    Status     IDFix     Reference      T/S     IDX     TEXT                Con-ID
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      13.00
    Granted     VP01     19751228     Y     2.00     PCT 2 - lights         13.00
    Granted     VP01     19751228     Y     3.00     PCT 1 - No Sign      13.00
    Granted     VP01     19751228     Y     4.00     PCT 2 - lights         13.00

Edited by Veeru28 - 21 Aug 2019 at 9:59pm