EXTRACT A LIST FROM 2 COLUMNS [Closed]

Report
-
mubashir aziz
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,

I would like to know how can i extract 1 list (column c) that consist of values that appear on both columns (A & B)?

E.g
Column A Column B Column C (e.g answer)
202 203 203
203 204 204
204 206
205 207

1 reply

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
210
Suppose data started from row A2:B50 then in C2 write this formula

C2=IF(ISERROR(MATCH(A2,$B$2:$B$50,0)),"",A2)


and drag it down ......


1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4065 users have said thank you to us this month