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
|