Find Similar Cells is designed to find and select similar cells in Excel quickly and easily. Read the step-by-step instruction on how to use it.
I would like to type a tyre size into 3 columns - this then returns a search of a worksheet and gives me a particular answer that is already in the sheet..
rather than continually go through the filtering process. there must be a quicker way
Cell 1 - 285
Cell 2 - 70
Cell 3 - 17
returns a value of what rim width it will fit
returns a value of Width - length - Height - Weight so i can quickly process freight quotes..
Thank you for contacting us. For us to be able to help you better, please send us a small sample workbook with 2 sheets to firstname.lastname@example.org: 1 - your source data and 2 - the result you expect to get. I kindly ask you to shorten the tables to 10-20 rows.
Note! The result sheet is of great importance and often gives us a better understanding of your task rather than any text description. Please don't forget to include it.
We'll look into your task and see if our software can help.
i have a 20K row doc, and one of the columns is "address", that has a number of fuzzy dupes. running the 'find replace" "find similar cells in the current column" with max characters of "4" doesn't find any "similar cells" ... i can see them in the first 50 rows, so i must be missing something...
am i using the add-in correctly??
I have just requested some additional details regarding your task via email. Please email us back and provide the requested info. We'll try to help. Thank you.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!