+ Reply to Thread
Results 1 to 5 of 5

List cars on the road

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    List cars on the road

    Look B into E , if not found list them on H

    I can do this by vlookup , can I want it this way

    The expected results should be as follows regardless the order

    T211CLR #N/A
    T278BVA #N/A
    T320CBX #N/A
    T407CUY #N/A
    T494BWD #N/A
    T532CLE #N/A
    T637DFR #N/A
    T661DNR #N/A
    T806DDS #N/A
    T266BKK #N/A
    T411CZS #N/A
    T641BVE #N/A
    T655BTE #N/A
    T678BCD #N/A
    T406BFX #N/A
    T407BGZ #N/A
    T446BJS #N/A
    T532AWW #N/A
    T701BSQ #N/A
    T892AZV #N/A
    T940BPA #N/A
    T124DCZ #N/A
    T667AQF #N/A
    T797DEL #N/A
    T952BHW #N/A
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: List cars on the road

    It is like a PLUS MINUS of plate numbers , mention only what is not on the list

  3. #3
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: List cars on the road

    Find attached results on H manually plugged results from Vlookup and then sort , sort not important
    Attached Files Attached Files

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: List cars on the road

    VBA solution.
    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  5. #5
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: List cars on the road

    Thank you bakerman2 , exactly what i needed

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. excel template for cars reservation
    By cristines in forum Excel General
    Replies: 2
    Last Post: 02-14-2017, 11:32 AM
  2. Using Excel to log hired cars
    By rossf1uk in forum Excel General
    Replies: 3
    Last Post: 05-06-2016, 07:40 PM
  3. Get existing cars from a list
    By Immortal2014 in forum Excel General
    Replies: 6
    Last Post: 04-29-2016, 04:27 PM
  4. [SOLVED] Auto fill last km of cars
    By Immortal2014 in forum Excel General
    Replies: 7
    Last Post: 04-28-2016, 12:16 PM
  5. Days cars are at garage + 1 incremental
    By carolineI in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-09-2014, 06:48 AM
  6. [SOLVED] Avoid search with wild cars **
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-02-2014, 11:18 AM
  7. customerfollowup for cars sales
    By joanne panzo in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 06-13-2006, 08:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1