D
Don DuRousseau
A B C D
1 Range 1 Input Input 2 Result 1
2 1 2 4 1 => MODE(A2:A4)
3 2 4 6 4 => MODE(A4:A6)
4 1 7 10 3 => MODE(A7:A10)
5 4
6 4
7 3
8 3
9 4
10 2
What is the best way to use the row values under Input 1
and Input 2 as the numeric part of the variables in the
Result 1 expression: MODE(A"2":A"4"). Where "2" and "4"
are inserted as the values in the fields "B2" and "C2"?
1 Range 1 Input Input 2 Result 1
2 1 2 4 1 => MODE(A2:A4)
3 2 4 6 4 => MODE(A4:A6)
4 1 7 10 3 => MODE(A7:A10)
5 4
6 4
7 3
8 3
9 4
10 2
What is the best way to use the row values under Input 1
and Input 2 as the numeric part of the variables in the
Result 1 expression: MODE(A"2":A"4"). Where "2" and "4"
are inserted as the values in the fields "B2" and "C2"?