Hello,

Suppose if models don't repeat and entire column B in my sheet is filled with unique models only. Does that get easier then? I will remove duplicate models. in attached sheet there are no duplicate models in column B. is it possible to sort using code by company and then just fetch the models? Only problem is that this sheet gets updated frequently and new models get added at the bottom of the sheet on daily basis. Old models get deleted too.