2
   

Automatically filling information in Excel Database

 
 
Reply Thu 9 May, 2013 03:48 pm
Hello,

I have to do an analysis on an online membership database within excel, but for some reason, some of the cells under the Gender column remain unfilled. Instead of manually filling each cell in, I would like to be able to do it automatically, where a code checks male and female naming dictionary and, if the first name of the member matches a male entry in the dictionary, to enter “Male” or “Female” in the corresponding cell (and if the code can’t find the name to leave it blank – I would elect to do this instead of using, say, the male dictionary and making all names that can’t be found female because some of the names are foreign and probably can’t be found in the dictionary) I do not have any coding experience, so if I could get guidance of some kind (a viable programming language for this task, general outline of the code, how to search multiple web pages, etc) before starting this project, I would highly appreciate it!
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 2 • Views: 2,110 • Replies: 2
No top replies

 
roger
 
  1  
Reply Thu 9 May, 2013 04:05 pm
@abikau93,
It's probably going to involve a lookup table, but it is not going to be useful. There are simply too many ambiguous names. Dale comes to mind. Is Dale a male name, or female. Often, wrong information is worse than no information.
0 Replies
 
engineer
 
  1  
Reply Thu 9 May, 2013 04:20 pm
@abikau93,
You don't have to use code, just a lookup table as mentioned above and a conditional statement in the cell. Something like:

IF(LOOKUP("Suzy", FEMALE_NAMES)="Suzy", "FEMALE", IF(LOOKUP("Suzy", MALE_NAMES)="Suzy", "MALE",""))
0 Replies
 
 

Related Topics

Clone of Micosoft Office - Question by Advocate
Do You Turn Off Your Computer at Night? - Discussion by Phoenix32890
The "Death" of the Computer Mouse - Discussion by Phoenix32890
Windows 10... - Discussion by Region Philbis
Surface Pro 3: What do you think? - Question by neologist
Windows 8 tips thread - Discussion by Wilso
GOOGLE CHROME - Question by Setanta
.Net and Firefox... - Discussion by gungasnake
Hacking a computer and remote access - Discussion by trying2learn
 
  1. Forums
  2. » Automatically filling information in Excel Database
Copyright © 2024 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.09 seconds on 12/13/2024 at 08:22:47