Peter Davison
Active Member
- Joined
- Jun 4, 2020
- Messages
- 444
- Office Version
- 365
- Platform
- Windows
I have this formula currently
=LET(a,$DW$13:$DW$1000,b,$EI$13:$EI$1000,ra,ROWS(a),s,SEQUENCE(ra+ROWS(b)),I,IF(s<=ra,INDEX(a,s),INDEX(b,s-ra)),UNIQUE(FILTER(I,I<>0)))
I want to add a third range so I can filter on the range
My third range is - $EH$13:$EH$1000 which I can call c
and I want to filter this range on
c="Ambient"
I tried the following but get an error and I believe I don't have the syntax right in the middle somewhere (I think I need to do something on Rows and Sequence but not sure)
=LET(a,$DW$13:$DW$1000,b,$EI$13:$EI$1000,c,$EH$13:$EH$1000,ra,ROWS(a),s,SEQUENCE(ra+ROWS(b)),I,IF(s<=ra,INDEX(a,s),INDEX(b,s-ra)),UNIQUE(FILTER(I,(I<>0)*(c="Ambient"))))
It you are able to help that would be great
=LET(a,$DW$13:$DW$1000,b,$EI$13:$EI$1000,ra,ROWS(a),s,SEQUENCE(ra+ROWS(b)),I,IF(s<=ra,INDEX(a,s),INDEX(b,s-ra)),UNIQUE(FILTER(I,I<>0)))
I want to add a third range so I can filter on the range
My third range is - $EH$13:$EH$1000 which I can call c
and I want to filter this range on
c="Ambient"
I tried the following but get an error and I believe I don't have the syntax right in the middle somewhere (I think I need to do something on Rows and Sequence but not sure)
=LET(a,$DW$13:$DW$1000,b,$EI$13:$EI$1000,c,$EH$13:$EH$1000,ra,ROWS(a),s,SEQUENCE(ra+ROWS(b)),I,IF(s<=ra,INDEX(a,s),INDEX(b,s-ra)),UNIQUE(FILTER(I,(I<>0)*(c="Ambient"))))
It you are able to help that would be great