PDA

View Full Version : small with condition



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

omp001
10-12-2019, 07:11 AM
Please, would anyone have any suggestion for this question ?

thanks for your attention