Hi there,

I am sorry if this has been asked before, but I don't know what to search for.

I have several files in which I have calculated the distance from points on a map to other features. There are nearly 1 million points, but I set it to only return entries in which the distance was less than 2500 meters. So say I have 350.000 entries in one file and 500.000 entries in another. However, I need a complete list with all points. So I thought I would need a new file with the ID numbers 1 to 1 million so that I can use the INDEX MATCH function.

So my question is, how do I make a list with numbers 1 to 1 million without dragging it for 2 days?

Thanks