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 06-04-2011
Member
 
Join Date: Mar 2011
Posts: 1,680
Comparing excel substrings columns

Hi. I am new to Computers and giving my level best to learn about it and gather the knowledge. Recently, I have been learning a lot about Microsoft Office. I am doing trial work for my dad on Excel sheet related to his business. In the process, I need to compare two sub strings but I am unable to it being a fresher in such types of work . What is the way to do so. Suggestions please.
Reply With Quote
  #2  
Old 06-04-2011
Member
 
Join Date: Mar 2009
Posts: 1,360
Re: Comparing excel substrings columns

Hey dude your question is incomplete, you should have given the example in which comparison is to be done. However, how much I can, I will guide you to make a way for you . Firstly, you need to enter the formula according to your problem where you are stuck up . You can do that by surfing on the web and compare it with your issue . Then go to editing group and then go to fill and finally click down. This will guide you in some way , I guess!!!
Reply With Quote
  #3  
Old 06-04-2011
Member
 
Join Date: Nov 2008
Posts: 1,259
Re: Comparing excel substrings columns

The most efficient technique I feel that you can compare the substrings is by using a wild card such as vlook up through the use of internet. . It will tell you about the matches which are probable and the ones which are not. Thus, it will give you the confidence how to move forward. Also, a custom method is can be useful, which will parse the information which is to be found out. Do, check this possibility also.
Reply With Quote
  #4  
Old 06-04-2011
Member
 
Join Date: May 2008
Posts: 979
Re: Comparing excel substrings columns

I agree to one of the replies above. You were needed to be specific by stating which version of Excel you are dealing with . Glancing to that reply is would like to make you clear, that the above reply was specifically for Microsoft Excel 2007, if in any case you are using excel 2003 or any of the previous version then, go to edit, click on Fill and then click down. You will get your desired result which you are looking for .
Reply With Quote
  #5  
Old 07-04-2011
Member
 
Join Date: Nov 2008
Posts: 996
Re: Comparing excel substrings columns

As you are new to computers I won’t specify you the method which I know as it would confuse you more and put you in more worries. . But as I per my computer knowledege , you would learn about programming languages and then you can resolve the problem by surfing on the internet. But, don’t even dare to look at it for the time being, as it is not the proper time . Thus thought to inform you for the future prospects.
Reply With Quote
Reply

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



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Comparing excel substrings columns"
Thread Thread Starter Forum Replies Last Post
How to multiply two columns in Excel Lanka Boy Windows Software 2 08-01-2012 03:06 AM
comparing cv and RSD in excel Aarti C Windows Software 1 07-01-2012 04:13 PM
Comparing columns and returning value Esmel Software Development 5 25-08-2010 10:54 PM
Macro to Add Columns in Excel geokilla Windows Software 3 15-10-2009 01:40 PM
Comparing Columns on different sheets jimbob9404 Windows Software 3 16-06-2009 05:01 AM


All times are GMT +5.5. The time now is 04:21 AM.