I need an excel addin/plugin that works in both excel 2003 and 2007 (windows) to process a csv file. The csv file contains multiple columns of information. A = email B = firstname C = lastname D,E,F = info not required G and H inclusive = exam date information I to M = info not required Example entries in columns G to M are: 28/03/1974 Unknown Date (blank cell) 21-July-2008, 21-July-2008, 21-July-2008, 20-July-2008 06-September-2007, Unknown Date 12-March-2008, Unknown Date, 13-March-2009 Basically I need to split up the dates into separate rows associated with a single person (identified by email/firstname/lastname). I then want to extract the earliest valid date of any exam a person took (ignoring 1-1-1970, 'Unknown Date' and blank cells') into one column. I'd then like a second column that orders these dates chronologically and removes the spaces. Very urgent! Number of rows is variable.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):
a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
* * *This broadcast message was sent to all bidders on Wednesday Dec 16, 2009 9:34:45 PM:
In the interests of doing this quickly I would like to remove the graph requirement from this project. I now only require the dates to split up into rows, and a single column of extracted earliest valid dates, as well as a single column of those dates ordered chronologically without spaces.
## Platform
Excel 2003/2007 (windows)