Forum Discussion
Extract Minimum Value excluding zero in EXCEL
If that's data model table the measure could be
min Price:=CALCULATE(MIN(Table1[Price] ), Table1[Price] > 0 )
You are welcome
Good Afternoon
How would I go about extracting data from sheet 1 to sheet 2 if cell value greater than 0
I'm trying to create a weekly price list (Sheet 2) of available (>0) items from a master list (Sheet 1).ID #
Name
Grade
Description
Size
Cost
Price
Available
OG Bounce Mushroom
ULT
Original bounce
2”
$25.00
$32.50
1
OG Bounce Mushroom
ULT
Original bounce
1”
$16.00
$20.80
0
OG Bounce Mushroom
ULT
Original bounce
½"
$12.00
$15.60
4
Spiderman Bounce Mushroom
ULT
Blue mushroom w/ bright red/ orange bubbles
2”
$35
$45.50
0
Spiderman Bounce Mushroom
ULT
Blue mushroom w/ bright red/ orange bubbles
1”
$26
$33.80
0
Depends on your Excel platform / version and what are you going to do with extracted data. As variant that could be FILTER function (microsoft.com)
