EXCEL recursivity

0

Good I have the following query, what I want to do is compare the absolute difference between two columns, where one column is full of data and the other lacks some, so the absolute difference of the column where it lacks the same data of the data column. Therefore I would like to know how to program with IF to recursively analyze the rows of these columns and in which there is a difference abs different from the same value that we have in the first column, take it into account while the other does not, the final purpose is to evaluate an average of the total difference. thanks (I have excel in English, but I do not think it matters)

    
asked by VRRM 27.12.2017 в 14:40
source

1 answer

1

You can do it using matrix formulas

note that the image has around the formula has some keys, so that the formula is matrix must have parameters as matrices and at the end of the editing of the formula press control + alt + enter

    
answered by 27.12.2017 / 15:50
source