Hello Friends,
If possible, what formula should I use to give the below list a dynamic range
In this case I want the name manger to look at cells (B2:B8) but ignore where the adjacent cell contains word *Total*
If I simply use offset then it picks the entire range B2:B8
But I want name list to ignore cells B5 & B8
Pls note that the word *Total* can come in any of the cells in the entire range (A2:A8) as its a result of formula
If possible, what formula should I use to give the below list a dynamic range
In this case I want the name manger to look at cells (B2:B8) but ignore where the adjacent cell contains word *Total*
If I simply use offset then it picks the entire range B2:B8
Excel Formula:
=OFFSET(Sheet1!$A$2:$A$8,0,1)
Pls note that the word *Total* can come in any of the cells in the entire range (A2:A8) as its a result of formula
Book2 | ||||
---|---|---|---|---|
A | B | |||
1 | Description | |||
2 | Apples | |||
3 | Apples | |||
4 | Apples | |||
5 | Total Apples | |||
6 | Bananas | |||
7 | Bananas | |||
8 | Total Bananas | |||
Sheet1 |