Custom Filter/Sort

[peszekv]

Below is a data set from the FDA website. I am trying to ONLY display the most recent event (Inspection End Date) for each city and Center. for example in the dataset for city of Brentwood there are two dates May-12-2011 and Mar-23-2015 for the CDER center. in my table I only want to show Brentwood CDER Mar-23-2015. any help would be greatly appreciated

		District Firm Name City State Zip Code Country Inspection End Date Project Classification Center SJN Pfizer Pharmaceuticals LLC Arecibo PR 612 US Jan-13-2009 Drug Quality Assurance NAI CDER ORA Pfizer Italia S.r.l. Ascoli Piceno IT Nov-11-2010 Drug Quality Assurance NAI CDER SJN Pfizer Pharmaceuticals LLC Barceloneta PR 617 US Jul-02-2015 Drug Quality Assurance VAI CDER SJN Pfizer Pharmaceuticals LLC Barceloneta PR 617 US Feb-08-2010 Drug Quality Assurance VAI CDER SJN Pfizer Pharmaceuticals LLC Barceloneta PR 617 US Aug-20-2013 Drug Quality Assurance VAI CDER ORA Pfizer Perth Pty Ltd. Bentley AU Jan-30-2015 Drug Quality Assurance VAI CDER ORA Pfizer Perth Pty Ltd. Bentley AU Dec-13-2012 Drug Quality Assurance VAI CDER ORA Pfizer Perth Pty Ltd. Bentley AU Apr-15-2010 Drug Quality Assurance NAI CDER ORA Pfizer Global Supply - Brandon Brandon CA Mar-18-2010 Drug Quality Assurance NAI CDER ORA Pfizer Global Supply - Brandon Brandon CA Mar-07-2013 Drug Quality Assurance NAI CDER ORA Pfizer Global Supply - Brandon Brandon CA Feb-12-2016 Drug Quality Assurance NAI CDER KAN Meridian Medical Technologies a Pfizer Company Brentwood MO 63144-2504 US May-12-2011 Drug Quality Assurance NAI CDER KAN Meridian Medical Technologies a Pfizer Company Brentwood MO 63144-2504 US Mar-23-2015 Drug Quality Assurance VAI CDER KAN Meridian Medical Technologies a Pfizer Company Brentwood MO 63144-2504 US Jul-31-2009 Drug Quality Assurance VAI CDER KAN Meridian Medical Technologies a Pfizer Company Brentwood MO 63144-2504 US Jul-31-2009 Drug Quality Assurance VAI CDER KAN Meridian Medical Technologies a Pfizer Company Brentwood MO 63144-2504 US Jul-31-2009 Postmarket Surv. and Epidemiology VAI CDER KAN Meridian Medical Technologies a Pfizer Company Brentwood MO 63144-2504 US Jul-31-2009 Postmarket Surv. and Epidemiology VAI CDER KAN Meridian Medical Technologies a Pfizer Company Brentwood MO 63144-2504 US Feb-13-2012 Drug Quality Assurance VAI CDER KAN Meridian Medical Technologies a Pfizer Company Brentwood MO 63144-2504 US Feb-13-2012 Drug Quality Assurance VAI CDER KAN Meridian Medical Technologies a Pfizer Company Brentwood MO 63144-2504 US Aug-18-2010 Drug Quality Assurance VAI CDER KAN Meridian Medical Technologies a Pfizer Company Brentwood MO 63144-2504 US Aug-18-2010 Drug Quality Assurance VAI CDER NYK Pfizer, Inc. Brooklyn NY 11206-5026 US Oct-01-2008 Drug Quality Assurance NAI CDER SJN Pfizer Pharmaceuticals LLC Caguas PR 00725-3382 US Sep-01-2011 Drug Quality Assurance VAI CDER SJN Pfizer Pharmaceuticals LLC Caguas PR 00725-3382 US Mar-19-2009 Drug Quality Assurance VAI CDER SJN Pfizer Pharmaceuticals LLC Caguas PR 00725-3382 US Mar-19-2009 Postmarket Surv. and Epidemiology VAI CDER SJN Pfizer Pharmaceuticals LLC-Piperacillin Carolina PR 00987-7627 US Sep-15-2010 Drug Quality Assurance NAI CDER SJN Pfizer Pharmaceuticals LLC-Piperacillin Carolina PR 00987-7627 US Feb-03-2012 Drug Quality Assurance VAI CDER SJN Pfizer Pharmaceuticals LLC-Piperacillin Carolina PR 00987-7627 US Aug-07-2009 Drug Quality Assurance VAI CDER SJN Pfizer Pharmaceuticals LLC-Piperacillin Carolina PR 00987-7627 US Aug-07-2009 Postmarket Surv. and Epidemiology NAI CDER ATL Pfizer Inc Cary NC 27513-5758 US Aug-26-2010 Postmarket Surv. and Epidemiology NAI CDER ATL Pfizer Inc Cary NC 27513-5758 US Aug-25-2011 Postmarket Surv. and Epidemiology NAI CDER KAN Pfizer Inc Chesterfield MO 63017-1732 US May-21-2014 Drug Quality Assurance NAI CDER KAN Pfizer Inc Chesterfield MO 63017-1732 US Feb-29-2012 Drug Quality Assurance NAI CDER KAN Pfizer Inc Chesterfield MO 63017-1732 US Feb-16-2016 Drug Quality Assurance VAI CDER PHI Pfizer, Inc. Collegeville PA 19426-3982 US Jun-24-2010 Postmarket Surv. and Epidemiology NAI CDER PHI Pfizer, Inc. Collegeville PA 19426-3982 US Jun-06-2013 Bioresearch Monitoring VAI CDER PHI Pfizer, Inc. Collegeville PA 19426-3982 US Aug-15-2013 Special Field Assignment NAI CDER ORA Pfizer Ireland Pharmaceuticals County Cork IE Jun-17-2011 Drug Quality Assurance VAI CDER ORA Pfizer Ireland Pharmaceuticals County Cork IE Apr-11-2014 Drug Quality Assurance NAI CDER ORA Pfizer Ireland Pharmaceuticals Dublin IE Oct-15-2013 Drug Quality Assurance NAI CDER ORA Pfizer Ireland Pharmaceuticals Dublin IE Jun-28-2012 Vaccines and Allergenic Products VAI CBER ORA Pfizer Ireland Pharmaceuticals Dublin IE Jun-17-2014 Vaccines and Allergenic Products VAI CBER ORA Pfizer Ireland Pharmaceuticals Dublin IE Aug-31-2010 Vaccines and Allergenic Products VAI CBER ORA Pfizer Ireland Pharmaceuticals Dublin IE Apr-24-2009 Drug Quality Assurance VAI CDER ORA Pfizer Manufacturing Deutschland GmbH Freiburg DE Mar-04-2016 Drug Quality Assurance NAI CDER ORA Pfizer Manufacturing Deutschland GmbH Freiburg DE Jun-30-2011 Drug Quality Assurance VAI CDER ORA Pfizer Manufacturing Deutschland GmbH Freiburg DE Jun-15-2012 Drug Quality Assurance VAI CDER ORA Pfizer Manufacturing Deutschland GmbH Freiburg DE Apr-03-2014 Drug Quality Assurance VAI CDER ORA Hisun Pfizer Pharmaceuticals Co., Ltd Fuyang City CN Apr-25-2015 Drug Quality Assurance VAI CDER NWE Pfizer Inc. Groton CT 06340-5157 US May-07-2012 Bioresearch Monitoring NAI CDER NWE Pfizer Inc. Groton CT 06340-5157 US Jun-09-2011 Bioresearch Monitoring NAI CDER NWE Pfizer Inc. Groton CT 06340-5157 US Jun-06-2012 Bioresearch Monitoring VAI CDER NWE Pfizer Inc. Groton CT 06340-5157 US Jun-03-2009 Bioresearch Monitoring OAI CDER NWE Pfizer Inc. Groton CT 06340-5157 US Jul-14-2010 Drug Quality Assurance NAI CDER NWE Pfizer Inc. Groton CT 06340-5157 US Jul-14-2010 Monitoring of Marketed Animal Drugs, Feed, and Devices NAI CVM NWE Pfizer Inc. Groton CT 06340-5157 US Jan-23-2015 Drug Quality Assurance VAI CDER NWE Pfizer Inc. Groton CT 06340-5157 US Jan-23-2015 Monitoring of Marketed Animal Drugs, Feed, and Devices NAI CVM NWE Pfizer Inc. Groton CT 06340-5157 US Feb-24-2012 Drug Quality Assurance VAI CDER NWE Pfizer Inc. Groton CT 06340-5157 US Feb-24-2012 Monitoring of Marketed Animal Drugs, Feed, and Devices NAI CVM NWE Pfizer Inc. Groton CT 06340-5157 US Dec-05-2014 Bioresearch Monitoring NAI CDER NWE Pfizer Inc. Groton CT 06340-5157 US Aug-11-2009 Monitoring of Marketed Animal Drugs, Feed, and Devices NAI CVM NWE Pfizer Inc. Groton CT 06340-5157 US Apr-30-2012 Bioresearch Monitoring NAI CDER ORA Laboratorios Pfizer Ltda Guarulhos BR Jun-10-2010 Monitoring of Marketed Animal Drugs, Feed, and Devices NAI CVM ORA Laboratorios Pfizer Ltda Guarulhos BR Feb-23-2016 Monitoring of Marketed Animal Drugs, Feed, and Devices NAI CVM ORA Laboratorios Pfizer Ltda Guarulhos BR Dec-11-2012 Monitoring of Marketed Animal Drugs, Feed, and Devices VAI CVM CHI Hospira Inc., A Pfizer Company Lake Forest IL 60045-2579 US May-28-2014 Compliance: Devices VAI CDRH CHI Hospira Inc., A Pfizer Company Lake Forest IL 60045-2579 US May-28-2014 Postmarket Assurance: Devices NAI CDRH CHI Hospira Inc., A Pfizer Company Lake Forest IL 60045-2579 US May-27-2015 Compliance: Devices OAI CDRH CHI Hospira Inc., A Pfizer Company Lake Forest IL 60045-2579 US May-27-2015 Postmarket Assurance: Devices OAI CDRH CHI Hospira Inc., A Pfizer Company Lake Forest IL 60045-2579 US Jul-20-2009 Compliance: Devices NAI CDRH CHI Hospira Inc., A Pfizer Company Lake Forest IL 60045-2579 US Jul-14-2016 Compliance: Devices NAI CDRH CHI Hospira Inc., A Pfizer Company Lake Forest IL 60045-2579 US Jul-13-2012 Compliance: Devices VAI CDRH CHI Hospira Inc., A Pfizer Company Lake Forest IL 60045-2579 US Jul-13-2012 Postmarket Assurance: Devices VAI CDRH CHI Hospira Inc., A Pfizer Company Lake Forest IL 60045-2579 US Feb-07-2013 Compliance: Devices OAI CDRH CHI Hospira Inc., A Pfizer Company Lake Forest IL 60045-2579 US Feb-07-2013 Postmarket Assurance: Devices OAI CDRH MIN Pfizer, Inc Middleton WI 53562-5523 US Nov-21-2013 Blood and Blood Products VAI CBER MIN Pfizer, Inc Middleton WI 53562-5523 US Jan-28-2010 Blood and Blood Products VAI CBER ORA Pfizer Global Supply Japan Inc. Nagoya JP Jan-23-2014 Monitoring of Marketed Animal Drugs, Feed, and Devices NAI CVM NYK Pfizer Inc. New York NY 10017-5703 US Oct-15-2012 Drug Quality Assurance VAI CDER NYK Pfizer Inc. New York NY 10017-5703 US Oct-15-2012 Postmarket Surv. and Epidemiology VAI CDER NYK Pfizer Inc. New York NY 10017-5703 US Jun-06-2012 Bioresearch Monitoring NAI CDER NYK Pfizer Inc. New York NY 10017-5703 US Aug-10-2009 Drug Quality Assurance OAI CDER NYK Pfizer Inc. New York NY 10017-5703 US Aug-10-2009 Postmarket Surv. and Epidemiology OAI CDER ORA Pfizer Ireland Pharmaceuticals Newbridge IE Jul-29-2016 Drug Quality Assurance VAI CDER ORA Pfizer Ireland Pharmaceuticals Newbridge IE Feb-08-2013 Drug Quality Assurance NAI CDER ORA Pfizer Ireland Pharmaceuticals Newbridge IE Aug-20-2009 Drug Quality Assurance VAI CDER NWJ Pfizer Inc. Parsippany NJ 07054-2826 US Sep-05-2013 Drug Quality Assurance NAI CDER NWJ Pfizer Inc. Parsippany NJ 07054-2826 US Mar-11-2011 Drug Quality Assurance NAI CDER NWJ Pfizer Inc. Parsippany NJ 07054-2826 US Jun-02-2016 Drug Quality Assurance NAI CDER NWJ Pfizer Inc Peapack NJ 7977 US Jun-10-2010 Drug Quality Assurance VAI CDER NWJ Pfizer Inc Peapack NJ 7977 US Aug-31-2010 Drug Quality Assurance VAI CDER NYK Pfizer Inc. Pearl River NY 10965-1215 US Oct-24-2012 Vaccines and Allergenic Products VAI CBER NYK Pfizer Inc. Pearl River NY 10965-1215 US Oct-08-2008 Food Composition, Standards, Labeling and Econ VAI CFSAN NYK Pfizer Inc. Pearl River NY 10965-1215 US Jul-18-2012 Food Composition, Standards, Labeling and Econ NAI CFSAN NYK Pfizer Inc. Pearl River NY 10965-1215 US Jul-18-2012 Foodborne Biological Hazards NAI CFSAN NYK Pfizer Inc. Pearl River NY 10965-1215 US Jul-01-2009 Vaccines and Allergenic Products NAI CBER ORA Pfizer Manufacturing Belgium NV Puurs BE Sep-23-2011 Drug Quality Assurance VAI CDER ORA Pfizer Manufacturing Belgium NV Puurs BE Jun-30-2015 Drug Quality Assurance VAI CDER ORA Pfizer Ireland Pharmaceuticals Ringaskiddy IE Jun-24-2011 Drug Quality Assurance VAI CDER ORA Pfizer Ireland Pharmaceuticals Ringaskiddy IE Aug-01-2014 Drug Quality Assurance VAI CDER ATL Hospira a Pfizer Company Rocky Mount NC 27804-8612 US Sep-24-2015 Drug Quality Assurance VAI CDER ATL Hospira a Pfizer Company Rocky Mount NC 27804-8612 US Sep-24-2015 Compliance: Devices VAI CDRH ATL Hospira a Pfizer Company Rocky Mount NC 27804-8612 US Sep-24-2015 Postmarket Assurance: Devices VAI CDRH ATL Hospira a Pfizer Company Rocky Mount NC 27804-8612 US Nov-15-2013 Compliance: Devices OAI CDRH ATL Hospira a Pfizer Company Rocky Mount NC 27804-8612 US Nov-15-2013 Postmarket Assurance: Devices VAI CDRH ATL Hospira a Pfizer Company Rocky Mount NC 27804-8612 US Mar-01-2013 Drug Quality Assurance VAI CDER ATL Hospira a Pfizer Company Rocky Mount NC 27804-8612 US Jun-17-2011 Drug Quality Assurance OAI CDER ATL Hospira a Pfizer Company Rocky Mount NC 27804-8612 US Jun-17-2011 Compliance: Devices VAI CDRH ATL Hospira a Pfizer Company Rocky Mount NC 27804-8612 US Jun-13-2014 Drug Quality Assurance NAI CDER ATL Hospira a Pfizer Company Rocky Mount NC 27804-8612 US Jun-13-2014 Monitoring of Marketed Animal Drugs, Feed, and Devices NAI CVM ATL Hospira a Pfizer Company Rocky Mount NC 27804-8612 US Jan-19-2010 Drug Quality Assurance OAI CDER ATL Hospira a Pfizer Company Rocky Mount NC 27804-8612 US Jan-19-2010 Compliance: Devices OAI CDRH ATL Hospira a Pfizer Company Rocky Mount NC 27804-8612 US Jan-19-2010 Postmarket Assurance: Devices OAI CDRH ATL Hospira a Pfizer Company Rocky Mount NC 27804-8612 US Aug-21-2009 Drug Quality Assurance VAI CDER ATL Hospira a Pfizer Company Rocky Mount NC 27804-8612 US Aug-21-2009 Compliance: Devices NAI CDRH ATL Hospira a Pfizer Company Rocky Mount NC 27804-8612 US Aug-04-2011 Drug Quality Assurance OAI CDER NYK Wyeth Pharmaceuticals Inc., a subsidiary of Pfizer, Inc. Rouses Point NY 12979-1424 US Jul-21-2011 Drug Quality Assurance NAI CDER NYK Wyeth Pharmaceuticals Inc., a subsidiary of Pfizer, Inc. Rouses Point NY 12979-1424 US Jul-10-2009 Drug Quality Assurance NAI CDER NYK Wyeth Pharmaceuticals Inc., a subsidiary of Pfizer, Inc. Rouses Point NY 12979-1424 US Dec-17-2009 Drug Quality Assurance NAI CDER NYK Wyeth Pharmaceuticals Inc., a subsidiary of Pfizer, Inc. Rouses Point NY 12979-1424 US Dec-17-2009 Monitoring of Marketed Animal Drugs, Feed, and Devices NAI CVM NYK Wyeth Pharmaceuticals Inc., a subsidiary of Pfizer, Inc. Rouses Point NY 12979-1424 US Apr-06-2012 Drug Quality Assurance NAI CDER NYK Wyeth Pharmaceuticals Inc., a subsidiary of Pfizer, Inc. Rouses Point NY 12979-1424 US Apr-06-2012 Monitoring of Marketed Animal Drugs, Feed, and Devices NAI CVM ORA Pfizer Canada Inc. Saint-Laurent CA Jun-28-2011 Drug Quality Assurance NAI CDER ORA Pfizer Canada Inc. Saint-Laurent CA Feb-07-2014 Drug Quality Assurance NAI CDER ORA Pfizer Canada Inc. Saint-Laurent CA Apr-20-2009 Drug Quality Assurance NAI CDER ATL Wyeth Pharmaceutical Division of Wyeth Holdings LLC, Pfizer Sanford NC 27330-9550 US Nov-18-2011 Vaccines and Allergenic Products VAI CBER ATL Wyeth Pharmaceutical Division of Wyeth Holdings LLC, Pfizer Sanford NC 27330-9550 US Jul-23-2014 Vaccines and Allergenic Products VAI CBER ATL Wyeth Pharmaceutical Division of Wyeth Holdings LLC, Pfizer Sanford NC 27330-9550 US Feb-28-2011 Drug Quality Assurance NAI CDER ATL Wyeth Pharmaceutical Division of Wyeth Holdings LLC, Pfizer Sanford NC 27330-9550 US Dec-11-2009 Vaccines and Allergenic Products VAI CBER ATL Wyeth Pharmaceutical Division of Wyeth Holdings LLC, Pfizer Sanford NC 27330-9550 US Aug-18-2016 Vaccines and Allergenic Products VAI CBER ORA Pfizer Asia Pacific Pte Ltd. Singapore SG Mar-19-2009 Drug Quality Assurance NAI CDER ORA Pfizer Asia Pacific Pte Ltd. Singapore SG Mar-01-2013 Drug Quality Assurance NAI CDER ORA Pfizer Asia Pacific Pte Ltd. Singapore SG Dec-03-2015 Drug Quality Assurance NAI CDER ORA Pfizer Health AB Strangnas SE Sep-06-2012 Drug Quality Assurance VAI CDER ORA Pfizer Health AB Strangnas SE Jan-27-2011 Drug Quality Assurance VAI CDER DET Pfizer Inc Terre Haute IN 47802-8019 US Jun-24-2010 Drug Quality Assurance NAI CDER DET Pfizer Inc Terre Haute IN 47802-8019 US Jun-24-2010 Monitoring of Marketed Animal Drugs, Feed, and Devices NAI CVM DET Pfizer Inc Terre Haute IN 47802-8019 US Jul-23-2009 Drug Quality Assurance NAI CDER SJN Pfizer Pharmaceuticals LLC Vega Baja PR 693 US Mar-25-2009 Drug Quality Assurance VAI CDER SJN Pfizer Pharmaceuticals LLC Vega Baja PR 693 US Mar-25-2009 Postmarket Surv. and Epidemiology NAI CDER SJN Pfizer Pharmaceuticals LLC Vega Baja PR 693 US Mar-11-2014 Drug Quality Assurance VAI CDER SJN Pfizer Pharmaceuticals LLC Vega Baja PR 693 US Jul-26-2016 Drug Quality Assurance VAI CDER SJN Pfizer Pharmaceuticals LLC Vega Baja PR 693 US Jul-16-2013 Drug Quality Assurance VAI CDER SJN Pfizer Pharmaceuticals LLC Vega Baja PR 693 US Jan-26-2011 Drug Quality Assurance VAI CDER SJN Pfizer Pharmaceuticals LLC Vega Baja PR 693 US Aug-10-2012 Drug Quality Assurance VAI CDER <tbody> </tbody><colgroup><col><col><col><col><col><col><col><col><col><col></colgroup> <tbody> </tbody>

<tbody>
</tbody><colgroup><col><col span="2"></colgroup>

 

[hb_123]

If it's just a matter of displaying, I would first sort by the company/firm name and then date (newest to oldest). Then I would add another column with a formula checking if the firm name in cell 1= cell 2. Exclude the cells with TRUE (these would be the duped names with old dates).

Alternatively you can simply sort by firm and date, then select all the data use the Remove Duplicates functionality present in excel.

I expect either should do the trick.