Student

Hi, 

hoping this finds you well. Kindly see the table below, I have some excel data below

 

Vehicle

DEFECT

Date

KAB 336D

Oil Leak

3-Jan-18

KAC 340C

Overheating

3-Jan-18

KBJ 380J

Failing Brakes

6-Jan-18

KBJ 380J

Overheating

2-Jan-18

KBJ 380J

Failing Brakes

11-Jan-18

KAB 336D

Oil Leak

10-Jan-18

KAB 336D

Failing Brakes

10-Jan-18

KAB 336D

Failing Brakes

11-Jan-18

KAC 340C

Oil Leak

12-Jan-18

KBJ 380J

Failing Brakes

10-Jan-18

KBJ 380J

Overheating

12-Jan-18

KAB 336D

Oil Leak

12-Jan-18

KBJ 380J

Overheating

14-Jan-18

 

 

 

   I wish to create a function or VBa code that can return the following Data in a new excel Sheet. Kindly note that this is just sample data, the defects vary and are more than 10, I wish to track the Recurring Defects for Each Fleet.

the result should appear or atmost Return as

 

Vehicle

Defect

Dates

KAB 336D

Oil Leak

3-Jan-18

10-Jan-18

12-Jan-18

 

 

KAB 336D

Failing Brakes

10-Jan-18

11-Jan-18

 

 

 

KBJ 380J

Failing Brakes

6-Jan-18

11-Jan-18

 

 

 

KBJ 380J

Overheating

12-Jan-18

14-Jan-18

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

By: Mark

12 thoughts on “Student

  1. kyrie 4

    I found your weblog website on google and check a number of of your early posts. Continue to maintain up the very good operate. I simply further up your RSS feed to my MSN News Reader. Seeking ahead to reading more from you afterward!?

  2. off white clothing

    Oh my goodness! an incredible article dude. Thanks However I’m experiencing concern with ur rss . Don抰 know why Unable to subscribe to it. Is there anyone getting identical rss drawback? Anyone who is aware of kindly respond. Thnkx

  3. http://tinyurl.com

    Hi would you mind sharing which blog platform you’re working with?
    I’m going to start my own blog soon but I’m having a tough time choosing between BlogEngine/Wordpress/B2evolution and Drupal.
    The reason I ask is because your design and style seems
    different then most blogs and I’m looking for something completely unique.

    P.S Apologies for getting off-topic but I had to ask!

  4. golden goose

    There are certainly a variety of details like that to take into consideration. That may be a nice point to carry up. I offer the ideas above as normal inspiration but clearly there are questions like the one you deliver up the place an important thing will probably be working in honest good faith. I don?t know if finest practices have emerged round issues like that, however I am certain that your job is clearly recognized as a good game. Both girls and boys really feel the impact of only a moment抯 pleasure, for the rest of their lives.

  5. vans shoes

    Good post. I be taught one thing tougher on completely different blogs everyday. It’s going to always be stimulating to learn content material from other writers and apply a bit something from their store. I抎 choose to make use of some with the content on my weblog whether or not you don抰 mind. Natually I抣l offer you a link on your net blog. Thanks for sharing.

  6. westbrook shoes

    When I originally commented I clicked the -Notify me when new feedback are added- checkbox and now each time a comment is added I get 4 emails with the same comment. Is there any way you can remove me from that service? Thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *