Hi I have a worksheet as illustrated below:
___Date/Time________Date____Code_
18-10-2011 07:00 _ 18-10-2011 _ 1
18-10-2011 09:00_____________ 2
18-10-2011 10:00_____________ 6
19-10-2011 08:30 _ 19-10-2011 _ 5
19-10-2011 09:45_____________ 4
20-10-2011 12:30 _ 20-10-2011 _ 1
20-10-2011 13:30_____________ 2
20-10-2011 15:45_____________ 1
21-10-2011 09:30 _ 21-10-2011 _ 3
21-10-2011 12:30_____________ 2
The first column (A) is used for time calculations
Column B and C are used as a user interface where column A is hidden
I want to find the first row in which the date 19-10-2011 occurs in either column A or B, is this possible?
And is it possible to find the last row in which the date 20-10-2011 occurs in either column A or B?
Thanks in advance ;-)
Freakazoid
Bookmarks