Useful Excel macro will compare rows in 2 lists of data based on 1 to 3 columns in each list. Creates a new spreadsheet with matched rows from original 2 lists merged together on the same row and unmatched rows highlighted on separate rows.
As the 2 lists of data are merged into a one spreadsheet, the number of columns of the 2 lists together must not exceed the maximum number of columns Excel supports.
Tested on MS Office 97 - XP.
Regression Analysis and Forecasting The Multiple Regression Analysis and Forecasting template provides a reliable identification of value drivers and forecasting business plan data. Advanced statistical tests performed include significance, autocorrelation and multicollinearity.
ABC Amber Excel Converter An advanced utility which converts XLS (MS Excel) files to any format you wish (DBF, CSV, XML, PDF, HTML, CHM, RTF, HLP, DOC, and many more) easily and quickly.
Supports a batch conversion, a run from command line and more than 50 languages.
Schedule Multiple Shifts Automatically Program automatically assigns 50 people to 10 shifts for a month in response to your scheduling needs and their preferences. Creates vCalendar file for your PDA, Smart Phone and Outlook Calendar and comes in sizes for up to 20 shifts and 500 people.
Previous:
Scheduler for Excel Scheduler for Excel is a powerful, easy to use application for quickly creating schedules, tables and Gannt charts for school, work, sports teams, golf tournaments and leagues, or just about any other schedule or table you can imagine.
ExcelEverywhere for HTML Create WEB form that looks and functions the same as your Excel spreadsheet. No programming needed. Supports 175 Excel-functions. Use it for expense report, survey, order form, application, financial advisor, ROI. Live line, bar, pie charts!
File size: 48 K Platforms: Windows XP/ME/NT/2000/98/95/3.X Downloads: 103
This useful Excel macro will compare rows in 2 lists of data based on 1 to 3 columns in each list. Creates a new spreadsheet with matched rows from original 2 lists merged together on the same row and unmatched rows highlighted on seperate rows.