Ask Experts Questions for FREE Help!
  Advanced
Register  |  Log in  
   Ask    
 Answer  
  Help  

Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
Free Answers in 3 Easy Steps

Register Now		 3 Steps

At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.

Home > Computers & Technology > Software > Spreadsheets   »   How to find the number in another column?

Answer this Question Ask about Spreadsheets
 
Thread Tools Display Modes
Question
 
 
#1  
Old Sep 19, 2008, 04:11 AM
tejutej
New Member
tejutej is offline 		 
Join Date: Sep 2008
Posts: 3
tejutej See this member's comment history on his/her Profile page.
How to find the number in another column?
Dear all,

I wanted to find the numbers of column B which are present in Column A?

Could any one provode the formula.

A B
201 35
211 53
21254 212
22 3256
35 201
25 635
53 656


Best Regards,
Tej

Reply With Quote
 
     

Answers
 
 
Old Sep 19, 2008, 04:16 AM   #2  
Senior & Palliative Care Expert
tickle is offline
 
tickle's Avatar
 
Join Date: Feb 2007
Location: Canada
Posts: 5,235
tickle See this member's comment history on his/her Profile page.tickle See this member's comment history on his/her Profile page.tickle See this member's comment history on his/her Profile page.tickle See this member's comment history on his/her Profile page.tickle See this member's comment history on his/her Profile page.
Cant you do it ?

Comments on this post
tejutej disagrees: not accurate
  Reply With Quote
 
     
 
 
Old Sep 19, 2008, 04:30 AM   #3  
New Member
tejutej is offline
 
Join Date: Sep 2008
Posts: 3
tejutej See this member's comment history on his/her Profile page.
Quote:
Originally Posted by tejutej
Dear all,

I wanted to find the numbers of column B which are present in Column A?

Could any one provode the formula.

A B
201 35
211 53
21254 212
22 3256
35 201
25 635
53 656


Best Regards,
Tej
Dear Tickle,

Please note that, just I have given a small example. I have a spreadsheet with more that 5000 rows...
Please help me in this regard.

Kind Reagrds,
Tej
  Reply With Quote
 
     
 
 
Old Sep 19, 2008, 05:25 AM   #4  
Senior & Palliative Care Expert
tickle is offline
 
tickle's Avatar
 
Join Date: Feb 2007
Location: Canada
Posts: 5,235
tickle See this member's comment history on his/her Profile page.tickle See this member's comment history on his/her Profile page.tickle See this member's comment history on his/her Profile page.tickle See this member's comment history on his/her Profile page.tickle See this member's comment history on his/her Profile page.
Why was my answer not accurate. Why do you need help doing this exercise? Cant you do it yourself ? I dont think that 'it is not accurate' is a proper response to my question.
  Reply With Quote
 
     
 
 
Old Sep 19, 2008, 07:47 AM   #5  
Software Expert
JBeaucaire is offline
 
JBeaucaire's Avatar
 
Join Date: Jan 2008
Location: (Call me JB) Bakersfield, CA
Posts: 4,171
JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.
Pay to call JBeaucaire for advice ($.75/min)
Call JBeaucaire via Skype™
How do you want to check? One number at a time for B? How do you want to show the answer? One answer each?
For example:
Code:
A      B      C
201    35     no
211    53     no
21254  212    no
22     3256   no
35     201    yes
25     635    no
53     656    no
Would that suffice?
  Reply With Quote
 
     
 
 
Old Sep 19, 2008, 08:43 AM   #6  
New Member
tejutej is offline
 
Join Date: Sep 2008
Posts: 3
tejutej See this member's comment history on his/her Profile page.
Thanks alot!

I wanted the numbers which are present in both column A as well as column B.

I also want the numbers which are present in column B but not in Column A.

Could this is possible? If yes Please provide the instructions.

Kind Regards,
Tej
  Reply With Quote
 
     
 
 
Old Sep 19, 2008, 09:48 AM   #7  
Software Expert
JBeaucaire is offline
 
JBeaucaire's Avatar
 
Join Date: Jan 2008
Location: (Call me JB) Bakersfield, CA
Posts: 4,171
JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.
Pay to call JBeaucaire for advice ($.75/min)
Call JBeaucaire via Skype™
You'll need to do this in two steps. The formula you want, based on your example, is:
Code:
=IF(ISERROR(VLOOKUP(B1,$A$1:$B$7,2,FALSE)),"no","yes")
(see the picture below)

After you enter the formula and copy it into column C for all entries, you'll have yes/no for each line. Now highlight ALL THREE columns, and SORT by column C (see the second part of the pic below). Now all the yes answers are together and you have all the numbers grouped.

Comments on this post
tejutej agrees: Thanks a lot! Its really wothful!
Attached Images
 
  Reply With Quote
 
     
 
 
Old Sep 20, 2008, 06:30 PM   #8  
Software Expert
JBeaucaire is offline
 
JBeaucaire's Avatar
 
Join Date: Jan 2008
Location: (Call me JB) Bakersfield, CA
Posts: 4,171
JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.
Pay to call JBeaucaire for advice ($.75/min)
Call JBeaucaire via Skype™
Another satisfied customer....chachacha...
  Reply With Quote
 
     
Answer this Question Ask about Spreadsheets

Bookmarks

« Previous Thread | Next Thread »

Thread Tools
Display Modes
Linear Mode Linear Mode

 
Similar Sponsors

Similar Threads
Question Asker Forum Answers Last Post
Can't find the VIN Number tamaradarice Real Estate Law 1 Sep 17, 2008 07:07 AM
find address from Fed ID number jerroy Communication 1 Jul 17, 2008 06:28 PM
I can't find the 192.168.2.1 number? Nzone25 Networking 2 May 30, 2008 11:03 AM
find next number in the sequence galactus Mathematics 4 Mar 25, 2007 06:38 PM
how to find unique values in an entire column younker1983 Spreadsheets 10 Aug 14, 2006 12:42 AM




Copyright ©2003 - 2007, Ask Me Help Desk.
All times are GMT -8. The time now is 07:51 PM.