Looking for the correct formula to get data from my odbc download that gives
data for a number of general ledger codes and covers multiple peoples
accounts. The data needs to go on each persons individual recap [which is
divided into three sections and has multiple accounts applicable to each
section]starting at the first line of their recap, assuming there is
activity. If there is addtional activity put it on the second line and so on.

example: Employee 5006 Employee 5001 Employee 5002

downloaded
10011187015006
10011187025006
10011187055002
10011187035006
I would want to get three lines of data for
Employee 5006 shown on the first three lines that title, and one line of data
below Employee 5001

Not explaining it well, but hope you get the drift. Thanks.

I'm not sure exactly what you have or what you are trying to achieve,
but I've made some assumptions. First of all, assume that you have a
sheet called "download" which has your data in column A starting with
A1. Put this formula in B1:

=RIGHT(A1,4)

to get the employee number, and this in C1:

=B1&"_"&COUNTIF(B$1:B1,B1)

to give you the employee number followed by a sequential code. Copy
these formulae down the columns as far as needed.

I've assumed that you have a second sheet in which you have employee
numbers in A1, B1, C1 etc, such as:

5001 5002 5006

and so on. Put this formula in A2:

=IF(ISNA(MATCH(A$1&"_"&ROW(download!$A1),download! $C$1:$C
$4,0)),"",INDEX(download!$A$1:$A$4,MATCH(A$1&"_"&R OW(download!
$A1),download!$C$1:$C$4,0)))

and copy this across and down as far as you think you need. It will
give these results for your sample data:

5001 5002 5006
10011187055002 10011187015006
10011187025006
10011187035006

or even this, by just changing the headers to the order you asked for:

5006 5001 5002
10011187015006 10011187055002
10011187025006
10011187035006


Hope this helps.

Pete


On Oct 21, 6:34*pm, drose wrote:
Looking for the correct formula to get data from my odbc download that gives
data for a number of general ledger codes and covers multiple peoples
accounts. *The data needs to go on each persons individual recap [which is
divided into three sections and has multiple accounts applicable to each
section]starting at the first line of their recap, assuming there is
activity. *If there is addtional activity put it on the second line and so on.

example: * * * * * * Employee 5006 * * * *Employee 5001 * * *Employee 5002

downloaded
10011187015006
10011187025006
10011187055002
10011187035006
* * * * * * * * * * * * * I would want to get three lines of data for
Employee 5006 shown on the first three lines that title, and one line of data
below Employee 5001

Not explaining it well, but hope you get the drift. *Thanks.