View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Bob is offline
external usenet poster
 
Posts: 972
Default READING DATA FROM COLUMNS

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