Repeated number and multiple results

Solved/Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

Want to know i have two columns in excel, sheet 1
Column 1 - date
Column 2 - Unique number

Now, dates are not given in a customised format (3rd September may come before 23rd August).

Second sheet contains date in a customized format with around 10 rows for single date (1-sep-2010 is repeated in 10 rows in a line).

I want that the unique number for each date should come in a customised format in sheet two, that is if 1-sep-2010 is there 5 times in sheet 1 then the unique number should come in a proper line in front of the given date.

Have tried with VLOOKUP but it given the unique number present in the 1st row only, it does'nt capture the other numbers given below opposite to same date.

Thanks in advance for help...


1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
there are many ways of doing this . There is even a complex formula but it may be difficult to modify it to suit your need. However I have parked a sample data sheet in the web page given below

http://www.speedyshare.com/files/24163155/sandeep.xls



the data is from A1 to B7
the macros are in vb editor module1

your have to run only the macro "finalmacro" . But all three macros must be parked in the module.

the results are in columns G,H,I.
for rechecking remove all the results except the data A1:B7. and rerun finalmacro