fill array with dates unique value

sal21

Active Member
Joined
Apr 1, 2002
Messages
291
I need to insert into array a unique value based a date

I loop with the for next a value in a column A.
All value are date in this format dd/mm/yyyy hh:mm

for example:
...
03/02/2001 12.14
01/01/2001 12.23
01/01/2001 05.11
03/02/2001 06.11
01/01/2001 03.10
...

i need to fill array only with the value most little from the same date

in this case array:
01/01/2001 03.10
03/02/2001 06.11

i hope understand me...
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
I need to insert into array a unique value based a date

I loop with the for next a value in a column A.
All value are date in this format dd/mm/yyyy hh:mm

for example:
...
03/02/2001 12.14
01/01/2001 12.23
01/01/2001 05.11
03/02/2001 06.11
01/01/2001 03.10
...

i need to fill array only with the value most little from the same date..

*******************************

if is most simple i post my question on other side:
Admitting i loop the series of value with a for next how to fill combobox items with the value marked with < - Selected

In effect i need to fill the items oin combo with the dates vale with the oldest time

01/01/2011 05.00.11 <- Selected
01/01/2011 19.00.14
01/01/2011 21.21.11
02/01/2011 05.00.02 <- Selected
03/01/2011 01.00.03 <- Selected
03/01/2011 12.17.21
03/01/2011 18.00.27

i hope understand me...
 
Upvote 0

Forum statistics

Threads
1,224,521
Messages
6,179,277
Members
452,902
Latest member
Knuddeluff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top