FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Excel question





rafifaisal
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 ? ? ?
AftershockVibe
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 Smile
infobankr
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?
otiscom
Yes, try to explain a little more what sort of comparison you intend.

Will it be say < or > or even = to ?
eefh1
I think, MATCH function would help you in this.

Check the syntax below :

MATCH(lookup_value,lookup_array,match_type)
Related topics
I Have a question . Is it the server support Chinese?
Question before requesting free hosting
question abt posts/mth
Kinda dumb question regarding DNS
A question
UT2004 U like the game? Do u have any question post here.
Question about DNS!
Question about Domain!
another uni.cc question
Question
Working with Excel, PHP & MySQL. Any Ideas
Autoconvert cells in Excel question
Where to write VBA in Excel?
Excel question
Reply to topic    Frihost Forum Index -> Computers -> Software

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.