OfficeUser
Well-known Member
- Joined
- Feb 4, 2010
- Messages
- 542
- Office Version
- 365
- 2016
- Platform
- Windows
Hopefully I can explain properly, so here goes.
In column A:C I have data in some cells while others are blank.
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
I am looking for a way to look at the row the blank cell is in, compare the value in C to the one above it, and if the same populate the value in B with the one above it. It would look like this:
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
If they dont match then it simply stays blank. I would want to do this for rows 1:10000. Any ideas how to do this using a formula or a macro? Thank You!
In column A:C I have data in some cells while others are blank.
Red | Q30 | 1 |
Blue | 2 | |
Green | QX70 | 3 |
Yellow | QX70 | 3 |
White | FX50S | 4 |
Purple | Q50 | 5 |
Black | FX35 | 6 |
Gray | 6 | |
White | 6 | |
Orange | 6 | |
Teal | QX80 | 7 |
Violet | 8 | |
Tan | Q50 | 9 |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
I am looking for a way to look at the row the blank cell is in, compare the value in C to the one above it, and if the same populate the value in B with the one above it. It would look like this:
Red | Q30 | 1 |
Blue | 2 | |
Green | QX70 | 3 |
Yellow | QX70 | 3 |
White | FX50S | 4 |
Purple | Q50 | 5 |
Black | FX35 | 6 |
Gray | FX35 | 6 |
White | FX35 | 6 |
Orange | FX35 | 6 |
Teal | QX80 | 7 |
Violet | 8 | |
Tan | Q50 | 9 |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
If they dont match then it simply stays blank. I would want to do this for rows 1:10000. Any ideas how to do this using a formula or a macro? Thank You!