I have 2 Sheets
Sheet A: Column (A1,A2,A3,A4)
Sheet B: Column (B1,B2,B3).
A1, B1 has few common data.
I need Result Table : Column (B1,A3,A4) Excel.png
Pls Help me.
I have 2 Sheets
Sheet A: Column (A1,A2,A3,A4)
Sheet B: Column (B1,B2,B3).
A1, B1 has few common data.
I need Result Table : Column (B1,A3,A4) Excel.png
Pls Help me.
If Table A starts in Column A, Table B i colum F and Result in Column J, then:
J3=F3
K3=IF(COUNTIF($A$3:$A$11,$J3),"",0)
Copy K3to L3, then copy all down.
Leo Skywalker
May the force be with you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks