bluevelvet113
New Member
- Joined
- Apr 14, 2021
- Messages
- 4
- Office Version
- 365
- Platform
- MacOS
Hello everyone,
I have an Excel document which lists anonymous participants for a case study. Each participant has been assigned an ID number (e.g. ID: 1). The ID numbers are listed in Column A. The corresponding columns each provide demographic information (e.g. gender, race) and the participants' education background (e.g. college graduate) but instead of these terms being written out, they have been assigned a code. For example, 1=female, 0=male, 8=High School graduate, 9=College graduate.
I would like to have the codes retroactively populate with the corresponding demographic information. For example, change all '1' to read 'female', '8' to read 'High School graduate'. The challenge with this, however, is that the numerical codes can have a different text equivalents depending on the 'demographic information' in each column. For example, in the Gender column (Column B) '1'=female, yet in the Native Language ('Natlang') column (Column C), '1'=English.
I've attached a screenshot for reference. Please let me know if there is a way to do this. By the way, I'm also a basic Excel user so an easy tutorial would be helpful if possible! Thank you!
I have an Excel document which lists anonymous participants for a case study. Each participant has been assigned an ID number (e.g. ID: 1). The ID numbers are listed in Column A. The corresponding columns each provide demographic information (e.g. gender, race) and the participants' education background (e.g. college graduate) but instead of these terms being written out, they have been assigned a code. For example, 1=female, 0=male, 8=High School graduate, 9=College graduate.
I would like to have the codes retroactively populate with the corresponding demographic information. For example, change all '1' to read 'female', '8' to read 'High School graduate'. The challenge with this, however, is that the numerical codes can have a different text equivalents depending on the 'demographic information' in each column. For example, in the Gender column (Column B) '1'=female, yet in the Native Language ('Natlang') column (Column C), '1'=English.
I've attached a screenshot for reference. Please let me know if there is a way to do this. By the way, I'm also a basic Excel user so an easy tutorial would be helpful if possible! Thank you!