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

39 thoughts on “Student

  1. ig

    I’m not that much of a online reader to be honest but your
    sites really nice, keep it up! I’ll go ahead and bookmark your website to come back down the
    road. All the best

  2. nike air max 2017

    My spouse and i have been now peaceful when John managed to deal with his homework through the entire precious recommendations he discovered while using the web site. It is now and again perplexing just to continually be freely giving secrets that many people might have been selling. So we already know we’ve got the website owner to thank because of that. The main explanations you have made, the straightforward website menu, the friendships you will help create – it’s many excellent, and it’s assisting our son and us feel that the theme is cool, which is really serious. Thank you for the whole lot!

  3. nike lebron 17

    I wish to show some thanks to you for bailing me out of such a crisis. As a result of browsing through the search engines and getting strategies that were not powerful, I believed my life was over. Living without the presence of strategies to the issues you have solved as a result of your main guideline is a serious case, and ones which might have adversely affected my career if I had not noticed your web page. Your good talents and kindness in playing with all the things was vital. I don’t know what I would’ve done if I hadn’t discovered such a solution like this. I am able to at this time look forward to my future. Thank you very much for this skilled and effective guide. I won’t hesitate to suggest your site to any person who should get recommendations on this area.

  4. nike vapormax

    I wanted to write you the very small note in order to say thank you once again considering the nice strategies you’ve documented in this article. It’s certainly wonderfully open-handed of people like you to allow freely all a few individuals could have sold as an e book in making some cash for themselves, precisely now that you might have done it in case you decided. Those ideas likewise acted to become a easy way to understand that other individuals have a similar interest much like my own to see a great deal more regarding this condition. Certainly there are a lot more fun sessions ahead for individuals that find out your website.

  5. yeezy 500 blush

    I happen to be commenting to let you know what a fabulous encounter my friend’s princess undergone reading your site. She realized a good number of pieces, including what it’s like to possess a very effective giving mindset to get other folks without problems learn selected grueling subject areas. You actually exceeded visitors’ desires. Thanks for rendering these essential, dependable, edifying not to mention easy guidance on your topic to Gloria.

  6. Danny Grotz

    Thank you a lot for sharing this with all folks you really understand what you’re speaking about! Bookmarked. Please additionally consult with my site =). We can have a hyperlink alternate agreement between us!

  7. sling tv

    Hello to every body, it’s my first pay a visit
    of this blog; this weblog carries amazing and really good information in favor of visitors.

  8. hermes belt

    I not to mention my pals were found to be reading through the good tips and tricks located on the website and the sudden I got an awful suspicion I never expressed respect to the web site owner for those strategies. These young men came absolutely thrilled to learn them and already have pretty much been making the most of them. Thanks for really being quite kind and for settling on variety of awesome areas millions of individuals are really wanting to know about. Our own sincere apologies for not expressing appreciation to you earlier.

  9. yeezy 700

    I must show my gratitude for your generosity in support of those people who actually need help on the question. Your real commitment to getting the solution all through turned out to be exceedingly good and have regularly made people much like me to attain their endeavors. Your own invaluable guideline denotes this much a person like me and much more to my office workers. With thanks; from each one of us.

  10. balenciaga

    I wanted to post you this bit of note to finally give thanks over again considering the great information you’ve documented on this site. It has been really remarkably generous with you to provide extensively just what numerous people would’ve distributed as an e book to help make some cash for themselves, primarily considering that you could have tried it in the event you wanted. The strategies as well served as a great way to be sure that other individuals have the identical zeal the same as my very own to realize a great deal more when it comes to this issue. I know there are numerous more pleasant occasions up front for many who looked at your site.

  11. supreme hoodie

    I not to mention my guys ended up studying the nice solutions from the blog and before long came up with a terrible suspicion I had not expressed respect to the web blog owner for those secrets. These young men happened to be as a consequence joyful to see them and already have honestly been loving those things. Appreciate your being quite helpful and also for picking these kinds of ideal guides millions of individuals are really desperate to know about. My honest regret for not saying thanks to earlier.

  12. sling tv

    Hi, I do believe this is a great website.

    I stumbledupon it 😉 I may return once again since i have book marked it.
    Money and freedom is the greatest way to change,
    may you be rich and continue to help others.

  13. golden goose outlet

    I would like to show some thanks to this writer for bailing me out of such a instance. As a result of researching through the world-wide-web and finding methods that were not helpful, I was thinking my entire life was done. Existing without the strategies to the problems you have fixed all through the guide is a critical case, and the kind which might have in a negative way damaged my entire career if I hadn’t discovered your web site. The training and kindness in taking care of all areas was vital. I don’t know what I would have done if I had not come upon such a step like this. It’s possible to at this point relish my future. Thanks a lot so much for this impressive and result oriented guide. I will not hesitate to endorse your web site to anybody who ought to have recommendations on this topic.

  14. lebron 16

    My spouse and i got so more than happy that Ervin managed to finish up his reports because of the ideas he discovered out of your blog. It is now and again perplexing just to be offering tips and tricks which often the rest have been making money from. So we understand we now have you to appreciate for that. Those illustrations you made, the simple site menu, the friendships you can aid to instill – it’s most excellent, and it is facilitating our son in addition to the family reckon that that idea is entertaining, which is certainly highly essential. Many thanks for the whole thing!

  15. balenciaga shoes

    I actually wanted to write down a simple message to be able to appreciate you for these stunning tips and hints you are placing here. My time-consuming internet look up has at the end been recognized with extremely good tips to exchange with my family and friends. I ‘d state that that most of us visitors are really endowed to dwell in a fine community with very many marvellous professionals with very helpful principles. I feel very happy to have encountered the webpages and look forward to plenty of more fun times reading here. Thank you once again for everything.

  16. http://tinyurl.com/sling-tv-45840

    This is the perfect web site for anyone who would like to find out about
    this topic. You understand so much its almost tough
    to argue with you (not that I really will need to…HaHa).
    You definitely put a new spin on a topic that’s been discussed for ages.
    Great stuff, just great!

  17. asksylphoflight.tumblr.com sling tv

    Hi there! This post could not be written any better!
    Reading through this post reminds me of my previous roommate!

    He continually kept talking about this. I’ll send this information to him.
    Pretty sure he’ll have a good read. Thanks for sharing!

  18. sling tv

    Please let me know if you’re looking for a article author for your weblog.
    You have some really great articles and I feel I would be a good asset.
    If you ever want to take some of the load off, I’d really like to write some material for your blog in exchange for a link back to mine.

    Please shoot me an e-mail if interested. Kudos!

  19. plenty of fish vs match.com free trial

    First of all I would like to say terrific blog!
    I had a quick question that I’d like to ask
    if you don’t mind. I was interested to know how you center yourself and clear your head before writing.
    I’ve had difficulty clearing my thoughts in getting
    my thoughts out there. I do take pleasure in writing but it just seems
    like the first 10 to 15 minutes tend to be lost just trying to figure out how to begin. Any ideas or tips?

    Thanks!

  20. jordan shoes

    My husband and i ended up being very delighted Michael managed to complete his preliminary research with the precious recommendations he discovered through the site. It is now and again perplexing just to happen to be offering helpful tips which often people today may have been selling. We really know we’ve got you to appreciate for that. The main illustrations you have made, the easy website menu, the friendships your site give support to create – it is most wonderful, and it is letting our son in addition to the family do think this subject matter is exciting, which is pretty indispensable. Thank you for all!

  21. balenciaga shoes

    I am just commenting to let you understand what a fantastic encounter our girl obtained viewing your site. She noticed a wide variety of pieces, most notably what it is like to have a wonderful helping nature to make men and women with no trouble learn several tricky topics. You really did more than our own expected results. Many thanks for producing the powerful, trustworthy, edifying and even fun tips about your topic to Ethel.

  22. ps4 games

    obviously like your web site however you have to take a look at the spelling on quite a few of your
    posts. Many of them are rife with spelling problems and I find
    it very troublesome to tell the reality however I’ll certainly come
    again again.

  23. quest bars cheap

    Have you ever considered about including a little bit more than just your articles?
    I mean, what you say is important and everything.
    However think about if you added some great pictures or videos to give your posts more, “pop”!

    Your content is excellent but with pics and video clips,
    this blog could undeniably be one of the most beneficial in its niche.

    Excellent blog!

  24. ps4 games

    Hi there, just became alert to your blog through Google, and found that it’s really informative.
    I’m gonna watch out for brussels. I will be grateful if
    you continue this in future. Numerous people will be
    benefited from your writing. Cheers!

  25. 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!

  26. 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.

  27. 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.

  28. 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!

  29. 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

  30. 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!?

Comments are closed.