AGGREGATE HELP

[hajiali]

=IFERROR(INDEX('EMPLOYEE LIST'!$BL$2:$BL$1000,[COLOR=rgb(235, 107, 86)]AGGREGATE(15[/COLOR],6,(ROW('EMPLOYEE LIST'!$BL$2:$BL$1000)-ROW('EMPLOYEE LIST'!$BL$2)+1)/(('EMPLOYEE LIST'!$V$2:$AT$1000=$A$17)),COLUMNS($C$17:C17))),"")

With the above code am able to pull all names in 'EMPLOYEE LIST'!$BL$2:$BL$1000 if 'EMPLOYEE LIST'!$V$2:$AT$1000=$A$17. $A$17 had DATE. I need this formula to be altered instead of "AGGREGATE(15" Small to pull the name in the order the date is typed. ex:

EMPLOYEE LIST SHEET * in red is the order I type the dates

BL	V
BOB	12/15 (1st)
MIKE
ZOE	12/15 (5th)
JILL
PHILLIP	12/15 (4th)
TRACY
JENN	12/15 (2nd)
BILLY
TOM	12/15 (3rd)
SMITH

I want the results to Output as:

12/15

BOB

JENN

TOM

PHILLIP

ZOE

My above Formula does:

12/15

BOB

ZOE

PHILLIP

JENN

TOM

any Suggestions.

 

[jasonb75]

A formula can only see what is entered, not when it is entered. To do this with a formula you would need to create a full timestamp (date and time) when each entry is made.

 

[hajiali]

A formula can only see what is entered, not when it is entered. To do this with a formula you would need to create a full timestamp (date and time) when each entry is made.

can this be achieved by VBA?

 

[jasonb75]

Possibly. Looking at your formula, I think however you do try it, it's going to be messy.

How does the range V2:AT2000 relate to the date entry, why 25 columns?