How to generate list of items with same status over three or moresuccessive days

[AA Arens]

I would like to ask the community to help me with the following case.

We do have a vehicle tracking business and need to monitor vehicle
status every day.

We are looking for a way to get a list on a daily basis of vehicles
that has their status not changed over three days.

Columns of the feeder:
Date VehicleNr Status (consider A, B, ..., F)

The idea is to add the feeder on a new sheet, so comparison will be
over more sheets.

Columns of generated list of vehicles with same status over more then
three days:
VehicleNr Status

List generation on the same sheet that is refreshed daily.

The list generation will be done on a daily bases after added the
latest status from that day.

Wat it may make it complicated is that the list may be changed,
vehicles are added or deleted, so I think the script should be
generic.

Bart, Excel 2003.

 

[Don Guillett]

I would like to ask the community to help me with the following case.

We do have a vehicle tracking business and need to monitor vehicle
status every day.

We are looking for a way to get a list on a daily basis of vehicles
that has their status not changed over three days.

Columns of the feeder:
Date VehicleNr Status (consider A, B, ..., F)

The idea is to add the feeder on a new sheet, so comparison will be
over more sheets.

Columns of generated list of vehicles with same status over more then
three days:
VehicleNr Status

List generation on the same sheet that is refreshed daily.

The list generation will be done on a daily bases after added the
latest status from that day.

Wat it may make it complicated is that the list may be changed,
vehicles are added or deleted, so I think the script should be
generic.

Bart, Excel 2003.

Hard to say without seeing. Send your file WITH a compete explanation
and examples to dguillett1 @gmail.com

 

[dave y.]

I would like to ask the community to help me with the following case.

We do have a vehicle tracking business and need to monitor vehicle
status every day.

We are looking for a way to get a list on a daily basis of vehicles
that has their status not changed over three days.

Columns of the feeder:
Date VehicleNr Status (consider A, B, ..., F)

The idea is to add the feeder on a new sheet, so comparison will be
over more sheets.

Columns of generated list of vehicles with same status over more then
three days:
VehicleNr Status

List generation on the same sheet that is refreshed daily.

The list generation will be done on a daily bases after added the
latest status from that day.

Wat it may make it complicated is that the list may be changed,
vehicles are added or deleted, so I think the script should be
generic.

Bart, Excel 2003.

At some point it's not really a technical question, you just
have to sit down, lay it out and do the work!

)

dave y.

 

[AA Arens]

At some point it's not really a technical question, you just
have to sit down, lay it out and do the work!

  )

dave y.

Hi Don, your email seems to be invalid.