My apologies, I should have been more specific and added more data to the table to better understand the challenge I'm having: IP SCAN_DATE Data
192.168.1.1 FEB 16, 2021 11:30:29 EST 1
192.168.1.1 FEB 16, 2021 11:30:29 EST 2
192.168.1.1 FEB 13, 2021 11:30:29 EST 5
192.168.1.2 FEB 11, 2021 11:30:29 EST 3
192.168.1.2 FEB 14, 2021 11:30:29 EST 4
192.168.1.2 FEB 14, 2021 11:30:29 EST 6
192.168.1.3 FEB 12, 2021 11:30:29 EST 8
192.168.1.3 FEB 18, 2021 11:30:29 EST 20
192.168.1.3 FEB 18, 2021 11:30:29 EST 21 If I run: | inputcsv my.csv
| tail 1 I'll get: IP Scan_Date Data
192.168.1.1 FEB 16, 2021 11:30:29 EST 1
192.168.1.2 FEB 14, 2021 11:30:29 EST 4
192.168.1.3 FEB 18, 2021 11:30:29 EST 20 Tail only pulls the first field value for the latest scan_date it sees for each IP. I need all field values (all data) for each IP for the newest date. The search would return something like this (it would ignore the older SCAN_DATE for each IP): IP SCAN_DATE Data
192.168.1.1 FEB 16, 2021 11:30:29 EST 1
192.168.1.1 FEB 16, 2021 11:30:29 EST 2
192.168.1.2 FEB 14, 2021 11:30:29 EST 4
192.168.1.2 FEB 14, 2021 11:30:29 EST 6
192.168.1.3 FEB 18, 2021 11:30:29 EST 20
192.168.1.3 FEB 18, 2021 11:30:29 EST 21 Any ideas?
... View more