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
Bookmarks