I have 10 columns into which the numbers 1 to 4 (based on grades from elsewhere) are called into. The right hand columns may not yet have data in them and are therefore showing zero. The same number can appear more than once. I would like to show the last 3 (or fewer if less than 3) of these in a single cell in Column 11. For instance 1, 1, 2, 3, 2, 0, 0, 0, 0 ,0 would become 232; 1, 4, 0, 0, 0, 0, 0, 0, 0 ,0 would become 14; 1, 1, 2, 3, 2, 4, 3, 1, 2 ,3 would become 123.

Are you able to help please?