Hi,
I just want to know if it is possible to search data in Excel in any order.
For instance, in cell A1, I have the product "10 mm Clear Saudia". If I hit Control + F, I have to search for "Saudia" or "Clear" or "Clear Saudia" to find the product.
I was wondering if there is a way if I type "Saudia Clear" and it would still find the product for me. This is because most of the time I do not remember the exact product names but do remember certain key words related to the product. Most of the time I can't find the product details because I can't type in the details in the correct order.
Is there anyway to get around this?
Any help would be greatly appreciated.
Thanks,
Ram
I just want to know if it is possible to search data in Excel in any order.
For instance, in cell A1, I have the product "10 mm Clear Saudia". If I hit Control + F, I have to search for "Saudia" or "Clear" or "Clear Saudia" to find the product.
I was wondering if there is a way if I type "Saudia Clear" and it would still find the product for me. This is because most of the time I do not remember the exact product names but do remember certain key words related to the product. Most of the time I can't find the product details because I can't type in the details in the correct order.
Is there anyway to get around this?
Any help would be greatly appreciated.
Thanks,
Ram