Forum Discussion
Fill blank values based in the next/last value
Hi, everyone! I need some help, please. I need to fill the blank values with the next (or last) License Plate value: This is what I have: Date License Plate Value 01/07/2022 ABC12...
Ashish_Mathur
Super User
Super UserHi,
I do not see any logic in your solution. If you paste this data in an MS Excel file, then why should there not be K99 in cell C14 (why are yuo showing D99 there). This is just one that i noticed - there could be more as well. Please review all and clarify.
If the first value of a car is empty I need to get the value below instead of the value above
That's what happens to C13 cell: