Notifications
Clear all
Topic starter
I have a table where I'm trying to get a formula to return the segment qty based on the 'developed lg' and the minimum 'loss'
The result should be 4.
If anyone has any suggestions it would be greatly appreciated.
Posted : 22/02/2024 6:57 am
I reconstructed your table came up with the following formula to return the desired answer:
=INDEX(SORT(FILTER(Table10,(Table10[DEVELOPED LG]>I21)*(Table10[DEVELOPED LG]<I22)),3,1),1,1)
It will work in this simple example but perhaps not if your data set gets bigger or has duplicate loss values.
Posted : 22/02/2024 9:26 am
Topic starter
Thank you, that works a treat.
Posted : 22/02/2024 10:14 am
