Create a calculated field to get a distinct name for the UPC as shown below.
You can then use this field and you should see only 1 value for the name. Now, whether you want to use MAX or MIN depends on your needs. If you have a date field, you can modify the calculation to get the latest name always.
Thanks for the help!!
Hari's idea work best for what I was doing.
I will keep Deepaks on hand too!
Great. Please close this thread now.