co-ordinates

Hello Is it possible to have a formula that will check all the cells at left in the row, find the first cell that is not zero, and use its co-ordinates (eg A12) ? Thanks!

Picture this - I want to be able to create a (...non-VBA solution would be preferred...) table of X- and Y-coordinates based on user input for up to a 5x5 grid. The user enters the number of rows (say 2) and then the spacing between each. They do the same thing for number of columns (say 3) with...

Hi all, I am writing some code to fix up some survey information. The type of data I receive has a x, y and z co-ordinates for the same points, lets say a shot at the ground line, a shot at the top of a structure and shots part way up the structure. The software that will be importing this...

I want to use the charts to do the following: I have data where each data point has an "X" value, "Y" value (co-ordinates) and a "UR" value. These are in three columns, each data point is on a seperate row. Here is some dummy data (real data is a lot bigger): What I want to do is make a chart...

My problem relates to a computer model of a building. I have thousands of nodes output from the model each of which has stress values associated with it. Each nodes has an X, Y, Z value describing it's location in 3D space. The strength properties of the building are assigned in hundreds of...

Does anyone have a vba script to list the co-ordinates (latitude and longitude) of the activecell so that I can move the cursor to that position. I have the following script which lists the cursor position, but would like the cell position co-ordinates. Dim MyPointAPI As POINTAPI Private...