Leap In Unemployment Rate Raises...
News2 mins ago
Automatically Filling Information In Excel Database
1 Answers
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!
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!
Answers
Only 1 answer
Best Answer
No best answer has yet been selected by abikau93. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
Like all MS Office applications, Excel is accompanied by the VBA scripting language. Turn on the developer ribbon and click the Visual Basic button.
Searching through random web pages is not viable because the structure of each page must be analysed before any information can be scraped from it. That is an advanced programming skill.
If you could download a list of male and female names it would be more plausible.
However without coding experience you are probably better off just working through the list manually unless it is very very large. There is quite a bit to understand before you will get far.
BTW Excel is not a database. It is a spreadsheet.
Searching through random web pages is not viable because the structure of each page must be analysed before any information can be scraped from it. That is an advanced programming skill.
If you could download a list of male and female names it would be more plausible.
However without coding experience you are probably better off just working through the list manually unless it is very very large. There is quite a bit to understand before you will get far.
BTW Excel is not a database. It is a spreadsheet.
Only 1 answer
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.