Active Data for Excel. Worksheet Features

Active-Data for Excel Start. See Also Active Data for Office

Merge Sheets: Take information from separate sheets and bring them together based on a key column to provide you with a new look in an existing sheet or in a whole new sheet.

Match Sheets: Extract data by matching against ranges in other worksheets.

Compare Sheets: Compare two sheets with a common key and then generate totals and counts for selected columns.

Query Sheet: Extract records by querying by formula, using any combination of Excel formulas. Query by date, number or character string and post them to a new sheet or append them to the current sheet.

Split Sheet: Split a sheet apart by specifying the group you want to isolate and analyze. You also have the ability to split your information out by date (by week, day, month, or day of the week).

Sort to New Sheet: Sort your data by up to 6 groups – three more than Excel itself! -- and then select the columns you want to carry over into either a new sheet or appended to the sheet you’re working on.

Sample: Randomly sample a specified number of rows within a range.

Buy, Download and more details. Active-Data for Excel Start. See Also Active Data for Office

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Send payment proof to special@ozgrid.com 31 days after purchase date.

Back to: Microsoft Excel ® Add-ins | Microsoft Excel ® Templates | Software Categories | Search all Software

Instant Download and Money Back Guarantee on Most Software

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

FREE Download!

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

FREE Excel Help