|
|
| 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. |
|
| Updated |
Dec 8, 2004 08:56:40 |
| Rating |
441 ( -47 -10.65% ) | | Size | 48 kb | | Licence | Freeware | | Status | Major Update | | Languages | English | | Tags | Excel, Macro, compare lists | | OS | Windows 95, Windows 98, Windows ME, Windows NT, Windows 2000, Windows XP, Windows 2003 | | Homepage | pspsoftware.co.za | | Email | info@pspsoftware.co.za | | Author | Dirk Wessels |
|
|
click for full size
|
| Other author's software: | - Select to Excel 2 This small Excel macro allows you to execute SQL commands on any ODBC data source directly in Excel and will paste the results in an Excel sheet where you can sort, filter and further manipulate the data.
- TimeClick 1 Log your times spent on each project by clicking on the project name on a menu within your Windows System Tray. Drastically reduces time spent on updating timesheets.
| | Show all author's software |
Description: 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. | Short tags: Excel, Macro, compare lists | System Requirements: MS Excel 97 or higher | |
| Free Download Excel List Compare 1 from pspsoftware.co.za |
| Similar smart reviews: | - HexCmp2. Comparing All Bytes The essence of just about any programmers work is, obviously, processing data. Reading, creating, converting, writing or visualizing data is what nearly all any modern program does. So, a programmers daily activity, besides «just writing code», mostly consists of preparing, reading and analyzing data. And having good tools for the task is very important for the overall
- Excel Workbook Splitter 1.05, Fastest And Easiest Way Trends in todays software industry have brought us many monster-like huge «suites». In fact, «multifeatured and universal software suites» take any niche where enough users can be found. It is not that bad, these suites are typically really useful and pleasant to use, but they dont suit many situations, when you need to do one easy operation but many times
- Macro Scheduler 9.2.01e, Don't Bother Your Hands A hundred years ago, machines first arose to automate routine operations that humans didnt want to do. It is now the 21st century, and what do we see? How many exactly identical, exactly routine «point-and-click», «switch-and-type», «drag-and-drop», «cut-and-paste» operations do you perform on the desktop of your computer every day
- Raise Data Recovery for NTFS, Resurrect Ceased Data Youve just emptied your desktop recycle bin and maybe even formatted the hard drive. A moment later, all of the sudden, you realized that some crucial documents are missing, and most likely they had ended up in that recycle bin and were erased. Is that your doomsday and time for the resignation? Or can anything be done to recover that lost and erased data? Dont rush to resign
- Software List Creating a software directory initially seems to be an unreasonably expensive and complicated project. You need to come up with the business logic, hire a team of developers or spend a whole lot of time programming the solution yourself, open merchant accounts, find software vendors and so forth. A serious undertaking by all means, thats for sure
- Swift To-Do List. Organize Your Life! You like making lots of plans, but your memory cant cope with them all? Or, you are a hard-working person, too busy to rest, trying to organize days carefully since you cant afford to miss anything? Ask me what to do, and Ill give you a piece of advice try out Swift To-Do list. Swift To-Do list is brilliant software that can organize all
- Sonar Screensaver 1.00, Listen The Ocean In the calm and quiet world of ocean, sounds are very special. The oceans own life often uses the sound «radar» for navigating through its dark deep waters by «listening» or even doing the «active detection» (sending sounds and listening what theyve bounced from). This idea is also utilized in human-made water and underwater vessels; modern «sound
- CDuke: Writes any data in any way. CDuke is a utility for writing data to CD and DVD disks. The great number of possibilities turns this software into a «Swiss knife» of disk writing. First of all, CDuke allows you to burn CD and DVD disks as easily as floppy ones. If you need to write data, you don?t need to do a lot of unnecessary actions. Just insert a CD and select
- CredibleXML 2.1, Data Format Magician From the very beginning, computers were designed to process data. So, since 1950-s, again and again the same question was raised and solved: what data formats are we to use. Tons of formats were defined; text and binary, with tables and named fields, with esoteric assumptions made about various aspects
Fortunately, now we have the XML format, well-standardized, with equally well standardized description formats
| | Find all smart reviews similar on Excel List Compare 1 |
|