Failure rate after service

[ZoNe747]

Good morning,

I have been asked to create a report which looks at when a machine has a call come in after a service. so for example it would need to look like:

A1: Site Name
B1: machine number
C1: Date of last service
D1: the date of the next failure from a selected list.
E1: an auto sum that I will put in once D1 is completed.

The problem is a Vlookup wont cut it at there are over 50 thousand fields and I am not sure where to begin. My knowledge in VBA is starting to grow but I need more practice.

Any help you can give would be amazing!

 

[ZoNe747]

Thank you for trying but it does not seem to have worked.

At first I thought it had because it did produce a number of dates
[TABLE="width: 600"]
<tbody>[TR]
[TD="class: xl69, width: 189"]Customer 1[/TD]
[TD="class: xl68, width: 132, align: right"] 01-Aug-2013 11:01 [/TD]
[TD="class: xl67, width: 64, align: right"]11468872[/TD]
[TD="class: xl72, width: 96, align: right"]30/07/2014[/TD]
[TD="class: xl70, width: 119, align: right"]363.18

[/TD]
[/TR]
</tbody>[/TABLE]

This would look as if the machine has not had a breakdown for almost a year. When I went to check the other sheet it has shown alot more calls appearing in-between those dates.
[TABLE="width: 196"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]11468872[/TD]
[TD="align: right"] 30-Jul-2014 15:18[/TD]
[/TR]
[TR]
[TD="align: right"]11468872[/TD]
[TD="align: right"] 28-Jul-2014 11:01[/TD]
[/TR]
[TR]
[TD="align: right"]11468872[/TD]
[TD="align: right"] 28-Apr-2014 9:21[/TD]
[/TR]
[TR]
[TD="align: right"]11468872[/TD]
[TD="align: right"] 18-Feb-2014 7:07[/TD]
[/TR]
[TR]
[TD="align: right"]11468872[/TD]
[TD="align: right"] 11-Feb-2014 14:35[/TD]
[/TR]
[TR]
[TD="align: right"]11468872[/TD]
[TD="align: right"] 09-Feb-2014 8:34[/TD]
[/TR]
[TR]
[TD="align: right"]11468872[/TD]
[TD="align: right"] 17-Dec-2013 13:11[/TD]
[/TR]
[TR]
[TD="align: right"]11468872[/TD]
[TD="align: right"] 22-Oct-2013 9:41[/TD]
[/TR]
[TR]
[TD="align: right"]11468872[/TD]
[TD="align: right"] 16-Sep-2013 15:21[/TD]
[/TR]
[TR]
[TD="align: right"]11468872[/TD]
[TD="align: right"] 30-Aug-2013 7:08[/TD]
[/TR]
</tbody>[/TABLE]

 

[Andrew Poulsom]

Can't you sort Sheet2 by date ascending? The formula returns the first item that's greater than the Service Date.

 

[ZoNe747]

And there we go. I was overcomplicating it then. Thank you so much for your help!