| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I obtain Microsoft Agent 2.0 or later? | Excel Discussion (Misc queries) | |||
| I accidentally saved over important data and cannot retreive it | Excel Worksheet Functions | |||
| How do i retreive data from another worksheet to a current one? | Excel Worksheet Functions | |||
| I want to enter a customer # and retreive their data | New Users to Excel | |||
| is there anyway to retreive data if deleted in ms excel | Excel Discussion (Misc queries) | |||
Linear Mode
