How_Do_I
Well-known Member
- Joined
- Oct 23, 2009
- Messages
- 1,831
- Office Version
- 2010
- Platform
- Windows
Hope I can explain this…
Column B and C are my data… I’m happy with the formula in Cell F4 downwards although I suspect that there’s an easier way to do this… Column G has my expected results in but I can’t work out the formula I need in Cell G4 downwards…
So B4 and B5 both have WM (39) 4 (they are meeting references) but this meeting produced a confidential Annex indicated in C4.
I want the formula to look in Column C, find the words “Confidential Annex” and give me those returns ignoring the numbers in brackets… I hope I’ve explained that well enough to get some assistance…
Sheet1
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:117px;"><col style="width:129px;"><col style="width:129px;"><col style="width:62px;"><col style="width:106px;"><col style="width:129px;"></colgroup><tbody>
</tbody>
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Column B and C are my data… I’m happy with the formula in Cell F4 downwards although I suspect that there’s an easier way to do this… Column G has my expected results in but I can’t work out the formula I need in Cell G4 downwards…
So B4 and B5 both have WM (39) 4 (they are meeting references) but this meeting produced a confidential Annex indicated in C4.
I want the formula to look in Column C, find the words “Confidential Annex” and give me those returns ignoring the numbers in brackets… I hope I’ve explained that well enough to get some assistance…
Sheet1
B | C | D | E | F | G | |
3 | Year | Annex | Meeting | WM (39) | Confidential Annex | |
4 | WM (39) 4 (1) | Confidential Annex | 3 | In Collection | ||
5 | WM (39) 4 | 4 | In Collection | In Collection | ||
6 | WM (39) 311 | 311 | In Collection | |||
7 | WM (39) 14 (1) (4) | Confidential Annex | 14 | In Collection | ||
8 | WM (39) 3 |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:117px;"><col style="width:129px;"><col style="width:129px;"><col style="width:62px;"><col style="width:106px;"><col style="width:129px;"></colgroup><tbody>
</tbody>
Spreadsheet Formulas | ||||||||||||
<tbody> </tbody> |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Last edited: