is there a way to get the last sales consultant assigned to a customer account that does not have a sales consultant assigned right now?

via search of system notes you might. You can filter by record (customer), old value (not empty) and new value (empty)

but what if it was assigned to multiple reps over time