Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Excel 2010 help


  • Please log in to reply
3 replies to this topic

#1 krneki

krneki

  • Members
  • 19 posts
  • OFFLINE
  •  
  • Local time:07:58 AM

Posted 19 May 2012 - 09:21 AM

I have a document in Excel 2010 which contains 2 columns. Data from 2nd column is constant, does not change and is assigned to data in 1st column. Names and surnames are great example, so I will use this case for explanation.

Currently there are 200 unique names in 1st column and of course 200 surnames, attached to them in every row. There won't be any new names ever.

This is functionality I'd like to have. I often have to copy some of those names from external database (software) in various numbers. Let's say 50 random names to 1st column. But when I do that, I have to manually write down surnames to 2nd column, because they come from another database (software) which is not synchronized with the first one, so I cant just copy/paste them.

Is there any way to save (connect?) all 200 surnames to all 200 names in Excel, so when I would copy some of names from external database to 1st column, Excel would automatically attach appropriate surname to 2nd row?

I hope I was clear. Thanks for help in advance!

Edited by krneki, 19 May 2012 - 10:09 AM.


BC AdBot (Login to Remove)

 


#2 Budapest

Budapest

    Bleepin' Cynic


  • Moderator
  • 23,579 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:09:58 PM

Posted 21 May 2012 - 04:59 PM

I'm not sure I understand 100% what you are trying to do; however, I think you could achieve this using a VLOOKUP function.
The power of accurate observation is commonly called cynicism by those who haven't got it.

—George Bernard Shaw

#3 krneki

krneki
  • Topic Starter

  • Members
  • 19 posts
  • OFFLINE
  •  
  • Local time:07:58 AM

Posted 24 May 2012 - 04:14 PM

Sorry for the delay.

Here is a simplified example: http://dl.dropbox.com/u/18516025/excel_example.xlsx . I think it's pretty self explanatory. In the first tab, there is a constant database of all the companies and their assigned numbers. There are going to be several months (2nd and 3rd tabs are just for an example). I explained everything else in the first post.

Could you do a concrete example of my case and upload is somewhere, so I can take a closer look at it? Thanks in advance.

Edited by krneki, 24 May 2012 - 04:28 PM.


#4 Budapest

Budapest

    Bleepin' Cynic


  • Moderator
  • 23,579 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:09:58 PM

Posted 24 May 2012 - 04:27 PM

I filled in some of the cells in the January tab. Is this what you were after.

http://www.bleepstatic.com/fhost/uploads/1/excel_example.xlsx
The power of accurate observation is commonly called cynicism by those who haven't got it.

—George Bernard Shaw




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users