In my data output below you will see I have the potential for there to be a separate instance (or instances) of a row based on the "valid from" date.
In these instances, how can I get my output, such that I keep only one instance, and that being the one with the latest valid from date? The example below could have 1 or more duplicates based on date, and I want to keep just the row with the latest date. So I would end up in the example below with rows, 13, 14, 16, 17, 18, 19, 20 in my output.
My guess is a formula that says, is Item Number and Component are the same, then look at the Valid From and keep the latest date. But I cannot figure out how to write it or if there is an even better way to accomplish the task.
Thanks,
Larry
