Forum Discussion
Solved
Extract Minimum Value excluding zero in EXCEL
Brand Model Price Toyota Corolla 0 BMW E24 100,000 Toyota Camry 120,000 Toyota Yaris 80,000 Good day. Kindly assist... I have an auction sale data set similar to the ...
If that's data model table the measure could be
min Price:=CALCULATE(MIN(Table1[Price] ), Table1[Price] > 0 )
If that's data model table the measure could be
min Price:=CALCULATE(MIN(Table1[Price] ), Table1[Price] > 0 )- Thank you very much.
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
