Arul.rajesh
Active Member
- Joined
- Sep 20, 2011
- Messages
- 285
Data is organised like this:
__A__B
1 15 inc
2 23 inc
3 53 inc
4 34 inc
5 67 exc
6 27 inc
7 26 inc
8 22 exc
9 93 inc
Is there a possibility to write an array formula, which would return the array {15,23,53,34,27,26,93}, Basically wherever column "B" contains "inc"?
I can do this in VBA by looping through all the rows, but I was looking for a more elegant solution.
__A__B
1 15 inc
2 23 inc
3 53 inc
4 34 inc
5 67 exc
6 27 inc
7 26 inc
8 22 exc
9 93 inc
Is there a possibility to write an array formula, which would return the array {15,23,53,34,27,26,93}, Basically wherever column "B" contains "inc"?
I can do this in VBA by looping through all the rows, but I was looking for a more elegant solution.