Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default find the total

Hello,

i try to find this answer in groups.google but not result.

I have a total like 2436.32 from my "fournisseurs"

i have a lot of factures like
FACT1 324.55
FACT2 5436
FACT3 765.67
FACT4 434
FACT5 456
FACT6 9764.4
FACT7 4748.33
FACT8 838.33
FACT9 988.01
FACT10 839.44


il would like to find what combinaison of facture give me a total of 2436.32
?
Sorry for my poor english..
Patrick (Belgium)



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default find the total

Hi Patrick,

See code by Harlan Grove which was recently posted by Niek Otten:

http://tinyurl.com/qah9u

---
Regards,
Norman



"...Patrick" wrote in message
...
Hello,

i try to find this answer in groups.google but not result.

I have a total like 2436.32 from my "fournisseurs"

i have a lot of factures like
FACT1 324.55
FACT2 5436
FACT3 765.67
FACT4 434
FACT5 456
FACT6 9764.4
FACT7 4748.33
FACT8 838.33
FACT9 988.01
FACT10 839.44


il would like to find what combinaison of facture give me a total of
2436.32 ?
Sorry for my poor english..
Patrick (Belgium)





  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default find the total

Thank you Norman !!!


Have a good week end
Patrick


"Norman Jones" a écrit dans le message de
news: ...
Hi Patrick,

See code by Harlan Grove which was recently posted by Niek Otten:

http://tinyurl.com/qah9u

---
Regards,
Norman



"...Patrick" wrote in message
...
Hello,

i try to find this answer in groups.google but not result.

I have a total like 2436.32 from my "fournisseurs"

i have a lot of factures like
FACT1 324.55
FACT2 5436
FACT3 765.67
FACT4 434
FACT5 456
FACT6 9764.4
FACT7 4748.33
FACT8 838.33
FACT9 988.01
FACT10 839.44


il would like to find what combinaison of facture give me a total of
2436.32 ?
Sorry for my poor english..
Patrick (Belgium)






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I have a sub total need to find the GST & QST any formula music icons Excel Worksheet Functions 3 September 9th 07 04:26 PM
function to find which cells add up to a given total? jbourgui Excel Worksheet Functions 6 August 12th 05 08:17 PM
Find Text and put total across from it SMac Excel Programming 2 March 24th 05 10:17 PM
find parts of a total Jim Excel Worksheet Functions 1 February 22nd 05 08:07 PM
Macro Loop, Find, and Total Lou Excel Programming 2 April 28th 04 04:33 PM


All times are GMT +1. The time now is 04:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"