LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 23rd 05, 09:11 PM
Danniel Chen
Posts: n/a
Default Free Tool (Add-in) To Speed Up Your Data Processing

If you use Excel everyday and spend lots of time on data/text processing,
then you will find the attached tool (UDQ Add-in) is very powerful and can
speed up your daily data processing work.

Currently the tool is free for everyone. Please feel free to distribute this
tool to your
friends/colleagues if you think it is helpful to your work.

The following is a list of features/functionality of the tool:

1 Query/Import Data from Multiple External Data/Text/ASCII Files (Can
useful import data from hundreds of files within minutes)

2 Query/Import Data from Multiple Closed Excel Files (Can extract useful
information from hundreds of closed Excel files)

3 Query/Import Data from Remote Internet/Websites (Can extract stock prices
of your portifolio, etc. from web pages)

4 Query/Consolidate Data from Multiple Worksheets (Create summary table
based on information on multiple sheets)

5 Query/Conditional Statistics on Selected Range (Achieve MaxIF, AverageIF,
SumIF, etc. functions under multiple conditions)

6 Operation/Conditional Highlight on Selected Range (Highlight alternative
rows, highlight maximum/minimum values, highlight difference between 2
columns/rows etc.)

7 Lookup Value based on Selected Range and Keyword (More powerful than
VLookup, HLookup, Match, etc).

Estimated installation time is 30 ~ 50 seconds. You can use it in Excel just
like use Solver add-in, Analysis ToolPak, etc.

If you have any questions/comments, please feel free to email to
To find the latest information/version of UDQ, please visit


Danniel CHEN

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Why " data analysis plus " override " data analysis " once instal. Alfred H K Yip Excel Worksheet Functions 1 March 20th 05 08:10 AM
How do I get Data Analysis Plus tool pack in tools menu Show up. . epsilon8 Setting up and Configuration of Excel 1 February 11th 05 04:13 AM
Charting data ranges that change mikelee101 Charts and Charting in Excel 2 December 16th 04 11:07 PM
Why is the order of my data table opposite from graph? mozermodo Charts and Charting in Excel 5 December 7th 04 06:09 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM

All times are GMT +1. The time now is 08:57 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017