I need a formula

Hi:

I need a special formula to remove dupes.  Here is the breakdown
























Hardin Andrea Palmer APRN
Hardin Andrea Palmer APRN
Hardin Andrea Palmer APRN
Hardin Andrea Palmer APRN
Hardin Andrea Palmer APRN
Hardin Andrea T Watson MD
Hardin Andrea Walker MD
Hardin Andrea Walker MD
Hardin Andrew J Steele OD
Hardin Anesh V Badiwala MD
Hardin Angel Miller APRN
Hardin Angela M Clater APRN
Hardin Anna M Louiso APRN
Hardin Anna M Louiso APRN
Hardin Anna M Louiso APRN
Hardin Anna M Louiso APRN
Hardin Anne F Fitzpatrick MD
Hardin Anthony E Abang MD
Hardin Anthony E Abang MD
Hardin Anthony E Abang MD

I need the provider to only be represented once per county.  So, Andrea Palmer might show in multiple counties.  Thats fine.  But she can only be counted ONCE per COUNTY.   How can I get rid of her extra lines in each county.

 

Ty.

By: Sarah

Leave a Reply

Your email address will not be published. Required fields are marked *