Filtering repeating values in excel join datatable

here is the confusion
grafik

as a duplicated group eg 15.07 has 4 or maybe more members

So we would recommend to rewrite the requirements from

to

  • when a cost unit occurs in a subsequent series then take from the series the last
  • when a cost unit line doesnt have direct following row with the same cost unit, then block it

just check the requirement and when it is ok, then we renter the solution option check phase