I'm going to be importing an excel file of all the units we have created over the past ~ 20 years.
Before I put them into filemaker I want to sort the records because the file is in a bit of a mess.
Basically I want to remove all duplicate values and for the units to show the latest information.
As units come in for service there will be multiple occurances of them in the spreadsheet. I am only interested in the most recent occurance, As i want to populate my filemaker units table with only single occurances of serial numbers.
How would be best to do this?
Snapshot of data.