Hello -
I have several grids on the same worksheet (2 are below) so I cant use entire columns in the formula
I need to be able to define specific data ranges
Columns A & B are the data and will contain duplicates which is needed
Looking for formulas
Need
Starting in C1, list all non blank values from Column B (I would like to exclude all blanks from the list)
- If C can be in alphabetical order great, if not, not critical)
Starting in D1, list the exact adjacent value from Column A
Logic:
C1 starts with Arizona (from B2), D1 then states what was in adjacent A2 (NOT A6)
C2 continues with Iowa (from B4), D2 then states what was in A4
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>
I have several grids on the same worksheet (2 are below) so I cant use entire columns in the formula
I need to be able to define specific data ranges
Columns A & B are the data and will contain duplicates which is needed
Looking for formulas
Need
Starting in C1, list all non blank values from Column B (I would like to exclude all blanks from the list)
- If C can be in alphabetical order great, if not, not critical)
Starting in D1, list the exact adjacent value from Column A
Logic:
C1 starts with Arizona (from B2), D1 then states what was in adjacent A2 (NOT A6)
C2 continues with Iowa (from B4), D2 then states what was in A4
A | B | C | D | |
1 | Bob | Arizona | Sarah | |
2 | Sarah | Arizona | Iowa | Jack |
3 | Sue | Maine | Will | |
4 | Jack | Iowa | Arizona | Tom |
5 | Will | Maine | ||
6 | Tom | Arizona | ||
7 | ||||
8 | ||||
9 | Joe | Colorado | Larry | |
10 | Larry | Colorado | Utah | Sam |
11 | Sam | Utah | Colorado | Michelle |
12 | Michelle | Colorado | Texas | Brad |
13 | Tim | |||
14 | Brad | Texas |
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>