Enumerating the possibilities correctly via VBA code behind Excel was not too difficult, but correctly…