Supposing you have a worksheet that has data in columns A to G, the salesman’s name is in column A and you need to automatically split this data into multiple worksheets based on the column A in the same workbook and each salesman will be splitted into a new worksheet. Quickly split data into multiple worksheets based on column or fixed rows in Excel Click Find button to go to the searching result view, then click down arrow to expand the list. In the Fuzzy Lookup pane, select the searching range, and then specify the searching criteria as you need.ģ.
Supposing you want to find all approximate values in a range A1:B7, you can do as below:Ģ. Click Find button, then click the down arrow to expand the list to view the searching results.
Click Kutools > Find > Fuzzy Lookup to enable the Fuzzy Lookup pane.ġ) Select the range you used to find, you can check Specified to fix the searching range.Ģ) Check Find by specified text checkbox.ģ) Type the value you want to fuzzy search based on in the Text textbox.Ĥ) Specify the searching criteria as you need.ģ. Supposing you want to lookup a value “app” in range A1:A7, but the number of different characters cannot be more than 2, and the number of characters must be large than 1.ġ. After free installing Kutools for Excel, please do as below:
0 kommentar(er)
