Retreive data for same agent

8

818jaime

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
 
D

Don Guillett

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
Click to expand...
 
D

Don Guillett

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
Click to expand...



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
Click to expand...

You could have a dropdown linked to a macro that used data>filter>autofilter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract first and last login time for each day only 6
Total appointments per agent 2
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
MACRO IS NOT WORKING AS IT SHOULD 3
retrieve data from two columns and sort 17
Consolidation Table from Different Excel Tabs with Different Format 1

Top