Hi all,
Hope all is good.
Can anyone please help me with my problem which is 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. But in actual, there are 1000's of rows which are to be done.
I have highlighted the value A2 in red.
Reason being, I need only those values which are to the left of value A2 and including A2 as shown in the column 'C' (Output).
I don't need any of the values which are to the right of value A2. 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 how can I do it in an efficient manner instead of entering manually for each and every row?
Thank you all for your attempt and many Thanks in advance for your suggestions.
Bookmarks