Home » Forums » Open Source Learning Center » Question and Answer

Match Arrays value and interpolate

shiv77patil's picture
Submitted by shiv77patil on 7 September, 2012 - 17:29

Hi
I have two arrays say Xi(1000) and Yi(1000), I want to use match function in vba and find Match(Xlval,Xi(),-1),Match(Xlval,Xi(),1) so that i have x ordinate and in the same way I will find y ordinate and interpolate. Can i do this and how I should go to achive this

Please help me

‹ Arrange (Cut and Insert Cut Cells) Rows using VBA Code Substract 2 "yyyy/mm/dd hh:mm:ss" to obtain duration in "hh:mm:ss" ›
»
Nick's picture

can you give us an example of

Submitted by Nick on 10 September, 2012 - 10:01.

can you give us an example of the array, the input and the output..
also, take a look at this:
http://excelexperts.com/Excel-For-Finance-Tips-Interpolation
(not VBA, but might be useful)
tks

»