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

 

[XOR LX]

Hi,

Are the two numbers in separate cells, as in your first post? Or in one cell, separated by e.g. a hypen: 114-120?

Regards

 

[ausafausaf]

1	100	It's mean 1 to 100
110	200	It's mean 110 to 200

<tbody>
</tbody>

Sir I want find value between 100 to 110. and want to display in colum C

Thanks

 

[XOR LX]

Where in column C? In separate cells? Or in a single cell, e.g. separated by commas?

Regards

 

[ausafausaf]

separate cells

 

[XOR LX]

Assuming the four numbers you give are in A1:B2, enter this formula in C1 and copy down until you start to get blanks for the result:

=IF(ROWS($1:1)>$A$2-$B$1-1,"",$B$1+ROWS($1:1))

Regards

 

[ausafausaf]

Thanks , nice
Thanks again

 

[XOR LX]

You're welcome.

 

[Rick Rothstein]

1	100	It's mean 1 to 100
110	200	It's mean 110 to 200

<tbody>
</tbody>

Sir I want find value between 100 to 110. and want to display in colum C

Wow, that is not even close to what you asked for in Message #1. I am glad XOR LX was able ask you the right questions in order to figure out what you actually wanted.