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.
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.
* * *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.
Excel 2003/2007 (windows)