Hi,
I am happy that it worked for you.

Note: Having different formulas on different rows (in the same column) is something I would strongly recommend to avoid. Sooner or later there will be a mistake, and it is also very difficult for others (and you) to see how it works.

Depending on how your data is structured, like how many different offers do you have, are there overlapping offers (two different offers connected to the same part), how many part numbers do you have in total (with and without offers) there are different solutions.

If you give me more information I can recommend the best solution for your situation. The more exact info you give, the better answer you will get

Regards
Bjorn