There is feature called autofilter that does exactly what you want. First
put a header cell on top of columns A&B. Click on A1 and pull-down:

Data FIlter AutoFilter

You can then set the filter to display only the rows with B in column A.
Copy the data and paste it elsewhere. Then turnoff the autofilter.

You will see that the correct data has been pasted.


--
Gary''s Student - gsnu200759


"Bob" wrote:

hOW CAN i READ THE CONTENTS OF A TWO COLUMN LIST AND PRODUCE A SEPERATE
COLUMN CONSISTING OF THE DATA IN COLUMN B OF THE ORIGINAL LIST ONLY WHEN
COLUMN A CONTAINS THE SAME DATA
IE

A 1 B 4
B 4 B 3
C 2
A 2
B 3
C 4

--
Thanks Bob