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
New contributor
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
New contributor
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
Nov 19 at 15:14
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
Nov 19 at 19:09
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
New contributor
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
New contributor
New contributor
edited Nov 19 at 3:03
New contributor
asked Nov 19 at 2:52
M Shafi
11
11
New contributor
New contributor
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
Nov 19 at 15:14
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
Nov 19 at 19:09
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
Nov 19 at 15:14
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
Nov 19 at 19:09
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
Nov 19 at 15:14
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
Nov 19 at 15:14
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
Nov 19 at 19:09
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
Nov 19 at 19:09
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
Nov 19 at 15:14
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
Nov 19 at 19:09