Show duplicates in cell for filter
 

I am going to paste a set of addresses to the bottom of a sheet that already
contains addresses. The first set of addresses has additional information and
i would like to use the cell on the end to highlight the duplicates so i can
filter them.
I have number in cell E such as 110 and in cell F i have number the number
but it could be A, B etc like 110A. In cell H i have the road name. In the
list of addresse i am attaching to the bottom it will only use cell e for
number as the 110/110A are all mixed up but the road name is still in Cell H.
Does anyone have an idea how i could do this?

Many thanks for looking!

Show duplicates in cell for filter
 

If you've entered those values as Text, you could use a custom filter and either
"begins with" or "contains" 110.



Neil wrote:

I am going to paste a set of addresses to the bottom of a sheet that already
contains addresses. The first set of addresses has additional information and
i would like to use the cell on the end to highlight the duplicates so i can
filter them.
I have number in cell E such as 110 and in cell F i have number the number
but it could be A, B etc like 110A. In cell H i have the road name. In the
list of addresse i am attaching to the bottom it will only use cell e for
number as the 110/110A are all mixed up but the road name is still in Cell H.
Does anyone have an idea how i could do this?

Many thanks for looking!

--

Dave Peterson