omp001
10-10-2019, 05:47 PM
A
B
C
D
E
1
value
fruit
animal
bird
water
2
4
yes
3
1
4
3
yes
yes
yes
5
2
yes
Hi all.
Please, I would like a formula to bring SMALL1, SMALL2, ...from A2:A5, if in B:E, same row, there is at least one text "yes".
In the case above the formula should return 2, 3 and 4 as it would be dragged dow in a column.
I know there's an easy way using an auxiliary column, but I would like not to go that way.
thanks in advance
B
C
D
E
1
value
fruit
animal
bird
water
2
4
yes
3
1
4
3
yes
yes
yes
5
2
yes
Hi all.
Please, I would like a formula to bring SMALL1, SMALL2, ...from A2:A5, if in B:E, same row, there is at least one text "yes".
In the case above the formula should return 2, 3 and 4 as it would be dragged dow in a column.
I know there's an easy way using an auxiliary column, but I would like not to go that way.
thanks in advance