chrismarince
New Member
- Joined
- Jul 16, 2012
- Messages
- 9
I have this spreadsheet...
<tbody>
</tbody>
I need to put a formula in E that says: compare Column D with Column B. For any cell in B that is equal to a cell in D, print the corresponding text from the cell in A in the cell in E. However, once a pair from B and D are found to match, they are no longer used for future comparisons.
I understand that sentence may not be entirely clear. I will show you what the end result should look like...
<tbody>
</tbody>
As you can see, the second "30" found in column D (D5) reads the time in Column A corresponding with the second "30" in column B (B9) as opposed to the first "30" in B (B4).
If this could be done with formulas as opposed to Marcos, that is preferable.
Thank you very much for your help!
A | B | C | D | E |
8:45 | 26 | 85 | ||
9:49 | 14 | 30 | ||
10:34 | 85 | 14 | ||
11:12 | 30 | 26 | ||
3:05 | 90 | 30 | ||
2:33 | 14 | 90 | ||
12:45 | 26 | 26 | ||
1:00 | 90 | 14 | ||
2:45 | 30 | 90 |
<tbody>
</tbody>
I need to put a formula in E that says: compare Column D with Column B. For any cell in B that is equal to a cell in D, print the corresponding text from the cell in A in the cell in E. However, once a pair from B and D are found to match, they are no longer used for future comparisons.
I understand that sentence may not be entirely clear. I will show you what the end result should look like...
A | B | C | D | E |
8:45 | 26 | 85 | 10:34 | |
9:49 | 14 | 30 | 11:12 | |
10:34 | 85 | 14 | 9:49 | |
11:12 | 30 | 26 | 8:45 | |
3:05 | 90 | 30 | 2:45 | |
2:33 | 14 | 90 | 3:05 | |
12:45 | 26 | 26 | 12:45 | |
1:00 | 90 | 14 | 2:33 | |
2:45 | 30 | 90 | 1:00 |
<tbody>
</tbody>
As you can see, the second "30" found in column D (D5) reads the time in Column A corresponding with the second "30" in column B (B9) as opposed to the first "30" in B (B4).
If this could be done with formulas as opposed to Marcos, that is preferable.
Thank you very much for your help!