2/25/2024 Download the new version for mac Ablebits Ultimate Suite for Excel 2024.1.3436.1589Read Now![]() ![]() ![]() If your range has no labels, look at the 1st row content area to make sure you choose the right columns.With the box checked, the same text written in different cases ("Text" and "text", for instance) will be considered as different text. If text case matters, tick the Case-sensitive match box. ![]() For example, the " September " and "September" values will be identified as duplicates with the checked Ignore extra spaces option and will be considered two different values if the box is not ticked. The Ignore extra spaces option may be useful if your data may contain extra spaces that you want to ignore.If you have empty cells in your Excel table, tick the Skip empty cells option to exclude them from the search results.If you have more than one header rows, click 1 header row and enter the number of header rows your table has. Unless your range is formatted as a table in Excel, you can let the add-in know if the first row contains labels with the My table has headers option at the top.You can take advantage of the additional options: This step displays a list of columns with their headers as they are in your worksheet: Pick columns to check for duplicates and uniques ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |