Return an array of numbers

Is there a function or formula that that can return an array of numbers to a single cell? In other words, the formula would look at specific info, constants, variables, and then perform a calculation based on that criteria and return a group of numbers, each separated by a comma, into a single cell. Any help would be greatly appreciated. Thanks.

Roy

I'm not really trying to be silly. I'm running a program that uses Excel as its spreadsheet platform. It is a CAM program that generates machining for cabinet parts. It uses AutoCAD as its cad portion of the program. What I'm looking for is a way to generate a sequence of numbers that are coordinates for construction boring. As it sits right now, the program looks to a global variable for its sequence of coordinates but they are hard coded and so are limited to the number of coordinates that are listed. What I'm proposing is to have the global variable use a formula that looks a the part size and the calculates how many holes are needed for that length of part and returns the coordinates for those holes. I don't know, maybe its just wishful thinking.

Roy

Hello Roy,

What you want might be possible with formulas but in general it's easier to return an array of numbers to a range of cells rather than a single one because Excel doesn't have any native formulas that can concatenate a range (or array).

Can you explain how the formula would work to generate the co-ordinates?

The first thing it would look at would be a local variable that references the length of the part. It would then take that value and divide it by the value in a Global variable which would be the distance between the holes. The returned value would be the number of holes needed. The first hole is always an inch from the front edge of the part. Each subsequent hole would have a cumulative value of the hole distance Global variable added to 1. For example, if the distance between holes was 3, the first value would be 1, the next 4, then 7..etc. The desired syntax would be: 1,4,7,10,13 etc. The formula would have to be like a VB loop that would continue to calculate until the number of holes was reached. I just don't know how to get it to display a series of numbers separated by commas.

Roy