EXTRACT A LIST FROM 2 COLUMNS

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

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