Hi Everyone!
I have attached an excel workbook which contains two sheets named "before" and "after" respectively. The "before" sheet contains the sample data to work with and "after" sheet is the desired output for few entries in "before" sheet for the sake of example. Coming to my question, The "before" sheet contains some comma separated values. Each Comma separated value contains the shipping cost in dollar and the term either "available" or "not available". I want find out the lowest possible shipping cost out those comma separated values which contain the word "available" . Here we would ignore those comma separated values which contain the word "not available" and its of no use to use. I have attached the work book and you can easily understand by check it.
Again many thanks in advance![]()
Bookmarks