LinkBack URL
About LinkBacks
hi,
I have a list of numbers from 1 to 50
Is the formula to find the numbers from the list, the sum of a number is the same.
for example :
column a columnb**** column(a)+column(b)=10
1 9
2 8
3 7
4 6
5 5
hi,
I have a list of numbers from 1 to 50
Is the formula to find the numbers from the list, the sum of a number is the same.
for example :
column a columnb**** column(a)+column(b)=10
1 9
2 8
3 7
4 6
5 5
Hi,
Can you clarify. Do you have a number, 10 in this example and you want to find all the pairs that add to that number OR do you want to find ALL the pair sums where there are at least two the same? i.e. with
1 13
7 7
5 6
4 9
6 8
8 3
Would you want to find pairs, 1,2,3,5 & 6
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Or try these
=IF(A2+B2=10,"Yes","")
Thanks
The similarity is not important numbers like all numbers from the list that sum, say 10 or any arbitrary number I've gotten.
My favorite is just the number does not matter what the numbers are.
I have just hope your order.
column a*** columnb**** column(a)+column(b)=15
1***** 14
2 *****13
3*****12
4*****11
5*****10
6*****9
7*****8
Last edited by wiliam_s; 12-20-2015 at 11:02 AM.
It seems that you want to populate column B with the difference between the number in column A and an arbitrary number. If so try the formulawhere 15 can be substituted for by any arbitrary number.
Please Login or Register to view this content.
Let me know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
I missed my goal
All possibilities to obtain the sum of two numbers that have the same result.
To avoid us all guessing what you actually want please upload an example with several rows of real data. Then manually add the results you expect and tell us which ranges are data and which ranges are results. And if it's not blindingly obvious how you have arrive at the results.
With special thanks
See sample file.
See if this does what you want: Static Sum Addition.xlsx
Column B is populated using the formula:Column C is populated using the formula:Please Login or Register to view this content.Change to value in D2 to see how the formulas work.Please Login or Register to view this content.
Let me know if you have any questions.
Hi
Change the value in E38 and see the results
See the file Sample (3).xlsx
Made an improvement, I believe, by adding the following formula to Column A beginning with A2:And changing the formula in Column B to:Please Login or Register to view this content.Static Sum Addition.xlsxPlease Login or Register to view this content.
Let me know if you have any questions.
Hi,
One way in B1 copied down,
Formula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks