I don't think that the multi-row formula should be that difficult to put together but I'm a little stuck. Below is what the data looks like now.
C1 | C2 | C3 | C4 | C5 |
Internal | SYSTEM FOR ESTIMATING | A10322 | 0919-175 | Brooklyn |
Internal | SYSTEM FOR DEPTH | A10333 | 0919-176 | Brooklyn |
External | SYSTEM FOR DEPTH | B10223 | 0919-215 | Brooklyn |
Internal | B11458 | 0919-177 | ||
Internal | Garments | C20459 | 0919-178 | Pittsburgh |
Internal | USING garments | C20562 | 0919-179 | Pittsburgh |
Internal | USING garments | C20562 | 0919-180 | Pittsburgh |
External | C20562 | 0919-211 |
I would like the blank spaces in [C2] and [C5] to fill what is above it, only if the letter/number combination in [C3] agrees to the one above it. If it does not, I would like the cell to stay blank. I'm getting lost writing my formula because of the dependency for [C2] blank cell and [C3] same row as blank cell has to equal C3 row above blank cell. This is what I put together so far.
IF IsEmpty([C2]) AND [C3]=??????
THEN [Row-1:C2]
ELSE [C2]
ENDIF
This is what the outcome should be.
C1 | C2 | C3 | C4 | C5 |
Internal | SYSTEM FOR ESTIMATING | A10322 | 0919-175 | Brooklyn |
Internal | SYSTEM FOR DEPTH | A10333 | 0919-176 | Brooklyn |
External | SYSTEM FOR DEPTH | B10223 | 0919-215 | Brooklyn |
Internal | B11458 | 0919-177 | ||
Internal | Garments | C20459 | 0919-178 | Pittsburgh |
Internal | USING garments | C20562 | 0919-179 | Pittsburgh |
Internal | USING garments | C20562 | 0919-180 | Pittsburgh |
External | USING garments | C20562 | 0919-211 | Pittsburgh |
Thanks for your help!
Solved! Go to Solution.
Thanks so much @Thableaus! Worked for me!
User | Count |
---|---|
17 | |
15 | |
15 | |
8 | |
5 |