Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
got a tough on and I am confused were to start
Ok I have a table array that is preety in depth.
It works off of an agent # unique and sortable. A vlookup formula popluates the agent name and additional info based off the #. Ok here is the problem, the agent # is assigned to an office office code. So in other words the agent produciton is paid into that office code. well from time to time we re-profile these guy under new office codes. The code has an inception date, so on JAN 1st agent 177721 might be under office code 401895 and then aug he has moved to office code 401913. His producion is dated as well. Question, how can I stucture this were data intry for the date of production will return the correct office code by the codes inception dates?? please ask quesitons if you do no understand mine. lets say column b is the date of the production and col c is the agent #, col d-g, are random data agent name ect. and col. h is the office code. how can incorpoate the date in the array to return the correct offic code |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
got a tough on and I am confused were to start
can you place some samples of the data
" wrote: Ok I have a table array that is preety in depth. It works off of an agent # unique and sortable. A vlookup formula popluates the agent name and additional info based off the #. Ok here is the problem, the agent # is assigned to an office office code. So in other words the agent produciton is paid into that office code. well from time to time we re-profile these guy under new office codes. The code has an inception date, so on JAN 1st agent 177721 might be under office code 401895 and then aug he has moved to office code 401913. His producion is dated as well. Question, how can I stucture this were data intry for the date of production will return the correct office code by the codes inception dates?? please ask quesitons if you do no understand mine. lets say column b is the date of the production and col c is the agent #, col d-g, are random data agent name ect. and col. h is the office code. how can incorpoate the date in the array to return the correct offic code |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
got a tough on and I am confused were to start
its going to be hard to do in this format. do you have an email
that I can use. "Joel" wrote: can you place some samples of the data " wrote: Ok I have a table array that is preety in depth. It works off of an agent # unique and sortable. A vlookup formula popluates the agent name and additional info based off the #. Ok here is the problem, the agent # is assigned to an office office code. So in other words the agent produciton is paid into that office code. well from time to time we re-profile these guy under new office codes. The code has an inception date, so on JAN 1st agent 177721 might be under office code 401895 and then aug he has moved to office code 401913. His producion is dated as well. Question, how can I stucture this were data intry for the date of production will return the correct office code by the codes inception dates?? please ask quesitons if you do no understand mine. lets say column b is the date of the production and col c is the agent #, col d-g, are random data agent name ect. and col. h is the office code. how can incorpoate the date in the array to return the correct offic code |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
got a tough on and I am confused were to start
joel dot warburg at itt dot com " wrote: its going to be hard to do in this format. do you have an email that I can use. "Joel" wrote: can you place some samples of the data " wrote: Ok I have a table array that is preety in depth. It works off of an agent # unique and sortable. A vlookup formula popluates the agent name and additional info based off the #. Ok here is the problem, the agent # is assigned to an office office code. So in other words the agent produciton is paid into that office code. well from time to time we re-profile these guy under new office codes. The code has an inception date, so on JAN 1st agent 177721 might be under office code 401895 and then aug he has moved to office code 401913. His producion is dated as well. Question, how can I stucture this were data intry for the date of production will return the correct office code by the codes inception dates?? please ask quesitons if you do no understand mine. lets say column b is the date of the production and col c is the agent #, col d-g, are random data agent name ect. and col. h is the office code. how can incorpoate the date in the array to return the correct offic code |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
got a tough on and I am confused were to start
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tough one... | Excel Discussion (Misc queries) | |||
Tough one: | Excel Discussion (Misc queries) | |||
OK tough one ! | Excel Worksheet Functions | |||
OT :Start your own online business today !start making dollars | Excel Discussion (Misc queries) | |||
Tough one | Excel Discussion (Misc queries) |