Foncesa
06-21-2013, 02:09 PM
Hi,
Can someone please help me how to create a VBA Program to Compare Column in Excel (in my case its Column D 'Name')
First it will compare the Names and then change there Unique No. because they are different, based on Reference (Column 'B') with priorty basis.
For Example.
Case 1. The Column B has two different References for the same Name (Column D) then Unique No. of 1001 will be set for 1002.
Case 2. The Column B has three different References for the same Name (Column D) then Unique No. of 2001 will be set for 1001 & 1002.
Case 3. The Column B has two different References for the same Name (Column D) then Unique No. of 3001 will be set for 3003.
Case 4. The Column B has three different References for the same Name (Column D) then Unique No. of 2001 will be set for 2003 & 2009.
Case 5. The Column B has three different References for the same Name (Column D) then Unique No. of 1001 will be set for 3001 & 3003.
Please let me know how to solve this, I have attached the sample file along with Output, Some one please help me because I have very big data to modify.
Can someone please help me how to create a VBA Program to Compare Column in Excel (in my case its Column D 'Name')
First it will compare the Names and then change there Unique No. because they are different, based on Reference (Column 'B') with priorty basis.
For Example.
Case 1. The Column B has two different References for the same Name (Column D) then Unique No. of 1001 will be set for 1002.
Case 2. The Column B has three different References for the same Name (Column D) then Unique No. of 2001 will be set for 1001 & 1002.
Case 3. The Column B has two different References for the same Name (Column D) then Unique No. of 3001 will be set for 3003.
Case 4. The Column B has three different References for the same Name (Column D) then Unique No. of 2001 will be set for 2003 & 2009.
Case 5. The Column B has three different References for the same Name (Column D) then Unique No. of 1001 will be set for 3001 & 3003.
Please let me know how to solve this, I have attached the sample file along with Output, Some one please help me because I have very big data to modify.