|
|
#1
02-24-2016, 02:57 PM
|
|||
|
|||
Create and Return Values to another Table
Hello All,
Table 1 COL A COL B COL C LOAN # Description Date 111 memo 2 1/30/2016 111 memo 1 1/29/2016 222 memo 1 9/11/2015 333 memo 1 1/22/2015 333 memo 2 NULL OR SPACE 333 memo 3 NULL OR SPACE Table 2 COL E COL F COL G LOAN # Description Date 111 memo 2 1/30/2016 222 memo 1 9/11/2016 333 memo 2 NULL OR SPACE Could you please help me write an Excel formulas to create a Table 2 from Table 1. I'm looking to return the first occurrence of the newest "Date" or first occurrence of the "Space" if it comes after the "Date". This just a short sample. Thanks a lot 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How do I create a field that will return the current paragraph number minus one in an automatic list
|
gugootz | Word | 1 | 11-23-2015 04:58 PM |
| Formula/function to return column names for matching values | GiJoe81 | Excel | 1 | 06-27-2015 12:13 AM |
| How to create a pivot table with text as values | ljd108 | Excel Programming | 0 | 01-22-2015 07:48 PM |
|
Reference another workbook and return values from the same cell across multiple sheets/tabs
|
lwls | Excel Programming | 5 | 11-08-2014 02:11 PM |
|
Auto-create row from column values
|
ReviTULize | Excel | 1 | 03-28-2013 02:27 AM |
Windows 7 32bit 
Office 2013
Linear Mode
