Hi guys,
In 'Sheet 1' of the sample workbook are a list of products i receive on a daily basis.
Cols D & E are partially filled and i have to manually fill the blanks.
Up to now I've been doing this by using the Data Filter on Col C and using the 'if text contains' and if cells in Col D are blank, filter.
So if the text in Col C contains *book* then Col D is 'Computers' and Col E is 'Notebooks
So if the text in Col C contains *desk* then Col D is 'Computers' and Col E is 'Desktops'
So if the text in Col C contains *MFP* then Col D is 'Printing' and Col E is 'Printers - Multifunction'
So if the text in Col C contains *mono* then Col D is 'Printing' and Col E is 'Printers - Laser (Mono)'
So if the text in Col C contains *monitor* then Col D is 'Monitors' and Col E is 'Monitors'
Any remaining blank cells are filled with Col D 'Misc' and Col E 'Others'
Sheet 2 shows the completed file
Any assistance in getting this sorted would be very much appreciated and a real time saver
Regards
John
Bookmarks