#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default numbers

is there a way to set up a group of numbers and then of that group of
numbers get excel to figure which ones will give a total sum when asked?
such as: I have a group, sayyy 10, 17, 5, 9, 20, 16. I want to know
which numbers in that group would add up to 56 (10,17,9,20). Any help here?

not sure how posts are done here.. I will be looking or an answer could be
emailed to
thanks

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default numbers

checkout:

http://www.tushar-mehta.com/excel/te.../match_values/
--
Gary''s Student - gsnu200858


"Flya172" wrote:

is there a way to set up a group of numbers and then of that group of
numbers get excel to figure which ones will give a total sum when asked?
such as: I have a group, sayyy 10, 17, 5, 9, 20, 16. I want to know
which numbers in that group would add up to 56 (10,17,9,20). Any help here?

not sure how posts are done here.. I will be looking or an answer could be
emailed to
thanks

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
Excel Formula - Add column of numbers but ignore negative numbers view for Distribution List members Excel Worksheet Functions 1 April 7th 06 03:13 AM
VLOOKUP should compare numbers stored as text to plain numbers. VLOOKUP - Numbers stored as text Excel Worksheet Functions 0 March 31st 06 05:53 PM
Convert numbers stored as text to numbers Excel 2000 Darlene Excel Discussion (Misc queries) 6 January 31st 06 09:04 PM
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? C-Man23 Excel Worksheet Functions 3 January 19th 06 10:52 AM
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? C-Man23 Excel Worksheet Functions 1 January 9th 06 02:23 PM


All times are GMT +1. The time now is 12:49 PM.

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

About Us

"It's about Microsoft Excel"