Hi all,
I am looking for a formula that compares numbers in column B with numbers in column A
Maybe in column C I get the numbers that dont figure in column A ? ? ?
I'm not sure exactly what you mean in your question, you don't say how you want to "compare" or what you mean by "numbers that don't figure".
However, what you're probably looking for is somthing like this in column C
| Code: |
| =IF(A1=B1, "Yes", "No") |
Then in column C you'll get "Yes" if the values are equal, otherwise "No".
If this isn't quite what you meant then you can modify it easily... syntax is just =IF(condition, Output If True, Output If False). You can put expressions to evaluate in the output parameters as well, not just the condition.
Hope this helps 
What type of comparison? The above example compares them for equality, but you could compare them in a multitude of ways. What are you trying to accomplish?
Yes, try to explain a little more what sort of comparison you intend.
Will it be say < or > or even = to ?
I think, MATCH function would help you in this.
Check the syntax below :
MATCH(lookup_value,lookup_array,match_type)
