Hi,
I am trying to write an array formula which will skip cells if they have a particular value and return the corresponding cells of the others e.g.
I have these lists
A B
1 Number Description
2 1000 apple
3 2105 ball
4 2105 cat
5 2105 dog
6 2108 egg
7 3302 fish
8 4001 grape
9 4001 house
I need an array that will look at column A and list items in column B if A > 2105, so result should be:
D
1 Result
2 egg
3 fish
4 grape
5 house
I want it so that it doesnt result in blank cells but skips any that have a number of <=2105.
Thanks
Bookmarks