If one cell has certain value other cell will have that exact value

[fahadferoz]

Please have a look at the file and help me solve the problem

 

[Eloise T]

I saw your spreadsheet. What is the problem you are looking to solve?

 

[SirJB7]

Hi, fahadferoz!
I agree with Eloise T. As per your uploaded file you can keep entering values in D2, and placing this formula in D3:D5: =D2
Regards!

 

[fahadferoz]

I saw your spreadsheet. What is the problem you are looking to solve?

I wanted to ask if there is any formula available cause the original file is really huge. It is nearly impossible to manually do the work.

Eloise T: The problem is the value (D2) right beside the Mean Score (C2) is correct. However, the values of cell D3, D4 and D5 also needed to be same as the of C2. But the original file has somehow the wrong data. The file consists of almost 11000 rows which is literally impossible for me to do the work manually.
If you look inside the excel file and provide a formula for that I would be grateful.

 

[bosco_yip]

I wanted to ask if there is any formula available cause the original file is really huge. It is nearly impossible to manually do the work.

Eloise T: The problem is the value (D2) right beside the Mean Score (C2) is correct. However, the values of cell D3, D4 and D5 also needed to be same as the of C2. But the original file has somehow the wrong data. The file consists of almost 11000 rows which is literally impossible for me to do the work manually.
If you look inside the excel file and provide a formula for that I would be grateful.

Maybe, try to add a helper column E

1] In E1, copy down to E2 :

=D1

2] In E3, copy down until blank :

=IF(C3="","",IF(C3="Mean score",D3,E2))

3] Column E has applied Conditioal Formatting to highlight the repetition.

4] Hide column D for keeping the original record

5] See attachment

Regards
Bosco

 

[fahadferoz]

THANKS A LOTTTT....
God bless you