Forum Discussion
Solved
Finding Values if they historically exist
Good Morning, Not sure how to phrase this so will give it my best shot. Below is a table that shows this vehicle was on hire with lic number 2888 4 times but there was some other lic numbers...
i Got it working in excel in the end.
I found the last time the licence was used prior to the current and then coutn how many (if any) ither records there were in between, if none then didnt flag it if there was then i flagged it.
i Got it working in excel in the end.
I found the last time the licence was used prior to the current and then coutn how many (if any) ither records there were in between, if none then didnt flag it if there was then i flagged it.