If you have a recent version of Excel you can have a formula that pulls from
a different sheet.

so if the rows are "lined up" that is that row 7 on "Propoased sheet" is the
same item as row 7 on the "actual" sheet then :

on the actual sheet in cell D7 the formula
=ProposedSheet!C7 - C7
will return the difference between your proposed and actual elevation. copy
down to all other 499 rows


"amharan" wrote:

i have some other data in proposed sheet (7 columns) but i guess i can make
it 3 columns and later add it. actual data has only 3 columns.
thanks

"Vacation's Over" wrote:

Still more...

Do you have a sheet of proposed data 500 rows by 3 columns?

and a new sheet of data of actual data set up the same way?

"amharan" wrote:

I was trying to match these coordinate values (proposed)

-125.75 245.19 -3.8795

with these

-125.781 245.203 -3.934

numbers dosent have to exact as but the difference must be minimal as per
the example. i am new to excel so i was trying to do it manual, but i have to
replace almost 1500 points.

the first two columns are cordinates and third is elevation. we were hoping
to find out how much is the difference between the elevations.

thank you

"Vacation's Over" wrote:

Use specifics. Many of us are not mind readers :)

what do you want to do?
What have you tried?
What did not work?

"amharan" wrote:

Hi I was trying to replace prposed coordinates with the actual coordinates
with elevations. any ideas welcome.