FRIHOSTFORUMSSEARCHFAQTOSBLOGSDIRECTORY
You are invited to Log in or Register a 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
Autoconvert cells in Excel question
Working with Excel, PHP & MySQL. Any Ideas
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
Question abt lang. support...
question!!!!!!
A question about Naruto
C++ Question
PHPBB2 Question. (What MOD makes the featured announcements?
Good old question: What is the the best CMS
Petite question en php
Question to the Manager ? :)
A question from a n00b
Question about Domain name and add-on domain
PhPBB Question
question on html...
Reply to topic    Frihost Forum Index -> Computers -> Software

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