Hope all is good.
Can anyone please help me with any of the solution for my requirement as explained below ?
Please see attached, the excel file for better understanding of my question.
In the column 'B' (Sequence), there are certain values and just for my explanation, I have considered just 25 rows.
I have highlighted few of the values in red colour in column 'B'.
Reason being, I need only those values which are to the left of highlighted value and including the highlighted one as well as shown in the column 'C' (Output).
I don't need any of the values which are to the right of highlighted value. It has to be deleted from Column 'C'.
Is there any option (Formula or anything) where I can reduce my time ?
Can anyone please suggest me on how I can do it in an efficient manner instead of entering manually for each and every row?
I need only the values which are to the left of highlighted value in red colour and including the red colour one. The one that are to the right of highlighted value must not be there in the output.
Thank you all for your efforts and many Thanks in advance for your suggestions.