Keep the first the last occurrences in column data

  The range of column data contains repeated values for which I want to find a formula to keep the first and last occurrences of the repeated values and remove the ones in between. I attach snapsho...