Pulling Data if Greater Than or Less Than

[sacajamo]

On the final part of a spreadsheet I'm working on, I want to pull in data from the win/loss column only if it meets the criteria of a Tier 3 loss (Greater than -$3.01 but less than -$1.99). For the example below, the only one that should be pulled into a Tier 3 Loss is the -$2.64. I am trying to do an IF A7 is greater than -$3.01 but less than -$1.99, then A7 formula but can't quite nail it. Any suggestions?

Win/Loss	Tier 3 Loss
	-$2.00--$3.00
1.96
-0.87
0.80
-0.26
-2.64
2.05
0.56
0.52
2.05
3.00

 

[shift-del]

Try this.

Mappe20
	A	B	C
1			-3
2			-2
3	1,96		-2,64
4	-0,87
5	0,8
6	-2,64
7	2,05
Tabelle1

Cell Formulas
Range	Formula
C3	C3	=FILTER(A3:A7,(A3:A7>C1)*(A3:A7<C2))

 

[sacajamo]

Hmm--I actually have 6 "tiers" or categories that I wanted to pull into. See below. I wanted to set up formulas in the Tier columns to pull in from the win/loss column based on how much the win or loss was. So I wanted it to look like this below. For example, on the first row, $1.96 win, could here be a formulat that says "If the amount in A3 is greater to or equal to $1.00, and greater to or less than $1.99, populate this cell with A3". Possible?

Win/Loss	Tier 3 Loss	Tier 2 Loss	Tier 1 Loss	Tier 1 Profit	Tier 2 Profit	Tier 3 Profit
	-$2.00--$3.00	-$1.00--$1.99	$.00--$.99	$.00-$.99	$1.00-$1.99	$2.00-$3.00
$1.96					$1.96​
-$0.87			-$0.87​
$0.80				$0.80​
-$0.26			-$0.26​
-$2.64	-$2.64​
$2.05						$2.05​
$0.56				$0.56​
$0.52				$0.52​
$2.05						$2.05​
$3.00						$3.00​

 

[kevin9999]

You could actually make it a bit simpler if you restructured your table slightly, like this:

Book1
	A	B	C	D	E	F	G
1	Win/Loss	Tier 3 Loss	Tier 2 Loss	Tier 1 Loss	Tier 1 Profit	Tier 2 Profit	Tier 3 Profit
2	Upper	-$2.00	-$1.99	-$0.99	$0.99	$1.99	$3.00
3	Lower	-$3.00	-$1.00	$0.00	$0.00	$1.00	$2.00
4	$1.96					$1.96
5	-$0.87
6	$0.80				$0.80
7	-$0.26
8	-$2.64	-$2.64
9	$2.05						$2.05
10	$0.56				$0.56
11	$0.52				$0.52
12	$2.05						$2.05
13	$3.00						$3.00
Sheet1

Cell Formulas
Range	Formula
B4:G13	B4	=IF(AND($A4>=B$3,$A4<=B$2),$A4,"")

 

[Cubist]

Using the format @kevin9999 suggested, an option with 365 is

Book2
	A	B	C	D	E	F	G
1	Win/Loss	Tier 3 Loss	Tier 2 Loss	Tier 1 Loss	Tier 1 Profit	Tier 2 Profit	Tier 3 Profit
2	Upper	-2	-1.99	-0.99	0.99	1.99	3
3	Lower	-3	-1	0	0	1	2
4	1.96					1.96
5	-0.87			-0.87
6	0.8				0.8
7	-0.26			-0.26
8	-2.64	-2.64
9	2.05						2.05
10	0.56				0.56
11	0.52				0.52
12	2.05						2.05
13	3						3
Sheet7

Cell Formulas
Range	Formula
B4:G13	B4	=MAP($A$4:$A$13,LAMBDA(r,IF(MEDIAN(B2:B3,r)=r,r,"")))
Dynamic array formulas.

 

[sacajamo]

Thanks guys!