Re-arrange Data

[rizmomin]

Hello:

Please refer to attached excel sheet..
Column A has Class ( QB or BO)
Column B has Invoice #
Cloumn C has invoice total

I would like to use above information and arrange them
as shown in Column G, H And I

Please let me know if you have any questions.
Thanks

RM

[tom1977]

Hi
I think you made some errors in manual cauting but look at attachment

[rizmomin]

Let me explain you what i need.

I have 2 invoice amount from 2 seperate source (QB or BO) .....same Invoice #..... Cell (B4:B1532)
Basically for each Invoice # ( Column B), there is likely to be 2 invoice amount.
What i need to do is put them if they are from QB or BO and see the diff between 2 source for same invoice.

Please me know if you have any questions.

Thanks in advance and thank u for your help.

RM

[tom1977]

In my opinion I have made what you need
1. I have made unique list of invoices numbers
2. my formula is finding sum (maybe no necessary but in this case this not important) for QB and BO columns H and I for every unique invoice number
3. in columns J there is difference
You should adjust ranges
My formula is a array formula (accepted by CTRL + SHIFT + ENTER)

[rizmomin]

I think i got it..

Thank U so much

RM