-
small with condition
|
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
-
Please, would anyone have any suggestion for this question ?
thanks for your attention
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules