Forum Discussion
Solved
PARKING TICKET LOG HELP Please and Thank You!!
I have a log of parking ticket data. I would like to have a list of tickets that have been issued to the same vehicle plate number. In other words, have a row copy onto a new tab if there is a duplicate listed in one column of the log. If possible, also have the data only pulled if it is from the past 12 months/year.
You can try Power Query. In the blue dynamic table you can add data. Then you can click in any cell in the green table, right-click with the mouse and refresh.
Ticket # Issued Date Location Time Plate# Vehicle Make/Model Photo on File Ticket Writer Off-Duty $ Ticket Amount $ Voided Reason Priors (P) or (NP) Pmt. Date $ Pmt. Amount $ Notes 10103 01/05/21 3224 Lower Lot 1245 BUR1234 Honda Civic $20.00 10104 01/06/21 KBT #34 855 209123 Toyota Prius $20.00 10105 01/07/22 KBT #51 900 BCB1234 BMW XI $20.00 You can try Power Query. In the blue dynamic table you can add data. Then you can click in any cell in the green table, right-click with the mouse and refresh.
