Data fill in excel
up vote
-1
down vote
favorite
I need help to fill empty cells in the Excel sheet.
enter image description here
if you look at the data, INNO_PS has value for 2011H1. I want to put the same value (yes/no) in the previous cell (next to 2010H2) of INNO_PS column if CompanyID is same. OR, I can make different column (say, INNO_pro) with the same condition.
How can I fill INNO_PS column or make a new column with the condition stated above? Please help.
microsoft-excel
asked 2 days ago
M Shafi
11
New contributor
M Shafi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
up vote
-1
down vote
favorite
I need help to fill empty cells in the Excel sheet.
enter image description here
if you look at the data, INNO_PS has value for 2011H1. I want to put the same value (yes/no) in the previous cell (next to 2010H2) of INNO_PS column if CompanyID is same. OR, I can make different column (say, INNO_pro) with the same condition.
How can I fill INNO_PS column or make a new column with the condition stated above? Please help.
microsoft-excel
asked 2 days ago
M Shafi
11
New contributor
M Shafi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Can you please edit you question to let us know what you've tried so far, what the expected output is exactly and where the problem is exactly? You may also want to clarify "...if CompanyID is same." -- the same as what?
– cybernetic.nomad
2 days ago
It is a panel datasheet. few companies have data for more than one wave. I want to fill INNO_PS variable. I have data only for 2011H1 wave but I need to same data in 2010H2 for same company (which is known as CompanyID). For example, CompanyID 6 has "No"for 2011H1 in INNO_PS variable, I need to put "NO" in 2010H2 for CompanyID 6. I do not need any value for the firm which has frequency 1 (for example CompanyID 5 or 11). They will be remaining blank.
– M Shafi
2 days ago
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I need help to fill empty cells in the Excel sheet.
enter image description here
if you look at the data, INNO_PS has value for 2011H1. I want to put the same value (yes/no) in the previous cell (next to 2010H2) of INNO_PS column if CompanyID is same. OR, I can make different column (say, INNO_pro) with the same condition.
How can I fill INNO_PS column or make a new column with the condition stated above? Please help.
microsoft-excel
asked 2 days ago
M Shafi
11
New contributor
M Shafi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I need help to fill empty cells in the Excel sheet.
enter image description here
if you look at the data, INNO_PS has value for 2011H1. I want to put the same value (yes/no) in the previous cell (next to 2010H2) of INNO_PS column if CompanyID is same. OR, I can make different column (say, INNO_pro) with the same condition.
How can I fill INNO_PS column or make a new column with the condition stated above? Please help.
microsoft-excel
microsoft-excel
asked 2 days ago
M Shafi
11
New contributor
M Shafi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 days ago
M Shafi
11
New contributor
M Shafi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 2 days ago
asked 2 days ago
M Shafi
11
New contributor
M Shafi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 days ago
M Shafi
11
asked 2 days ago
M Shafi
11
11
New contributor
M Shafi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
M Shafi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
M Shafi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Can you please edit you question to let us know what you've tried so far, what the expected output is exactly and where the problem is exactly? You may also want to clarify "...if CompanyID is same." -- the same as what?
– cybernetic.nomad
2 days ago
It is a panel datasheet. few companies have data for more than one wave. I want to fill INNO_PS variable. I have data only for 2011H1 wave but I need to same data in 2010H2 for same company (which is known as CompanyID). For example, CompanyID 6 has "No"for 2011H1 in INNO_PS variable, I need to put "NO" in 2010H2 for CompanyID 6. I do not need any value for the firm which has frequency 1 (for example CompanyID 5 or 11). They will be remaining blank.
– M Shafi
2 days ago
add a comment |
Can you please edit you question to let us know what you've tried so far, what the expected output is exactly and where the problem is exactly? You may also want to clarify "...if CompanyID is same." -- the same as what?
– cybernetic.nomad
2 days ago
It is a panel datasheet. few companies have data for more than one wave. I want to fill INNO_PS variable. I have data only for 2011H1 wave but I need to same data in 2010H2 for same company (which is known as CompanyID). For example, CompanyID 6 has "No"for 2011H1 in INNO_PS variable, I need to put "NO" in 2010H2 for CompanyID 6. I do not need any value for the firm which has frequency 1 (for example CompanyID 5 or 11). They will be remaining blank.
– M Shafi
2 days ago
Can you please edit you question to let us know what you've tried so far, what the expected output is exactly and where the problem is exactly? You may also want to clarify "...if CompanyID is same." -- the same as what?
– cybernetic.nomad
2 days ago
Can you please edit you question to let us know what you've tried so far, what the expected output is exactly and where the problem is exactly? You may also want to clarify "...if CompanyID is same." -- the same as what?
– cybernetic.nomad
2 days ago
It is a panel datasheet. few companies have data for more than one wave. I want to fill INNO_PS variable. I have data only for 2011H1 wave but I need to same data in 2010H2 for same company (which is known as CompanyID). For example, CompanyID 6 has "No"for 2011H1 in INNO_PS variable, I need to put "NO" in 2010H2 for CompanyID 6. I do not need any value for the firm which has frequency 1 (for example CompanyID 5 or 11). They will be remaining blank.
– M Shafi
2 days ago
It is a panel datasheet. few companies have data for more than one wave. I want to fill INNO_PS variable. I have data only for 2011H1 wave but I need to same data in 2010H2 for same company (which is known as CompanyID). For example, CompanyID 6 has "No"for 2011H1 in INNO_PS variable, I need to put "NO" in 2010H2 for CompanyID 6. I do not need any value for the firm which has frequency 1 (for example CompanyID 5 or 11). They will be remaining blank.
– M Shafi
2 days ago
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
M Shafi is a new contributor. Be nice, and check out our Code of Conduct.
M Shafi is a new contributor. Be nice, and check out our Code of Conduct.
M Shafi is a new contributor. Be nice, and check out our Code of Conduct.
M Shafi is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1376584%2fdata-fill-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Can you please edit you question to let us know what you've tried so far, what the expected output is exactly and where the problem is exactly? You may also want to clarify "...if CompanyID is same." -- the same as what?
– cybernetic.nomad
2 days ago
It is a panel datasheet. few companies have data for more than one wave. I want to fill INNO_PS variable. I have data only for 2011H1 wave but I need to same data in 2010H2 for same company (which is known as CompanyID). For example, CompanyID 6 has "No"for 2011H1 in INNO_PS variable, I need to put "NO" in 2010H2 for CompanyID 6. I do not need any value for the firm which has frequency 1 (for example CompanyID 5 or 11). They will be remaining blank.
– M Shafi
2 days ago