Retreive data for same agent
 

Hello
Can someone please tell me what is the best way to retreive data for
one person. Example I have a login logout exported report from a
diffrent source for the entire month and it has lets say 10 agents for
the month and some agents might have mutiple login/out for the day.

What is the best way for a formula to look and retreive all the data
for a single agent..

fyi the exported data is already in order 3 columns NAME-LOGIN-LOGOUT

Retreive data for same agent
 

On Thursday, May 17, 2012 1:48:10 PM UTC-5, 818jaime wrote:
Hello
Can someone please tell me what is the best way to retreive data for
one person. Example I have a login logout exported report from a
diffrent source for the entire month and it has lets say 10 agents for
the month and some agents might have mutiple login/out for the day.

What is the best way for a formula to look and retreive all the data
for a single agent..

fyi the exported data is already in order 3 columns NAME-LOGIN-LOGOUT

Retreive data for same agent
 

On Thursday, May 17, 2012 1:48:10 PM UTC-5, 818jaime wrote:
Hello
Can someone please tell me what is the best way to retreive data for
one person. Example I have a login logout exported report from a
diffrent source for the entire month and it has lets say 10 agents for
the month and some agents might have mutiple login/out for the day.

What is the best way for a formula to look and retreive all the data
for a single agent..

fyi the exported data is already in order 3 columns NAME-LOGIN-LOGOUT



On Thursday, May 17, 2012 1:48:10 PM UTC-5, 818jaime wrote:
Hello
Can someone please tell me what is the best way to retreive data for
one person. Example I have a login logout exported report from a
diffrent source for the entire month and it has lets say 10 agents for
the month and some agents might have mutiple login/out for the day.

What is the best way for a formula to look and retreive all the data
for a single agent..

fyi the exported data is already in order 3 columns NAME-LOGIN-LOGOUT

You could have a dropdown linked to a macro that used datafilterautofilter.

Retreive data for same agent
 

On May 17, 5:39*pm, Don Guillett wrote:
On Thursday, May 17, 2012 1:48:10 PM UTC-5, 818jaime wrote:
Hello
Can someone please tell me what is the best way to retreive data for
one person. Example I have a login logout exported report from a
diffrent source for the entire month and it has lets say 10 agents for
the month and some agents might have mutiple login/out for the day.

What is the best way for a formula to look and retreive all the data
for a single agent..

fyi the exported data is already in order 3 columns NAME-LOGIN-LOGOUT
On Thursday, May 17, 2012 1:48:10 PM UTC-5, 818jaime wrote:
Hello
Can someone please tell me what is the best way to retreive data for
one person. Example I have a login logout exported report from a
diffrent source for the entire month and it has lets say 10 agents for
the month and some agents might have mutiple login/out for the day.

What is the best way for a formula to look and retreive all the data
for a single agent..

fyi the exported data is already in order 3 columns NAME-LOGIN-LOGOUT

You could have a dropdown linked to a macro that used datafilterautofilter.- Hide quoted text -

- Show quoted text -

Thank you