EXTRACT A LIST FROM 2 COLUMNS

Closed
LOMALO - 2 Jul 2009 à 05:38
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 - 2 Jul 2009 à 07:00
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
Related:

1 response

mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 166
2 Jul 2009 à 07:00
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 ......