Hello,
I have a filter function in D1 that spills the contents of column A that match the filter criteria. I was wondering if it is possible to have the formula in the same cell spill the content of the adjacent column (B) in column E? In the attached example, I have manually filled in the contents of column B in E right next to each cell of the spill, but I was hoping that can be done in one step automatically
(I was thinking to use INDEX/MATCH to grab the column B content separately, but it won't work where there are multiple numbers in column A that are the same.)
Thanks for any input!
I have a filter function in D1 that spills the contents of column A that match the filter criteria. I was wondering if it is possible to have the formula in the same cell spill the content of the adjacent column (B) in column E? In the attached example, I have manually filled in the contents of column B in E right next to each cell of the spill, but I was hoping that can be done in one step automatically
(I was thinking to use INDEX/MATCH to grab the column B content separately, but it won't work where there are multiple numbers in column A that are the same.)
Thanks for any input!
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | 12 | u | 37 | f | ||||
2 | 37 | f | 32 | h | ||||
3 | 32 | h | 49 | z | ||||
4 | 16 | o | 43 | g | ||||
5 | 49 | z | 48 | h | ||||
6 | 8 | f | 24 | r | ||||
7 | 43 | g | 23 | t | ||||
8 | 48 | h | 46 | j | ||||
9 | 18 | f | 50 | l | ||||
10 | 24 | r | ||||||
11 | 23 | t | ||||||
12 | 17 | y | ||||||
13 | 46 | j | ||||||
14 | 19 | k | ||||||
15 | 50 | l | ||||||
16 | ||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D1:D9 | D1 | =LET(x,A1:A15,FILTER(x,x>20)) |
Dynamic array formulas. |