Editing xls is fast and simple using DocHub. Skip downloading software to your laptop or computer and make adjustments with our drag and drop document editor in a few quick steps. DocHub is more than just a PDF editor. Users praise it for its efficiency and robust features that you can use on desktop and mobile devices. You can annotate documents, generate fillable forms, use eSignatures, and deliver records for completion to other people. All of this, put together with a competing price, makes DocHub the perfect decision to faint motif in xls files effortlessly.
Make your next tasks even easier by converting your documents into reusable web templates. Don't worry about the security of your information, as we securely store them in the DocHub cloud.
so most people think this canamp;#39;t be done in Excel but the problem is theyamp;#39;re using the wrong approach so here we have a list of names and skills and we want to know which people have video as a skill but we donamp;#39;t want to say if itamp;#39;s equal video we want to check if it includes the word video so most people do this they start with a filter function then select what they want returned for include theyamp;#39;re going to check whether this range here equals video now the problem is this is not going to work why well because youamp;#39;re using wild cards right you need to use asterisks in there oh thatamp;#39;s not going to work either because thatamp;#39;s also the wrong approach Asterix does not work with the filter function hereamp;#39;s what you need to do instead for the include argument youamp;#39;re going to start with is number then youamp;#39;re going to use search the text you want to find is video the text that youamp;#39;re searching in is