find missing value

[ausafausaf]

I want to find missing value between to colum. like this

1	3	how can I find value 2 between 1 and 3
4	8	and 5,6,7 between 4 and 8

<tbody>
</tbody>

please any one tell me the formula for this.
please help

 

[Rick Rothstein]

I want to find missing value between to colum. like this

1	3	how can I find value 2 between 1 and 3
4	8	and 5,6,7 between 4 and 8

<tbody>
</tbody>

please any one tell me the formula for this.

Assuming your data is in Columns A and B starting on Row 1, put this formula in C1 and copy it across for as many columns as you think you will ever have need for, then copy all those cells down to the end of your data...

=IF($A1+COLUMN(A1)<$B1,$A1+COLUMN(A1),"")

 

[ausafausaf]

thanks thanks
and if I want to display 5, 6, 7, Separately from 4 to 8 ?

 

[Rick Rothstein]

...and if I want to display 5, 6, 7, Separately from 4 to 8 ?

I don't understand your question... the numbers 5, 6 and 7 are in separate cells from 4 and 8.

 

[ausafausaf]

in 4 to 8 missing value are 5, 6, 7 I want to display in separate cell

 

[ausafausaf]

Please I will explain ,, what I want
1-110
115-120 please look between 110 to 115 the value 111 from 114 are missing how can I display in column C

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[Rick Rothstein]

in 4 to 8 missing value are 5, 6, 7 I want to display in separate cell

Do you mean you want the 5, 6 and 7 to all appear in one cell (perhaps with a comma-space separating them)? If so, you will not be able to do that with a formula for the general case... you will need a UDF (a user defined function) created in VB code. However, you said you wanted a formula initially, so before I write the UDF, would you be able to use it being that it is not the formula solution you asked for?

 

[ausafausaf]

No not in VB code.
thanks Dear

 

[Rick Rothstein]

No not in VB code.
thanks Dear

What is the absolute maximum difference you will ever have between your numbers?

 

[ausafausaf]

Sorry about my English
I can't explain properly