+ Reply to Thread
Results 1 to 6 of 6

Check if a taxi was used or not from the list of rides

  1. #1
    Registered User
    Join Date
    07-30-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    3

    Question Check if a taxi was used or not from the list of rides

    Hello there !

    First of all, thanks for trying to help me.

    I got a long list with nearly 3000 rows with all the rides that taxis made during a month and I need to create a table that shows which dates the taxis were used or unused.

    I tried using IF with COUNT/MATCH or IFNUMBER/SEARCH but I can't get what I need because in the list I have the same taxi mentioned many times on different rides on the same day but I only need to check if it was used during the day at least one time or not.

    I attach an extract of the list that I have and an "example" of what the output could be (writing "X" if the car was used that day). Hopefully you can help me !

    Thaaanks
    Attached Files Attached Files

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Check if a taxi was used or not from the list of rides

    Here!

    Put this in F2 and drag down and across -

    Please Login or Register  to view this content.
    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

    Note: Currently the formula assumes Trips of only 1 day..
    Last edited by NeedForExcel; 07-30-2015 at 07:25 AM.
    Cheers!
    Deep Dave

  3. #3
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Check if a taxi was used or not from the list of rides

    And this one will take care of Trips of more than 1 day too -

    Please Login or Register  to view this content.
    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

  4. #4
    Registered User
    Join Date
    07-30-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    3

    Re: Check if a taxi was used or not from the list of rides

    Thank you very much !

    I have been trying both formulas you gave me but for some reason I don't get the "X"s. I followed your instruction and I see the curly braces {} around the formula.

    Don't know what am I doing wrong...

  5. #5
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Check if a taxi was used or not from the list of rides

    Hi,

    Please see the file attached..

    I have incorporated the formula from Post #3 in the file..
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    07-30-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    3

    Re: Check if a taxi was used or not from the list of rides

    Awesome !

    I really do not know why mine was not working. Now I am trying to implement this formula in the long list I have.

    If now I have 2610 rows and I want to check the month of July 2015, should be like this?

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Sorry for asking so much, I really appreciate your help !

+ 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. Replies: 0
    Last Post: 06-27-2014, 04:16 PM
  2. Replies: 1
    Last Post: 12-14-2012, 10:11 AM
  3. Mileage tariffs for a taxi
    By tomkilbourn in forum Excel General
    Replies: 21
    Last Post: 07-23-2009, 10:10 AM
  4. Testing two conditions, one over rides the other?
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2007, 02:26 PM
  5. taxi driver accounts template
    By Dave in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-06-2006, 07:25 AM
  6. Essbase over-rides basic Functionality?
    By bflicker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2006, 03:45 AM
  7. Taxi scheduling database using Excel?
    By WTAMadison in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2005, 05:10 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