Hi,
Give headings to the first range, say Header1. To the second range, give a
heading Header2. Say that the data (including the header row) is D8:E16.
In H9, enter =COUNTIF($D$9:$D$16,E9)=1. In cell L8, enter Header2. Go to
Data Filter Advanced Filter and select Copy to another location. In the
list range, select D8:E16. In the criteria range, select H8:H9. In the
copy to box, select L8. Click on OK
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Dingy101" wrote in message
...
First two columns of data which will vary depending on other functions in
worksheet
8 9 5
5 7 5
5 7 4
4 5 0
2 5
1 5
0 4
0 0
I want to in a third column to list any occurences of values in column 2
that appear in column 1, including multiples, there will always be 16 rows
of
this data. I already have data sorted in accending order in first and
second
columns using Large function. Also would be helpful to blank any 0 value.
Would be nice if empty values in third column are blank, but can deal with
anything.
Thank You in advance
Gary