diversification
New Member
- Joined
- Jun 24, 2020
- Messages
- 37
- Office Version
- 365
- Platform
- Windows
Hi there, is there a way to have the FILTER function only spit out one value? I was thinking maybe if INDEXed the FILTER function, and then MATCHed with (1,1,0) that would work, but it isn't. The filter function is returning the right values, I just want the first one it returns though, so I can fill it down a column in a table.