SOLVED

Extract Minimum Value excluding zero in EXCEL

%3CLINGO-SUB%20id%3D%22lingo-sub-3471683%22%20slang%3D%22en-US%22%3EExtract%20Minimum%20Value%20excluding%20zero%20in%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3471683%22%20slang%3D%22en-US%22%3E%3CTABLE%20border%3D%221%22%20width%3D%2297.74977229245157%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2233.333333333333336%25%22%20height%3D%2230px%22%3EBrand%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%20height%3D%2230px%22%3EModel%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%20height%3D%2230px%22%3EPrice%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2233.333333333333336%25%22%20height%3D%2230px%22%3EToyota%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%20height%3D%2230px%22%3ECorolla%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%20height%3D%2230px%22%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2233.333333333333336%25%22%20height%3D%2230px%22%3EBMW%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%20height%3D%2230px%22%3EE24%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%20height%3D%2230px%22%3E100%2C000%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EToyota%3C%2FTD%3E%3CTD%3ECamry%3C%2FTD%3E%3CTD%3E120%2C000%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2233.333333333333336%25%22%20height%3D%2230px%22%3EToyota%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%20height%3D%2230px%22%3EYaris%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%20height%3D%2230px%22%3E80%2C000%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20day.%20Kindly%20assist...%3C%2FP%3E%3CP%3EI%20have%20an%20auction%20sale%20data%20set%20similar%20to%20the%20one%20above.%20I%20am%20using%20excel%202013%20and%20I%20want%20to%20extract%20the%20minimum%20price%20of%20the%20Car%20Brands%20excluding%20zero(s)-using%20DAX.%20In%20that%20way%2C%20for%20Toyota%20I%20can%20have%2080%2C000%20as%20the%20minimum%20price%20instead%20of%200.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20help%20is%20much%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3471683%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3472616%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20Minimum%20Value%20excluding%20zero%20in%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3472616%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1415070%22%20target%3D%22_blank%22%3E%40Ellisa2255%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20that's%20data%20model%20table%20the%20measure%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3Emin%20Price%3A%3DCALCULATE(MIN(Table1%5BPrice%5D%20)%2C%20Table1%5BPrice%5D%20%26gt%3B%200%20)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3472775%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20Minimum%20Value%20excluding%20zero%20in%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3472775%22%20slang%3D%22en-US%22%3EThank%20you%20very%20much.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3473571%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20Minimum%20Value%20excluding%20zero%20in%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3473571%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1415070%22%20target%3D%22_blank%22%3E%40Ellisa2255%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3524326%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20Minimum%20Value%20excluding%20zero%20in%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3524326%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Afternoon%3CBR%20%2F%3EHow%20would%20I%20go%20about%20extracting%20data%20from%20sheet%201%20to%20sheet%202%20if%20cell%20value%20greater%20than%200%3CBR%20%2F%3EI'm%20trying%20to%20create%20a%20weekly%20price%20list%20(Sheet%202)%20of%20available%20(%26gt%3B0)%20items%20from%20a%20master%20list%20(Sheet%201).%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CP%3E%3CSTRONG%3E%3CSPAN%3EID%20%23%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSTRONG%3E%3CSPAN%3EName%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSTRONG%3E%3CSPAN%3EGrade%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSTRONG%3E%3CSPAN%3EDescription%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSTRONG%3E%3CSPAN%3ESize%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSTRONG%3E%3CSPAN%3ECost%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSTRONG%3E%3CSPAN%3EPrice%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSTRONG%3E%3CSPAN%3EAvailable%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3EOG%20Bounce%20Mushroom%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3EULT%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3EOriginal%20bounce%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E2%E2%80%9D%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E%2425.00%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E%2432.50%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E1%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3EOG%20Bounce%20Mushroom%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3EULT%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3EOriginal%20bounce%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E1%E2%80%9D%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E%2416.00%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E%2420.80%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E0%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3EOG%20Bounce%20Mushroom%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3EULT%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3EOriginal%20bounce%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E%C2%BD%22%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E%2412.00%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E%2415.60%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E4%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3ESpiderman%20Bounce%20Mushroom%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3EULT%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3EBlue%20mushroom%20w%2F%20bright%20red%2F%20orange%20bubbles%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E2%E2%80%9D%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E%2435%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E%2445.50%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E0%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3ESpiderman%20Bounce%20Mushroom%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3EULT%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3EBlue%20mushroom%20w%2F%20bright%20red%2F%20orange%20bubbles%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E1%E2%80%9D%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E%2426%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E%2433.80%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%3CSPAN%3E0%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3525379%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20Minimum%20Value%20excluding%20zero%20in%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3525379%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1428818%22%20target%3D%22_blank%22%3E%40Pat_Davies%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDepends%20on%20your%20Excel%20platform%20%2F%20version%20and%20what%20are%20you%20going%20to%20do%20with%20extracted%20data.%20As%20variant%20that%20could%20be%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffilter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EFILTER%20function%20(microsoft.com)%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
BrandModelPrice
ToyotaCorolla0
BMWE24100,000
ToyotaCamry120,000
ToyotaYaris80,000

 

Good day. Kindly assist...

I have an auction sale data set similar to the one above. I am using excel 2013 and I want to extract the minimum price of the Car Brands excluding zero(s)-using DAX. In that way, for Toyota I can have 80,000 as the minimum price instead of 0. 

 

Your help is much appreciated.

 

Thank you.

5 Replies
best response confirmed by Ellisa2255 (New Contributor)
Solution

@Ellisa2255 

If that's data model table the measure could be

min Price:=CALCULATE(MIN(Table1[Price] ), Table1[Price] > 0 )
Thank you very much.

@Ellisa2255 

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 

@Pat_Davies 

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)