Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 07-04-2009
Member
 
Join Date: Nov 2008
Posts: 1,221
How to check if a number belongs to a column or not in Excel

I am on Excel. I would just like a formula that might check if a number belongs to a column or not.

Style:

= IF (A1 "is in column B," "YES"; "NO")

The question is: how to translate "belongs to in column B"?
Reply With Quote
  #2  
Old 07-04-2009
Member
 
Join Date: May 2008
Posts: 685
Re: How to check if a number belongs to a column or not in Excel

Good evening

= if (Column (A1) = 2; "Column B", "No column B") <(--- is necessarily the "No column B"...

The function column relates to column number and not the index "B"

To find "B" share a table with a match I can not tell you.

Best regards
Reply With Quote
  #3  
Old 07-04-2009
Member
 
Join Date: Nov 2008
Posts: 1,221
Re: How to check if a number belongs to a column or not in Excel

Hmmm ... I think it does not help me at all.

What is it a match?
Reply With Quote
  #4  
Old 07-04-2009
Member
 
Join Date: May 2008
Posts: 685
Re: How to check if a number belongs to a column or not in Excel

It can not help you at all, yet that is exactly what you require. So may be more accurate ... Because A1, before the cell is in column B, it will rain in a rainstorm ...

As = IF (A1 "is in column B," "YES"; "NO")
and
= if (Column (A1) = 2; "Column B", "No column B")

that's exactly what you want ...
Reply With Quote
  #5  
Old 07-04-2009
Member
 
Join Date: Feb 2008
Posts: 194
Re: How to check if a number belongs to a column or not in Excel

When you speak of A1 is a value to search, or it represents cell A1? A value, I suppose, since you are looking for a value in column B. What I want to do everything really does seem silly.

Let's say in column A, I have the following values:

1 2 3 4 5 6 7 8 9 10

And in column B, I:

3 4 6 8 9

The result in column C would be:

NO NO YES YES NO YES NO YES YES

In column C, for each line in column A, I would like to display "YES" if Ax is also in column B, and "NO" otherwise.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags:



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to check if a number belongs to a column or not in Excel"
Thread Thread Starter Forum Replies Last Post
What is the way to sum up number of column in Pivot Table Dvimida MS Office Support 2 09-02-2012 07:31 PM
Sort a row or column in MS Excel Itronix Tips & Tweaks 1 15-06-2011 09:52 AM
How to find particular column name by using Excel Macro Eleder Windows Software 5 05-04-2011 10:49 PM
How to count number of text occurences in Excel column Anas Windows Software 3 09-06-2009 05:01 PM
How to reverse column in excel Vishant Windows Software 2 09-06-2009 01:53 PM


All times are GMT +5.5. The time now is 08:49 PM.