Help with IF statement returning first instance of a value

Question

I have one super long excel sheet that contains multiple identical files combined , one after another. There is a field at the end of the entire sheet that has the original file date (example - it displays August 2nd for about the first 300 lines and then starts displaying August 3rd when the next file's data begins etc. all the way up to August 31). In column B, I have a value called "Baskets". This value occurs multiple times not only within the entire sheet but within each individual set of data from each date. I would like to write an IF statement for a new column that looks at the first instance the word "Basket" occurs within each file date and returns a corresponding value. How would I go about that?

AngelosPachis · Answer

Hey @MJ54 ,

Although I'm not quite sure what your input looks like or what's the desired output, I put together a sample workflow as a proof of concept of how you can flag the first occurrence of the Basket word for each date.

Hope that's what you're after.

Cheers,

Angelos

example.yxmd

MJ54 · Answer

I unfortunately cannot as it is sensitive data. Please let me know if I can answer any other queries.

Tyro_abc · Answer

Would you mind sharing the sample data?

Best Regards

Arundhuti