Hi Folks. I have a good thousand or two rows of data that looks something like this. The first column is utilizing formula:
=IF(AND(ISERROR(SEARCH("-",D3)),LEN(D3)>6),D3,"")
to pull only names from Column B, otherwise returning blanks.
What I ultimately need is for column A to have, for example (in the first two rows), the name 'Schultz, Paul' populated for the first two rows until a new name (Crawford, Benny) appears, then repeat.
So if you see a 6-digit ID # in the second column, I need the formula to populate in Column A the Last, First name of the person to the immediate left of the 6-digit ID #. For example, the first digit 800187 should show Schultz, Paul to the left in Column A and so forth. / Halp?
Here is what the data originally looks like:
<tbody>
</tbody>
Here is what I need the data to look like, with Column A populated via formulas.
<tbody>
</tbody>
=IF(AND(ISERROR(SEARCH("-",D3)),LEN(D3)>6),D3,"")
to pull only names from Column B, otherwise returning blanks.
What I ultimately need is for column A to have, for example (in the first two rows), the name 'Schultz, Paul' populated for the first two rows until a new name (Crawford, Benny) appears, then repeat.
So if you see a 6-digit ID # in the second column, I need the formula to populate in Column A the Last, First name of the person to the immediate left of the 6-digit ID #. For example, the first digit 800187 should show Schultz, Paul to the left in Column A and so forth. / Halp?
Here is what the data originally looks like:
Schultz, Paul | |
800187 | |
Crawford, Benny | |
800638 | |
Smith, Tim | |
800144 | |
NS-ISP IMPLEMENTATION | |
Alt, Michael | |
795979 | |
Faircloth, Larry | |
795403 | |
800769 | |
800014 | |
799261 | |
800763 | |
<tbody>
</tbody>
Here is what I need the data to look like, with Column A populated via formulas.
Schultz, Paul | Schultz, Paul |
Schultz, Paul | 800187 |
Crawford, Benny | Crawford, Benny |
Crawford, Benny | 800638 |
Smith, Tim | Smith, Tim |
Smith, Tim | 800144 |
NS-ISP IMPLEMENTATION | NS-ISP IMPLEMENTATION |
Alt, Michael | Alt, Michael |
Alt, Michael | 795979 |
Faircloth, Larry | Faircloth, Larry |
Faircloth, Larry | 795403 |
Faircloth, Larry | 800769 |
Faircloth, Larry | 800014 |
Faircloth, Larry | 799261 |
Faircloth, Larry | 800763 |
<tbody>
</tbody>
Last edited: