Could you please tell me why i cant do it sideways? It works vertically but it doesnt horizontaly Edit: nevermind i just tried it again and it worked!! thank you because i went through 11 videos trying to find one that works for me
S F S F 1 second ago this a very nice and easy way, but i need to use the same principle where i want to calculate the distance between any two airports and having the airport code in the top row and the left column and use a formula that picks up the longitude and the latitude of the airport using vlookup from a table having the longitude and latitude of the airports and then come with a similar table like what you have having the distance between any
Hi S F, sorry 🙁....but try a post on the mrexcel.com forum! It's going to deal with SIN & COSINE calculations so put a post on there to see what you get.
GOOD EXPLANATION DUDE
thank you
You're welcome!
Thank you!
You're Welcome!
Thankyou !
You're Welcome!
Could you please tell me why i cant do it sideways? It works vertically but it doesnt horizontaly
Edit: nevermind i just tried it again and it worked!! thank you because i went through 11 videos trying to find one that works for me
Hi Dans Alens Šķenders, thanks for the comment!
S F
S F
1 second ago
this a very nice and easy way, but i need to use the same principle where i want to calculate the distance between any two airports and having the airport code in the top row and the left column and use a formula that picks up the longitude and the latitude of the airport using vlookup from a table having the longitude and latitude of the airports and then come with a similar table like what you have having the distance between any
Hi S F, sorry 🙁....but try a post on the mrexcel.com forum! It's going to deal with SIN & COSINE calculations so put a post on there to see what you get.