Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find all possible Difference between two sets of numbers
Hi
I have two set of number A B 72183 71368 76753 76090 76800 81442 76984 82613 77291 83583 80420 85581 84041 87851 106135 106139 109161 111424 Assuming they all start with row 1. I would like use every number in "B"-every number in "A". For example 71368-72183, 71368-76753 and so on until it reaches 84041 then I will use the next number 81442 - 72183, 81442-76753. Notice that all numbers in B are whole number and they can smaller or bigger than number in A. The total entries of A does not necessary as the same as B. After the difference is found, then I would like to filter out entries that give a difference of 4. Any inputs will be helpful. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find all possible Difference between two sets of numbers
Create a matrix with a horizontal axis of numbers from column B and a
vertical axis of numbers from column B, then subtract each intersection of the matrix. Apply conditional formatting to the matrix to highlight every cell which is = to 4. Assuming the horizontal axis is in B1:I1 and the vertical axis is in A2:A11, your first formula, in the upper left hand corner of the matrix, is =$A2-B$1, then fill down and to the right. Note that upon doing this I see you have no values of 4. You do, however, have a value of negative 4. Dave -- Brevity is the soul of wit. "Jason" wrote: Hi I have two set of number A B 72183 71368 76753 76090 76800 81442 76984 82613 77291 83583 80420 85581 84041 87851 106135 106139 109161 111424 Assuming they all start with row 1. I would like use every number in "B"-every number in "A". For example 71368-72183, 71368-76753 and so on until it reaches 84041 then I will use the next number 81442 - 72183, 81442-76753. Notice that all numbers in B are whole number and they can smaller or bigger than number in A. The total entries of A does not necessary as the same as B. After the difference is found, then I would like to filter out entries that give a difference of 4. Any inputs will be helpful. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find a % difference between two numbers (comparing 2005 . | Excel Worksheet Functions | |||
Find all numbers in database that end in... | Excel Worksheet Functions | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
find sum in list of of numbers | Excel Discussion (Misc queries) | |||
need to find which numbers (3+) in a column sum to a value | Excel Discussion (Misc queries) |