Finding similar data or numbers in two columns

S

sayemasof

I am dealing with a lot of data in spreadsheet. I need a macro program
so that i can find whether there are similar data or numbers in two
colums in the same worksheet.

e.g.

C1-----------C2----------C3
1256--------1125--------not present
1344--------1356--------present
1356--------1455--------not present
1526--------1256--------present

u can see that some numbers in the two column are similar. How do i
sort them out and put a label beside that in the next column. I want
numbers in column 2 to be checked with column1.
Can anyone help, please?

Thanks a lot
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

compare and find similar numbers in two columns 1
comparing two columns in vba 2
Incrementing Numbers ? 3
Matching two columns of data 2
Sum Values from different column 1
Formula for transferring data in rows to columns on two different Worksheets 1
counting number of columns 1
Need to have data in one column 1

Top