Finding matching numbers in a column that equal another single # in a cel

[dbuck]

My example. I have a # in a cell, ex. 5,124. The I have another column, the amount of numbers in this column can change but won't exceed, 20 numbers.
ex: 2001, 582, 304, 55, etc. I want Excel to tell me what #'s in my list equal the # in my cell. Could be 1 of the #'s or many of the numbers. It can just be an X that shows up next to it.

Any thoughts?

 

[awoohaw]

do you want a count of the matches? or do you want the text string in the cell changed?
Please use the xl2bb add in (link below) to post a sample of your worksheet.
and welcome to the forum.

 

[awoohaw]

here are some ways to address your question:

Mr Excel 8.xlsm
	A	B	C	D	E	F
1
2		Helper Column:			FIND:	19
3	37				COUNT:	2
4	36		CONDITIONAL FORMAT FORMULA:			FALSE
5	48
6	9
7	38
8	19	Match
9	22
10	30
11	27
12	41
13	48
14	44
15	19	Match
16	46
17	11
18	10
19	26
20	45
21
Sheet9

Cell Formulas
Range	Formula
F3	F3	=COUNTIF($A$3:$A$20,F2)
F4	F4	=A3=$F$2
B3:B20	B3	=IF(A3=$F$2,"Match","")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:B20	Expression	=A3=$F$2	text	NO

 

[dbuck]

I don't want matching #'s. I want to know what #'s in a list add up to another value given in a different cell. An X or a word can be put in Column B.

 

[dbuck]

do you want a count of the matches? or do you want the text string in the cell changed?
Please use the xl2bb add in (link below) to post a sample of your worksheet.
and welcome to the forum.

No, I want to know what #'s in a particular list, add up and equal and single # in a different cell.

 

[awoohaw]

please use the xl2bb add in then. I asked for clarification of what you want. Your last statement just restates what you already have said which does not further clarify.

Images are not very useful in terms of calculations. In the image you posted, do the amounts in the first column sum to the amount in the target cell? IF not.. How do you manually figure out which numbers add up?

If you're trying to figure out which of the first column values are needed to get the target value you're asking for many pieces of a puzzle. I'm sure it can be done with a program using LAMBDA or even VBA, but my skills don't reach into that realm. Hopefully, someone else will make an attempt.

 

[dbuck]

please use the xl2bb add in then. I asked for clarification of what you want. Your last statement just restates what you already have said which does not further clarify.

Images are not very useful in terms of calculations. In the image you posted, do the amounts in the first column sum to the amount in the target cell? IF not.. How do you manually figure out which numbers add up?

If you're trying to figure out which of the first column values are needed to get the target value you're asking for many pieces of a puzzle. I'm sure it can be done with a program using LAMBDA or even VBA, but my skills don't reach into that realm. Hopefully, someone else will make an attempt.

I'm trying to figure out what #'s in the first column will add up to the # in the single cell. Could be 2 of them, could be 5 of them, could be 1 of them. Right now, I guess, trial and error. That's my problem, I spend too much time figuring it out. So I'm looking for an option to make it easier. Thanks.

 

[awoohaw]

Okay, that is beyond my skill. A LAMBDA function with recursion may get the answer for you. I think there are 16*15*14*13*12*11...*1 possible combinations.