Excel Formula
 

I have got a file with 11000 invoices€¦this is just an example€¦
For bill 582792093 I have got 3 invoices on an excel it can be more too) I
want to run a kind of macro or formulae that will just give me the invoice
(2) as clearance week 4 by cancelling out 1 st invoice with the 3 rd invoice
as + & -

GB14190316-582792093 GB14190316 582792093 50
GB14204648-582792093 GB14204648 582792093 20 c
GB14486877-582792093 GB14486877 582792093 -50

Excel Formula
 

Appreciate if can get this sorted...Please let me know if you need more
clarification...

"Kam" wrote:

I have got a file with 11000 invoices€¦this is just an example€¦
For bill 582792093 I have got 3 invoices on an excel it can be more too) I
want to run a kind of macro or formulae that will just give me the invoice
(2) as clearance week 4 by cancelling out 1 st invoice with the 3 rd invoice
as + & -

GB14190316-582792093 GB14190316 582792093 50
GB14204648-582792093 GB14204648 582792093 20 c
GB14486877-582792093 GB14486877 582792093 -50

Excel Formula
 

I would appreciate if you get me solution to this...

"Kam" wrote:

I have got a file with 11000 invoices€¦this is just an example€¦
For bill 582792093 I have got 3 invoices on an excel it can be more too) I
want to run a kind of macro or formulae that will just give me the invoice
(2) as clearance week 4 by cancelling out 1 st invoice with the 3 rd invoice
as + & -

GB14190316-582792093 GB14190316 582792093 50
GB14204648-582792093 GB14204648 582792093 20 c
GB14486877-582792093 GB14486877 582792093 -50

Excel Formula
 

You can send me an example file (.xls NOT .xlsx) to:

pashurst <at auditel.net

(change the obvious), and I'll take a look at it. Zip it if it is a
large file.

Pete

On Jan 26, 11:08*am, Kam wrote:
I would appreciate if you get me solution to this...



"Kam" wrote:
I have got a file with 11000 invoices…this is just an example…
For bill 582792093 I have got 3 invoices on an excel it can be more too) I
want to run a kind of macro or formulae that will just give me the invoice
(2) as clearance week 4 by cancelling out 1 st invoice with the 3 rd invoice
as + & -

GB14190316-582792093 * * * GB14190316 * * *582792093 * 50 *
GB14204648-582792093 * * * GB14204648 * * *582792093 * * * * *20 * c
GB14486877-582792093 * * * GB14486877 * * *582792093 * * * * -50 * * * * *- Hide quoted text -

- Show quoted text -

Excel Formula
 

Hello Pete,

Thanks for your reply.

I have sent you a Zip excel file on below email.

Appreciate your help.

Best Regards,
Kam.

"Pete_UK" wrote:

You can send me an example file (.xls NOT .xlsx) to:

pashurst <at auditel.net

(change the obvious), and I'll take a look at it. Zip it if it is a
large file.

Pete

On Jan 26, 11:08 am, Kam wrote:
I would appreciate if you get me solution to this...



"Kam" wrote:
I have got a file with 11000 invoices€¦this is just an example€¦
For bill 582792093 I have got 3 invoices on an excel it can be more too) I
want to run a kind of macro or formulae that will just give me the invoice
(2) as clearance week 4 by cancelling out 1 st invoice with the 3 rd invoice
as + & -

GB14190316-582792093 GB14190316 582792093 50
GB14204648-582792093 GB14204648 582792093 20 c
GB14486877-582792093 GB14486877 582792093 -50 - Hide quoted text -

- Show quoted text -

Excel Formula
 

Yes, I've received it - I will take a look this evening.

Pete

On Jan 26, 2:53*pm, Kam wrote:
Hello Pete,

Thanks for your reply.

I have sent you a Zip excel file on below email.

Appreciate your help.

Best Regards,
Kam.

Excel Formula
 

Hi Pete,

Any news?

Kam.

"Pete_UK" wrote:

Yes, I've received it - I will take a look this evening.

Pete

On Jan 26, 2:53 pm, Kam wrote:
Hello Pete,

Thanks for your reply.

I have sent you a Zip excel file on below email.

Appreciate your help.

Best Regards,
Kam.

Excel Formula
 

Yes, having looked at the file last night, I sent you an email back
saying that I couldn't follow the logic of the sheet and that I
couldn't understand your description of what you wanted. I expected an
example file of a few records showing what you wanted to achieve, not
a 7+ Mb file of 11000 records with no explanation. I concluded that I
could not help you further.

If you want someone to help, then you need to be able to describe the
problem adequately for them to understand it - perhaps this is why you
had no responses to your earlier posts.

Pete

On Jan 27, 2:26*pm, Kam wrote:
Hi Pete,

Any news?

Kam.



"Pete_UK" wrote:
Yes, I've received it - I will take a look this evening.

Pete

Excel Formula
 

Applogise for incomplete information mate...Please let me know I will provide
with you full explanation if you are ready help.

Sorry once again..

Kam.

"Pete_UK" wrote:

Yes, having looked at the file last night, I sent you an email back
saying that I couldn't follow the logic of the sheet and that I
couldn't understand your description of what you wanted. I expected an
example file of a few records showing what you wanted to achieve, not
a 7+ Mb file of 11000 records with no explanation. I concluded that I
could not help you further.

If you want someone to help, then you need to be able to describe the
problem adequately for them to understand it - perhaps this is why you
had no responses to your earlier posts.

Pete

On Jan 27, 2:26 pm, Kam wrote:
Hi Pete,

Any news?

Kam.



"Pete_UK" wrote:
Yes, I've received it - I will take a look this evening.

Pete

Excel Formula
 

I can't guarantee to be able to help you. But, for ANYONE to be able
to help, you will need to provide a detailed description of what your
problem is.

I would suggest that you start a new thread and describe what data you
have, how it is laid out, and what you want to achieve. Post a few
example records, and on this you can indicate what you want the
solution to do. Then you might get a more positive response. Remember
that contributors to these newsgroups are not mind readers, so if you
don't include something that is relevant then they won't have the
overall picture.

Hope this helps.

Pete

On Jan 28, 12:37*pm, Kam wrote:
Applogise for incomplete information mate...Please let me know I will provide
with you full explanation if you are ready help.

Sorry once again..

Kam.



"Pete_UK" wrote:
Yes, having looked at the file last night, I sent you an email back
saying that I couldn't follow the logic of the sheet and that I
couldn't understand your description of what you wanted. I expected an
example file of a few records showing what you wanted to achieve, not
a 7+ Mb file of 11000 records with no explanation. I concluded that I
could not help you further.

If you want someone to help, then you need to be able to describe the
problem adequately for them to understand it - perhaps this is why you
had no responses to your earlier posts.

Pete

On Jan 27, 2:26 pm, Kam wrote:
Hi Pete,

Any news?

Kam.

"Pete_UK" wrote:
Yes, I've received it - I will take a look this evening.

Pete- Hide quoted text -

- Show quoted text -