Ablebits Ultimate Suite for Excel 2024.1.3443.1616 download the new version for ios

Merge Several Tables with Single Lookup Table.Merge Single Table with Several Lookup Tables.We've extended our support of scenarios to the following tools: The Use LAMBDAs feature has been incorporated into Date & Time Formula Wizard to make it possible for you to enjoy reusing custom functions.

NEW: Use LAMBDAs in Date & Time Formula Wizard Decide on a criterion by which your workbook should be split and get the desired result with ease. Use the Split Workbook tool to speed things up. Working days are often too hectic to waste your time on copying data from one Excel file to another. Stay calm and balanced ) with our new Formula Editor which is designed to simplify the process of creating and editing Excel formulas no matter how long they are. Insert Pictures now can paste not only images to your Excel tables but also add the names of them with links to the file location.If a complex Excel formula keeps returning an error over and over again despite all the efforts to correct it, even a very patient person might feel that nerves of steel are definitely needed. IMPROVED: Insert Pictures with names and links You can make your choice right on Step 1 of Split Table Wizard.

Now, with the Split Table tool, you can decide how to split the table: by the key columns or by every number of rows of your choice. The Merge Cells tool now lets you not only separate values by the chosen delimiter but also combine them with the aggregate Excel functions: AVERAGE, COUNT, COUNT(A), MAX, MIN, and SUM. IMPROVED: Merge cells with aggregate Excel functions See also: How to Transpose by Key Columns If repeated values are found, the tool transposes and/or merges data according to the options you choose. Transpose by Key Columns searches for duplicates in the key column. This tool transposes data in the selected range by the chosen key columns and simultaneously combines rows if needed. The powerful add-in lets you use regular expressions in Excel to identify cells that match a certain condition or to extract, remove, or replace strings that match a regular expression: In the Text group, you will find the new Regex Tools button. You can find the full list of our releases here: Ultimate Suite for Excel release notes NEW: Regex Tools In the Ultimate Suite for Excel 2021.4 release, at your service are brand-new Regex Tools and Transpose By Key Columns, plus some improvements to the Merge Cells, Split Table, and Insert Pictures tools.

Ablebits Ultimate Suite for Excel 2024.1.3443.1616 download the new version for ios