sponsored links
Description
"Add-Tools for Excel Elites."
Complex Table Filter
Filter by wildcard
Multiple filter criteria, nested conditions
Filter blank, opposite pairs
Filter Max, Min
roll-up
Pivot Table or subtotal better than
Select cells
Select the cell rows, columns, complex conditions, joker
Select Max, Min range by
Expand selection
Ordering
More than 3 levels
text, length, color, style, by private
Random sort order
Sort File Link <br> Break broken links,
extract extract
a valid e-mail
filter to extract the visible lines clean up connection failure, subtotal result
& Remove Duplicate calls - DeDupe
Remove the table match, the key field (s) filters, fast extract
By pairs
Do Excel Access
Access-like query, join, Excel, total
Table / Chart
Join (merge) tables, lists
Match tables, fuzzy match
Combine () tables, sheets, add files
Split table into sub-tables
Transpose to the list of cross-table
Converting Values
Week, Month, Qtr, Year, Time date conversion
Conversion data type text or General
Convert Up, Down, Proper Case
Round up / down, for Trim
conversion range, sheet, value file only
Delete
Delete empty, hidden rows, columns, sheets
intervals delete rows by
Row Ranges <br> Add, copy, line ranges
Delete, select by
values or linear series (interpolation)
Fill out a series of random values and fill in the various
Fill in empty cells
Fill an array with constant
Median
roll-up () with a summary table of the media
within the selected range of media
Mix & Combine Sets
Mix to the list of all combinations of cells sets
Table Column
Add column before / after
Trim spaces
Combine column
Split column by delimiter or length
cell text length
Shift columns Count
Random
Choose a random order
Fill in the date value according to the random number or range
Unique Values () different pivot table with a count <
roll-up Count br> Count / extract from different Excel 7.1.3.3 now free DigDB range.
sponsored links
Visitor rates
4 Star
41
Member rates
4 Star
41
Ortalama oy:
3,8