Hi all, I have some data of the following format (this is a dummy version):

ID type score
id1 A -195
id2 A 387
id3 A -59
id4 B 219
id5 A 481
id6 A 44
id7 A 147
id8 A 346
id9 B -27
id10 A 184
id11 A 258
id12 A 130
id13 A 73
id14 A 436
id15 A -111
id16 B 152
id17 A 398
id18 A 262
id19 A 196
id20 B 263
id21 B -84
id22 B 212
id23 A -227
id24 A 180
id25 A 453
id26 A 6
id27 A 214
id28 B -60
id29 A 90
id30 B -187
id31 A -178
id32 A 190
id33 A 457
id34 A -207
id35 B 475


I'd like to be able to set a threshold filter for the score, that maximises the number of 'B' ids removed and minimises the number of 'A' ids removed. Is this a possibility within Excel?