#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
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 |