LinkBack URL
About LinkBacks
I have two columns. One column has values for 2600 rows and the other has values in 1000 row. I need to compare these two columns & the values appearing in both the columns are to be shown in third column.
I have two columns. One column has values for 2600 rows and the other has values in 1000 row. I need to compare these two columns & the values appearing in both the columns are to be shown in third column.
Assuming columns are A - C and theres a header row
In C2 enter the following
And then drag down
Please Login or Register to view this content.
If someone has helped you then please add to their Reputation
Hi,Originally Posted by Sham Sundar
Please find the attached file.
This is using a helper column.
Assuming the two columns with values are in A and B, use the formula for helper column :Formula:
Please Login or Register to view this content.
And then to get the matching values column, use the formula:Assuming helper column is CFormula:Please Login or Register to view this content.
Regards
pls attach a sample file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Assuming A & B column have data then.
Try
D2with control+Shift+Enter. and drag down.Formula:Please Login or Register to view this content.
Check the attached file.
Last edited by shukla.ankur281190; 10-18-2016 at 07:05 AM.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
or can try
change range reference as per your needsPlease Login or Register to view this content.
Try this...
Data Range
This array formula** entered in D1:
=IFERROR(INDEX(B:B,SMALL(IF(ISNUMBER(MATCH(B$1:B$9,A$1:A$15,0)),ROW(B$1:B$9)),ROWS(D$1:D1))),"")
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Copy down until you get blanks.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks