Log In
Register
Home
Trouble filtering range by multiple criteria and minimum value
Richard K
Member
Members
Forum Posts: 17
Member Since:
August 4, 2020
August 4, 2020
Offline1
February 21, 2024 - 8:57 pm
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.
See Answer
Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members
Moderators
Moderators
Forum Posts: 1030
Member Since:
January 31, 2022
January 31, 2022
Offline2
February 21, 2024 - 11:26 pm
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.
Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: G Thomas
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 919
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 339
David_Ng: 306
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
santhosh kumar R
Lennard Wood
Miguel Costa
Nick Dowling
Silvia Ramos
Muhammad Abdullah Asad
Ifeanyi Aghanama
Ann Crossman
Kate Manders
James Carabott
Forum Stats:
Groups: 3
Forums: 25
Topics: 7069
Posts: 30981
Member Stats:
Guest Posters: 49
Members: 34461
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —