Finding similar data or numbers in two columns
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 -- sayemasof ------------------------------------------------------------------------ sayemasof's Profile: http://www.excelforum.com/member.php...o&userid=23947 View this thread: http://www.excelforum.com/showthread...hreadid=375743 |
Take a look he
http://cpearson.com/excel/duplicat.htm In article , sayemasof wrote: 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 |
All times are GMT +1. The time now is 06:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com