monicamarie
Board Regular
- Joined
- Sep 2, 2008
- Messages
- 72
- Office Version
- 365
I have a list of names and numbers in Column A. Below each name there is a cell with a number in it that I would like to return in Column B next to the name. The problem is that sometimes there are multiple cells in a row with numbers in them. See example below. I am looking for a way to have Excel look below the cell with the name and when it finds a cell with a number, return it to the adjacent cell above and to keep doing this until it sees a text value (name) and start over. Any help would be greatly appreciated.
Sample below shows desired results in columns B, C & D.
Sample below shows desired results in columns B, C & D.
Column/Row | A | B | C | D |
1 | Malloy, Peggy | 155 | ||
2 | 155 | |||
3 | Wilkins, Julia | 184 | ||
4 | 184 | |||
5 | Nadeau, Bill | 107 | 251 | |
6 | 107 | |||
7 | 251 | |||
8 | Ferreira, Carlos | 110 | ||
9 | 110 | |||
10 | Horwitz, Bruce | 115 | ||
11 | 115 | |||
12 | Ashline, Pam | 153 | 268 | 163 |
13 | 153 | |||
14 | 268 | |||
15 | 163 | |||
16 | Heitman, Chris | 161 | ||
17 | 161 | |||
18 | Tomao, Joe | 170 | ||
19 | 170 |