View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dingy101 Dingy101 is offline
external usenet poster
 
Posts: 23
Default Search for matches in two columns

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