"Indirect" function
 

I have information on two rows of data that i want to be on one row.

My information is taxing authority info with a line item for each tax item
per invoice, as such:

Inv# Order# Desc Desc2 Line value Inv value
12345 56261 LA State tax 54% exclu $203.78 $11,800.00
12345 56261 Parish tax $526.05 $11,800.00

I woud like to pull the "parish tax" info into the same row as the LA State
tax, my indirect function isn't working . . . most invoices have two rows, a
few have four but I can segregate the data to do all the like-numbered rows
together.

Thanks!

"Indirect" function
 

smartgal wrote:
I have information on two rows of data that i want to be on one row.

My information is taxing authority info with a line item for each tax item
per invoice, as such:

Inv# Order# Desc Desc2 Line value Inv value
12345 56261 LA State tax 54% exclu $203.78 $11,800.00
12345 56261 Parish tax $526.05 $11,800.00

I woud like to pull the "parish tax" info into the same row as the LA State
tax, my indirect function isn't working . . . most invoices have two rows, a
few have four but I can segregate the data to do all the like-numbered rows
together.

Thanks!

Assuming your sample data is in A2:F3 you could try this in row 2
somewhere to bring the Parish Tax Line Value up from the following row:

=E3

Ok that was too easy. I'm guessing your data is shaped something like this:

Inv# Order# ...
12345 56261 ...
12345 56261 ...
23456 12121 ...
23456 12121 ...
34567 97979 ...
34567 97979 ...

So we would need to plan for capturing data only on the first row of an
invoice or order:

=IF(A2=A3,E3,"")

"Indirect" function
 

Basically I did something similar, having first done the "=" and pulled the
data up to the prior row but I had to filter it so I would only have to do it
on every *other* row. So far, looks like it's working. I just thought maybe
there would be a formula I could pull down that would skip it for me.

"smartin" wrote:

smartgal wrote:
I have information on two rows of data that i want to be on one row.

My information is taxing authority info with a line item for each tax item
per invoice, as such:

Inv# Order# Desc Desc2 Line value Inv value
12345 56261 LA State tax 54% exclu $203.78 $11,800.00
12345 56261 Parish tax $526.05 $11,800.00

I woud like to pull the "parish tax" info into the same row as the LA State
tax, my indirect function isn't working . . . most invoices have two rows, a
few have four but I can segregate the data to do all the like-numbered rows
together.

Thanks!

Assuming your sample data is in A2:F3 you could try this in row 2
somewhere to bring the Parish Tax Line Value up from the following row:

=E3

Ok that was too easy. I'm guessing your data is shaped something like this:

Inv# Order# ...
12345 56261 ...
12345 56261 ...
23456 12121 ...
23456 12121 ...
34567 97979 ...
34567 97979 ...

So we would need to plan for capturing data only on the first row of an
invoice or order:

=IF(A2=A3,E3,"")