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

Reply
 
Thread Tools Search this Thread
  #1  
Old 25-12-2009
Member
 
Join Date: Dec 2009
Posts: 66
Identifying common data in an excel sheet

In my Excel sheet column A, column B and column C have some data in it. I want to capture the data which is common and put the same into another column as shown under Result column in this following example. I am currently using the office 2007.
A B C D
data 1 data 2 data 3 Result
Bulb Cap Pipe Bulb
bat bat Cap Cap
Pipe Bulb bat Pipe
ball ball ball bat
Chair Mat Chair ball
Mat Chair Mat Chair
Cap Pipe Bulb Mat

please guide me in this matter?
Reply With Quote
  #2  
Old 25-12-2009
Member
 
Join Date: May 2008
Posts: 3,313
Re: Identifying common data in an excel sheet

Actually i am unable to understand what you want

A B C D
data 1 data 2 data 3 Result
Bulb Cap Pipe Bulb
bat bat Cap Cap
Pipe Bulb bat Pipe
ball ball ball bat
Chair Mat Chair ball
Mat Chair Mat Chair
Cap Pipe Bulb Mat

If we consider the first row there are no common items but the Bulb is listed in the result column.
similarly the in the next row bat appears twice but the result column shows cap.
in the fourth row the result column shows bat but the ball appears thrice in the row.
Please convey your message properly i cannot understand what are you trying to say.
Reply With Quote
  #3  
Old 25-12-2009
Member
 
Join Date: Dec 2009
Posts: 66
Re: Identifying common data in an excel sheet

Anyway thanks for replying . Firstly I could resolve this issue usimg the Advanced filter option in data. As far as my example is concerned please read it column wise and not row wise. The data1,data2 and data3 are columns . I want the last column as result as i had shown it in the example. Any help in this regard would be appreciated
Reply With Quote
  #4  
Old 25-12-2009
Member
 
Join Date: Apr 2008
Posts: 2,139
Re: Identifying common data in an excel sheet

I think tou are looking for data which are common but you want the result in different column. I think if you stick to the bottom fo each column for the result it would make more sense. in the exanple above you have 7 results for 3 columns. Try to make your point more clear since i am not getting it clearly or are you looking to list the unique values. Reading the result column, column-wise does not make any sense to the problem.
Reply With Quote
  #5  
Old 25-12-2009
Member
 
Join Date: May 2008
Posts: 4,829
Re: Identifying common data in an excel sheet

I am also unable to understand your goal. please make it clear the first value in the result column is 'bulb'. When i tried to understand your logic i can't understand why the 'CAP' is not appearing first although its the first value to repeat itself.
Reply With Quote
  #6  
Old 25-12-2009
Member
 
Join Date: Dec 2009
Posts: 66
Re: Identifying common data in an excel sheet

I don't know why nobody understands what actually i am try to do. I just want to identify the common data from each column of my excel sheet. Once again i would like to make it clear that please try to read the example column-wise and not row-wise
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Identifying common data in an excel sheet"
Thread Thread Starter Forum Replies Last Post
Is there a way to populate one sheet data from another in Excel M.N.S MS Office Support 2 23-02-2012 05:55 PM
How to insert common data from on Excel File to another Rish!On MS Office Support 2 17-02-2012 02:10 PM
How to add data in Excel when sheet protection is activated Lanka Boy Microsoft Project 2 08-01-2012 09:14 PM
How to insert HyperTerminal data into excel sheet. Shaina Na Microsoft Project 1 08-01-2012 07:44 PM
Parsing data in Excel Sheet Ossi Windows Software 4 04-02-2011 07:55 AM


All times are GMT +5.5. The time now is 12:58 PM.