MartyCollins
New Member
- Joined
- Jan 21, 2022
- Messages
- 38
- Office Version
- 365
- Platform
- Windows
Hi all,
So i have a table that I want to filter, thats fine.(formula in H9)
But i want the filtered results to feed into an adjacent formula spilling to the right (I9) which i also want to be dynamic but running into difficulty.
I can get it to work easily as per below non dynamic,but getting it dynamic has me in a spin - ive tried ByRow to feed it into filter, ive obviously tried simply replacing the =H9 with = H9# but getting nowhere there either..
Below is a basic idea of what im trying to achieve.
User selects a car... Optional extras are listed... and then the adjacent formula spills to the right listing all cars with same optional Extras eg Alloys;Aircon etc etc.
Formula I want to be dynamic...
=TRANSPOSE(
FILTER(TblData[Model],
TblData[Optional Extras]=H9))
Thanks,
Martin.
So i have a table that I want to filter, thats fine.(formula in H9)
But i want the filtered results to feed into an adjacent formula spilling to the right (I9) which i also want to be dynamic but running into difficulty.
I can get it to work easily as per below non dynamic,but getting it dynamic has me in a spin - ive tried ByRow to feed it into filter, ive obviously tried simply replacing the =H9 with = H9# but getting nowhere there either..
Below is a basic idea of what im trying to achieve.
User selects a car... Optional extras are listed... and then the adjacent formula spills to the right listing all cars with same optional Extras eg Alloys;Aircon etc etc.
Formula I want to be dynamic...
=TRANSPOSE(
FILTER(TblData[Model],
TblData[Optional Extras]=H9))
Thanks,
Martin.