According to what you helped me with last time, I encouter I new issue, it’s that sometimes, there isn’t all the values. When I try with your code, I get an error as it can’t find the other values, is there anyway to make it that if doesn’t find on the values, takes the following as recurrent value ? Many thanks
I’m sorry for the late response, the dictionary is filled manually as u showed me previously as a build data table.
The values are retrieved from an excel file, the same onces are stored on the dictionary, but sometimes not all the files contains all the values stored in the dictionary. Which leads to an error as the key was not present in the dictionary.
If the values which are missing are in the end of the dictionary, it shows no error, but if it’s in the middle, it give me the error as key was not present
lets assume data: North,West,South,East, South-East
Lets Assume Custom Sort order: North=1,West=4,South=3,East=2
South-East is unknown for the search order
Where to place South-East?
On End: North,East,South,East, South-East
On Start: South-East,North,East,South,East,