Hi

Why not put the new number in the first empty cell in the column, then
sort the column.

Hopes this helps.
....
Per


On 15 Jul., 18:12, "greg" wrote:
Is there an easy excel formula that I can use that will find where a number
belongs in a series of numbers.
So for instance
in A1 to A 500 I have random numbers. *I can order them lowest to highest.
then I have a new single number.
Lets say it would go between 40 and 41
is there a excel formula that would help me on this?
to make it easy and the right way to do it.
instead of a lot of code?

thanks