Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas for telephone numbers: finding duplicates, autoformat | Excel Worksheet Functions | |||
MATCH function - 2 columns w/ SIMILAR, not EXACT data | Excel Worksheet Functions | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
finding common numbers in large lists | Excel Worksheet Functions |