Forum Discussion
Solved
Fill the data for unknown points
Hi, Suppose I have a train that's driving away from a train station, and I've measured the speed at a certain distances from the station (in this case 1,5 and 7, but it could be any number of distan...
=BYROW(H3#,LAMBDA(row,IFNA(IF(XLOOKUP(row,D3:D5,E3:E5),XLOOKUP(row,D3:D5,E3:E5)),(row-XLOOKUP(row,D3:D5,D3:D5,,-1))*0.1*(OFFSET(row,1,0)-row)+XLOOKUP(row,D3:D5,E3:E5,,-1))))
You can try this formula for the calculation of speed.
=BYROW(H3#,LAMBDA(row,IFNA(IF(XLOOKUP(row,D3:D5,E3:E5),XLOOKUP(row,D3:D5,E3:E5)),(row-XLOOKUP(row,D3:D5,D3:D5,,-1))*0.1*(OFFSET(row,1,0)-row)+XLOOKUP(row,D3:D5,E3:E5,,-1))))
You can try this formula for the calculation of speed.