filter unique values.
>
> Or the counties are all different? If so sort the counties only,
> combined and find unique values.
>
> If the above not work, then code. let me know.
> David
>
> On Aug 9, 1:06 pm, daruM wrote:
>
>
>
> > Hello, I have the follow
I need to automate it so I would like to stay away from pivot. Can it
be done using a formula?
On Aug 10, 12:58 am, saggi wrote:
> Pivot can work for you...
--
--
Some important links for excel users:
1. Follow us
Hello, I have the following data in sheet1.
State County
NY Kings
NY Kings
NY Queens
NY Kings
NY Bronx
NJ Essex
NJ Bergen
NJ Essex
In sheet 2, I need to bring in all unique county for the state. So
for NY, I need to bring in Kings, Queens, and Bronx. Fo
