determine which number is not displayed

[dave2018]

in a1: 57
in a2: 35
in a3: 22

these numbers may change.

In c1 and c2 will be 2 of those numbers.
What is the most eficient formula in c3 to display the third number.


In addition, if in a vba code i have 2 variables, each with a different value from a1:a3. How do i get 3rd variable to be the other value?

Thank you.

 

[njimack]

Confirm with Ctrl+Shift+Enter:
=INDEX(A1:A3,MATCH(1,--ISERROR(MATCH(A1:A3,C1:C2,0)),0))

For your VBA query, it's probably easiest to loop through the range of cells and compare them to the variables, e.g

 For Each c in rng
If c <> var1 and c<>var2 Then
var3 = c
Exit For
End If

 

[Yongle]

formula in c3 to display the third number

=a1*(countif(b1:b2,a1)=0)+a2*(countif(b1:b2,a2)=0)+a3*(countif(b1:b2,a3)=0)