Hello everybody, and happy to be here
I am trying to identify a specific correct order for a list of companies (if they are in a correct order then no action should be taken, and if they are not in a correct order then they should be identified and marked as such). I have attached a file. The companies which have the correct order in my example are marked in green.
The 'order' is numbered from 1-6. In my example, should a company have an 'order' number assigned to it higher than any of the 'order' numbers assigned to the same company previously (in the rows above) then everything is OK.
Should a company have an 'order' number assigned that is lower than any of the 'order' numbers assigned to the same company previously (in my example company XYZ has 2 assigned on rows 11 and 12 where previously it had assigned a 3 on row 10) then the lines should be identified - I only need the lines which are not in order to be marked, not modified. I do not need a new order. All the lines marked in red on column C from my example should be marked preferably.
Thank you in advance to whomever may answer this, it's been boggling my head for a while.
Bookmarks