3 Cells take a particular cell value (Problem)

[fahadferoz]

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.

EThe 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.

 

[PCosta87]

Hi,

I'm not sure I understood the requirement but the data in "B" seems to be the deciding factor so I used a simple IF to do what you want.

Attached, please let me know if that is what you want.

 

[Marc L]

As here it is very not the Excel formula forum but VBA Macros …
​

 

[SirJB7]

Hi, fahadferoz!
Is this the same issue or directly relationed to this one?
http://chandoo.org/forum/threads/if...-other-cell-will-have-that-exact-value.34239/
If so, next time continue at the original one so as people who might help you have a better scope of the problem. If not, discard this message, thank you.
Regards!