| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
Hi I have a table (sheet1) that contains. Date column(A), ID column (B) and Time column (D) In a new sheet i need to populate (sheet2) cell C2 and D2 based on the following Conditions. (sheet2) column (A) contains date for each record, column (B) contains ID. note: sheet1 has been sorted by Date, time and ID C2 = sheet1A:A,>=sheet2!A2 and sheetA:A,<=sheet!A2 and Sheet1B:B,=Sheet2!B2 then return First value from sheet1,C:C. D2 = sheet1A:A,>=sheet2!A2 and sheetA:A,<=sheet!A2 and Sheet1B:B,=Sheet2!B2 then return Last value from sheet1,C:C.  Thanks  -- mathewheys ------------------------------------------------------------------------ mathewheys's Profile: http://www.excelforum.com/member.php...o&userid=25093 View this thread: http://www.excelforum.com/showthread...hreadid=388252 |
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Search and replace hard-line-return character, not carriage return | =?Utf-8?B?VHlsZXIgVA==?= | Microsoft Word Document Management | 2 | 16th Aug 2006 10:11 PM |
| Serialize a class having property that return object as return type | surindersaini@gmail.com | Microsoft C# .NET | 4 | 24th Oct 2005 04:23 PM |
| VBA to apply a Soft Return (or Hard Return) at end of wrapped line | Dennis | Microsoft Word Document Management | 7 | 14th May 2005 08:01 AM |
| Userenv 1000. Windows cannot determine the user or computer name. Return value (<return error code>). | Ingmar | Microsoft Windows 2000 Networking | 1 | 18th Nov 2003 06:08 PM |
| Userenv 1000. Windows cannot determine the user or computer name. Return value (<return error code>). | Ingmar | Microsoft Windows 2000 Group Policy | 1 | 18th Nov 2003 06:08 PM |
