How to Find MIN IF or MAX IF in Excel - Contextures Blog

Press Ctrl + Shift + Enter. MinIfMaxIf07. Create a MAXIF Formula. To find the maximum quantity for a specific product, use MAX instead of MIN. Skiptocontent WhenyouwerefirstlearninghowtouseExcel,youquicklydiscoveredthebasicExcelfunctions,likeSUM,COUNT,MIN,MAX,andAVERAGE.Nowyou’rereadyforadvancedcalculations,likehowtofindMINIForMAXIFinExcel. BeyondtheBasicswithMINIF Inthisexample,wewanttoseetheMINandMAXforaspecificproduct.ThereisaSUMIFfunctionandaCOUNTIFfunction,butnoMINIForMAXIF. [Update]:InExcel2019,andExcelforOffice365,youcanusethenewMINIFSandMAXIFSfunctions.ThereismoreinformationontheMINandMAXpageonmyContexturessite. So,we’llhavetocreateourownMINIFformula,usingMINandIF.I’veselectedaproductincellC11,andtheformulawillbebuiltincellD11. Tomakeiteasytoselectaproduct,Icreatedadropdownlistofproductnames,byusingdatavalidation. NOTE:YoucanalsocalculateMINIFandMAXIFwithMultipleCriteria MINIFFormula TheformulastartswiththeMINandIFfunctions,andtheiropeningbrackets: =MIN(IF( Next,wewanttofindtherowswheretheproductnamematchestheproductinC11: SelectC2:C8,wheretheproductnamesarelisted Typean=sign ClickoncellC11 =MIN(IF(C2:C8=C11 Next,selectD2:D8,wherethequantitiesarelisted.Iftheproductnamematches,wewanttochecktheproductquantity =MIN(IF(C2:C8=C11,D2:D8 Tofinishtheformula: Typetwoclosingbrackets ThenpressCtrl+Shift+Entertoarray-entertheformula. =MIN(IF(C2:C8=C11,D2:D8)) NOTE:Ifyouplantocopythisformuladownacolumn,useabsolutereferencestotheproductandquantityranges: =MIN(IF($C$2:$C$8=C11,$D$2:$D$8)) ArrayEnteredFormula IfyouselectcellD11,andlookattheformulaintheFormulaBar,therearecurlybracketsatthestartandendoftheformula.Thosewereautomaticallyadded,becausetheformulawasarray-entered(Ctrl+Shift+Enter). Ifyoudon’tseethosecurlybrackets,youpressedEnter,insteadofCtrl+Shift+Enter. Tofixtheformula: Clickintheformulabar(itdoesn’tmatterwhereyouclickwithintheformula) PressCtrl+Shift+Enter. CreateaMAXIFFormula Tofindthemaximumquantityforaspecificproduct,useMAXinsteadofMIN. =MAX(IF(C2:C8=C11,D2:D8)) oruseabsolutereferencesfortheproductandquantityranges: =MAX(IF($C$2:$C$8=C11,$D$2:$D$8)) AndremembertopressCtrl+Shift+Enter MultipleCriteriaforMINIForMAXIF Theseformulashaveonlyonecriterion—theproductname.Ifyou’rereadyforthenextchallenge,youcanalsocalculateMINIFandMAXIFwithMultipleCriteria [Update]:InExcel2019,andExcel365,youcanusethenewMINIFSandMAXIFSfunctions.Formoreinformation,gototheMINandMAXpageonmyContexturessite. WatchtheMINIForMAXIFVideo ToseethestepsforcreatingMINIFandMAXIFformulas,watchthisshortExcelvideotutorial.ThesamplefileforthisvideocanbedownloadedfrommyContextureswebsite,ontheMINandMAXpage. Yourbrowsercan’tshowthisframe.Hereisalinktothepage ________________________ ________________ 128thoughtson“HowtoFindMINIForMAXIFinExcel” MinIForMaxIFisgoingtobeveryusefultomeinthenearfuture. Wow,that’sverycool,Debra.Thankyou! Ilikeit!canuseinVBA:Range(“D11?).FormulaArray=“=MIN(IF(C2:C8=C11,D2:D8))” ThanksVERYmuch!!!Ispentabout4hourstryingtoworkouthowtotakethehighestnumberfromalargelistofnumbersifthefirstthreenumberswere“x”andwiththehelpofyourwebpage,Igotitsorted.Thanksagain!!!! You’rewelcome!Thanksforlettingmeknowthattheinstructionshelpedyou. Greatarticle,manythanks! Hithankyouforgreatarticle.Isitpossibletocombinemoreconditions?Itriedtoputandfunctioninsideifbutitdidntwork.Canyoupleasehelpme? seemsthatitcannotrunin2003 Iagree,isthereawaytomakeitworkinExcel2003? CTRL+SHIFTENTER Thatformulaisnotworking.Ieventriedtheexactsameinformation.Iamusingexcel2010.Itgivesmeerror:#value! @Dora,remembertopressCtrl+Shift+Entertoarray-entertheformula. Itwon’tworkcorrectlyifyoujustpressEnter ThanksDebra!!Iforgotthat. Hi.Ikeepgettingthe#Numerrorwhenusingthis.Doyouknowwhy? Brilliant!Amatacoalmineinthemiddleofnowheregoingthroughsomedata,andfoundyourwebsiteinafranticgooglesearchwhilesittingoutsideinthecarparkwith1barofsignal.Lifesaver.Cheersforthehumourousinstructions. @George,thanks,andI’mgladyoufoundthesolutionwhenyouneededit. Thankyouverymuch,certainlyusefulandmuchsimplerthanIexpected! PRODUCTREDGREENBLUEMAXIMUM A0100 B1200 C009 HowIwillgetthemaximumnosbyusingifformula. THANKYOUSOOOOOOOMUCH!!!!IspenthourstrollingaroundtheinternettryingtofindaMAXIF-likeformula.ThiswebsitesavedmyPowerPointdeck(andmytail)….lol EXCELente!!!muchasgracias It’sashamesuchanormal(anduseful)functionasthisstillhastobedonewiththememory-hoggingArrayformula.IguessMicrosoftwon’tgetaroundtoaddingitasanormalfunctionuntilOffice2025? Thisexplanationwasamajorboontomyworksheetdevelopment.Thankssomuch! Thanksforthis;isthereanywaytoknowinadvancewhetherIwillneedtoconvertformulasinexcelintoarrayformulas.Not100%sureofwhenaformulashouldbeanarrayvsastandardformula. tyinadvance That’sgreat,butI’dliketotakeitabitfurther.I’dliketocombinethesmall/largefunctionswithanifcondition.Basically,Iwanttofindthetop/bottom20valuesinacolumn,giventhat2otherconditionsholdtrue.Doesthatmakesense? Icanobviouslydothiswithapivottableusingfilters,butprefertoavoidhavingtoupdatethemeachtime.Thanks. THANKYOUSOMUCH…………!!! Ihaverunintotwoissues…maybesomeonecanhelp. 1)Thecalculationstakealongtimewhenaddingthisformula. 2)ifthereisa#N/Ainthedata,itcomesupwith#N/Ainsteadofignoringit Thanks! Hi, Youprobablyfoundananswertothisasitwasafewmonthsago,butifnot,use: =IF(ISERROR(insertdebra’sfantasticformulahere),””,insertdebra’sfantasticformulaagain) Whynotjustuse: =IFERROR(insertDebra’sfantasticformulahere),””) Thiswayyoudon’thavetorepeattheresourceconsumingDebra’sfantasticformula… Veryvalidissuewherethisformulastumblesisthatifthecellsareblankornull,thenitreturnstheminvalueaszero,andIsolveditlikethis.ItignoresallZEROblankNAvaluesandcalculatesperfectly: =MIN(IF($U$2:$U$927>0,IF($B$2:$B$927=B157,$U$2:$U$927))) Thisisagreatmethodanditseemstoworkverywell.Ihaveasituationwherethedataisnotarrangedina“vertical”array.BythisImeantherecordsarelistedcolumn-wise,notrow-wise.Unlikethecapabilityofthebuilt-infunction=averageif()whichworksbothways,Ican’tseemtogetthismethodtoworkinanarraywherenewrecordsareaddedhorizontallyincolumns. Canyouverifyifthisistrue? thanks,-doug Thnkyouevrymuch.I’vebeenworkingonthisforquiteawhile,butthisisaneasysolution.Thanksforputtingitonlineforeveryone!I’msureyou’vehelpedalotofpeople,mostpeopledontpostathankyou… Ilovethinkingoutofthebox!Greatexplinationandveryveryuseful!! Thanksforwonderfulexplanation,,,itsreallyinformative!!!! Thanks–thisarrayfunctionisworkingwellformeasasubstituteforMAXIFSinmylocalfile.However,afterIgotisalltestedandworking,IpostedthesechangesintothelivefilewhichisasharedExcelfileonmycompany’sinternalnetworkserver.Turnsout,itdoesnotworkwellinasharedfile.Whenonetriestocopy,orinsertrows,Excel2007returnsthiserror: Error1004: Cannotcopyormovearrayenteredformulasordatatablesinasharedworkbook. DoesanyoneknowofanywaytodoMAXIFSwithoutusingarrayformulas?e.g.withoutusingCtrl+Shift+Enter? Thanks, Jeff Greatarticle,thankssomuch,savedmealotoftime. SoIhaveusedtheMINIFmanytimesnow,butforthefirsttimeIhavegapsinthedata,whiletheminfunctionwouldtraditionalignoreblanks,theMINIFinsertsa0.Certainlysomethingtomindfulofbutdoesanyoneknowaworkaround? Debra: Thisexplanationisexcellentandeasilyunderstood.Moreimportantly,ithashelpedmeimmenselywithseveralprojectswhichwouldhavebeenquitecomplicatedwithoutyourgreathelp. Thisisgreatandworkswell.HowcanyouchangetheformulatolookuptheProductcolumnandthenlisteachproductanditscorrespondinghighestorlowestvalue? Thusyoudon’thavetoreferenccellC11i.e.hereisalistofallmyproductsshowmethemax/minmumforeach. Thankyou! Pingback:Acoupleofquestionsforanewproject. Perfect!JustwhatIwaslookingfor. Cheers IHAVEINA1MONTHLIST,B1AMOUNT,C1AMOUNTINEEDTOMAKED1=IFA1=1JANTO30MARCHAMOUNTINB1IFA1=1APRILTO31DEC=C1 Hi, IfIenter“paper”inC12and“pens”inC13,canIcopythearrayformuladown?Don’tseemtobeabletodothat–itstillseemstolinkonlytoC11(evenifIremovetheabsolutereference)?Anyhelp? Iamhavingthissameissue.Thecellreferencecopiesdowntoallotherrowsasifitwasanabsolutereference.Ihaven’tfoundasolutiontothisyet. Thankyouforthispost.ThatwasexactlywhatIneeded. Thksagainforsharing. CanIusethisformulawith2conditions? Itry=MIN(IF(AND(…,…),…))–>Ctrl+Shift+ENterbutitdoesn’twork🙁 Pleaseadvise. Thanks, Use=MIN(IF((..=..)*(..=..),..))–>Ctrl+Shift+Enter Thanks!!Thissolvedmyproblemperfectly🙂 thankyouthatwaseasyandveryhelpful🙂 Thanks,worksgreat.Ilearntsomethingnewtoday.Theonlyissueisit’sabitprocessorheavywhendealingwithlargespreadsheets.StillIsupposethereisnowayroundthat.Thanksagain. Aneasier-to-rememberwaytoachievethisisusingtheSUBTOTALformula.E.g.SUBTOTAL(5,filteredRange)willgivetheMINvalue,andSUBTOTAL(4,filterRange)willgivetheMAXvalue. I’vespentyearsdealingwithdonoridsandgivinghistoriesbygiftandhavingtosorttoonlyshowthelastgift.MAXIFwouldhavesavedmecountlesshoursandheadaches.Thankssomuch! Thanksomuch Pingback:GetLatestPriceforSpecificProduct|ContexturesBlog Itfailsifyouareusingtablesin2013,eg:=MAX(IF(A2=Tx_Hist[@Description],Tx_Hist[@[Prd_date]])).ItworksOKforthefirst2rows,thenreturnszerofortherestofthetable. wowthatsamillionthissavedmytimeahelllot!!! ThanksforhavingsuchanawesometutorialonMINIFandMAXIF!Itworksperfectlyin2010! Iwanttoextendthisformula“onestep”further.ThatisincolumnElet’ssayIhavefirstnameslisted.Soinsteadoffindingthemaximumvalue20for“paper”,IwanttheformulatoreturnthenameincolumnE.SpecificallycellE4intheaboveexample. IhavefoundformulasthatwillreturnE4ifitisanumber,butIgetanerrorifthecellinnon-numeric. Thiswasveryhelpful,workedlikeacharm!savedmesomuchtime,thanksyousomuch,GodBlessyou! Veryhelpful.Thisformulaisthebest.Thankyousomuch🙂 ThankyousomuchfortheMax(If)formula.Itworksperfectlywhenthedataisinthesamesheet.However,Ihavedataindifferentsheets,andgotbackanerror#REF! ForexampleIhaveasheetwith50stateslisteddownthepageincolumnA,numberofemployeeincolumnBand$AmountincolumnC.Thereare25sheetsfordifferentcompanies.IwanttofindtheMax$Amountforeachstateamongthe25companiesifnumberofemployeeis>1000. DoestheMax(If)workswhenyourdataisindifferentsheets?Thankyousomuchforyourhelponthis. fromthesheetwhereyougetyourdata,thereisa#REF!asyourdata. Simplyusesortandcheckifthereisa#REF!fromyourlist. checkifthereisa#REF!fromyourdata.Itispossibletouseevenifthedataisfromadifferentfile. Veryhelpful.Thankyousomuch! ThanksfortheMaxIFsuggestion.Ineededtofindathemaximumvaluelessthan0inanarraywith2000+entries.Iwasn’tlookingforwardto2000+IFstatementsthenusingMAXonthesetofindtheanswer.Severalofthelookuptypefunctionswerecheckedanddidn’tworkout. Thekeyinsightwastoviewthisasarrayenteredandeitheraddthe{}oruseCtrl+Shift+Enter. Yourapproachtook1simplestatement. Thanks, MarkinID DebraDalgleishyourockthankyou.Youinstructionswereclearandprecise.Iwasabletoduplicatethisthefirsttime. Thanks,Jeanie!Gladithelpedyou,andthanksforlettingmeknow. Worksadream–manyhourssaved. Hi, Canweapplyaformattingconditioninthisformulasomehow? IfIhavearowofdatesandthefirstfourdatesahighlightedgreen.HowcanIidentifythatlastgreendate/cell? Thankyou! Thanksalot,informationwasreallyuseful&Icouldabletouseitformywork.Icouldabletowriteformulabutmissing{}brackets,butkeytrickmentionedwasmagicforme. BestRegards, Sandeep Manythanks,yourarticleisstillhelpingpeopleaftermorethan3years!😉 Pingback:AllofthoseniftyExceltricks|MGT-432aCorporateValuation|VanderbiltUniversity Thankyouforthepost!IappliedtheMinIFfunctiononalargedatasetitreturnsvaluesforabout35000rowsbutfailsbeyondthat.Doesanyonehaveanygoodsuggestionhowtoextendtherageofthefunction? Thankyouverymuchfortheguidance Itreallyhelps! Thankyouverymuchforthisexplanation.Itworkedperfectly.CanIaskaquestionjustforlerningpurposes:whydoesntitworkwithoutpresingctrlshiftenter? ExceltreatsformulasasarrayformulasonlywhenCtl+Shift+Enterispressed.Inordertodoaminofanarray,weneedtousearrayformulas.Iwaslookingforawaytoavoidarrayformulas,astheysometimesslowExceldown(ifusedinthousandsofcells).Sofar,itlookslikearrayformulaisunavoidable.ThismethodshownhereistheonlymethodIhavebeenusing.Thanks. Idon’tlikearrayformulas,becauseIdesignspreadsheetsforotherpeopletobrowseandlookatdatasetsfromdifferentperspectives.Thedangerwitharrayformulasissomeonecanclickonyourcellandthearraydesignationwilldisappear.Justsomethingtobeawareofiftryingtomakeafool-proofspreadsheet. “Ifyoumakesomethingfool-proof,theworldwillcreateabetterfool” Thankyouverymuch. Itwasveryhelpful. Thisisuseful!Thankyou! IhaveaproblemwithExcel2007whilsttryingtototalmaxandmininarowforweatherrecording.TheconditionalformatworksonMAXontherowbetweenB34:Y34buttheMINfunctiondoesnot.IhavetriedeverythingIcanthinkof,butnothingworks.Theconditionalformatworksoncolumnsbutnotacrossrows!Doyouknowwhy?Wouldwelcomeyouradvice. Thanksforthis.Workedlikeacharm.IsubscribetoPPP,soI’mnotsurprisedatallthatIfoundgreatadvicehere.PPPisagreatproduct. @TJF,thanks,andI’mgladyoulikethePivotPowerPremiumadd-intoo! ThankyouDebra!Ilikedthecommentaryperhapsevenmorethantheactualadvice(whichwasgreat).Rocksandtreestumps! @david,thanks,I’mgladyoulikedit!😉 Pingback:Excel:MatchTextinTwoColumnsandReturnaValueRelativetoTheirIntersection-codeengine Debra, Thanksforpostingthis!Ilearnedatonnotjustonnestingfunctionsbutaboutarraysinformula.Thisopensupawholenewworldtome! ThanksBrus! Pingback:WhywouldIneedanarrayformula?|MySpreadsheetLab Thissolvedoneofmybiggestheadaches…wherewehavecolumnsofvalues,buttheyalternate(e.g.North,East,South,West),groupedfordifferentyearsandIwanttodisplay,onthesamerow(e.g.“sales”).BeforeIhadtriedtodothiswithnamedareas,butthatwastediousaseachrowhadtohaveitsownnamedareas,andformulascouldn’tbecopied. It’ssurprisingMShasn’tincorporatedthisasastandardfunctionalready! Thanks;) Awesome;) EmpID EmpName PRJ-1 StartDate EndDate 12345 Everest A 12-Aug-15 28-Aug-15 12345 Everest B 31-Aug-15 16-Oct-15 12345 Everest C 6-Jul-15 31-Jul-15 12345 Everest d 3-Aug-15 11-Aug-15 usingaboveexamplehowtoextracttheMinandMaxfunctionbyusingVlookupforthesameEmpid itsknowledgefullthanks hi,howidominifforvalue>0? Iamabletocreateanarrayforonerecord,butneedtocopyittomanyrecords.Itriedhighlightingallcells,editingthefirstandpressingShift-Control-Enter.Thefirstrecordiscorrect,butalloftheformulasreferencethefirst.Imadesurethattheformulaonlyincludedabsolutereferencesfortheranges,nottheconditions. Helpplease! =MAX(IF(‘MeetingLog’!$B:$B=’ClientSummary’!B3,IF(‘MeetingLog’!$D:$D=”Held”,’MeetingLog’!$C:$C))) Reallyuseful,thankyou!Myselfandacolleaguewastedthebestpartofanhourtrying(andfailing)toformulatethisourselves. Workedperfectly,thanks! Hello, Ihaveaquestion.DoesthisFormulaworkiftherearereferencestoanothersheet? ThanksaLot! @Bastian,whathappenedwhenyoutriedit? ActuallyIhavetriedthesamefiguresinExcel2007,itgivesmeerroras#Value..IamnotabletomakeoutwhereIamwronghere..Iusedsamedatabaseasshownabove.Pleasehelp.. MakesuretopressCtrlShift+Enterafterenteringoreditingtheformula IfyoujustpressEnterwhenyoucompletetheformula,itwillshowanerror. Iamtryingtorepairamax(if(…formulawheresomeonesortedthefilewithouthavingabsolutereferenceswheretheybelonged.NoweverytimeItrytorepairareferencetheonlythingIgetbackisa0.Iamactuallbringingbackthemaxdateenteredintoasecondtab.thecellcomesbackas1/0/1900.Everycellcomesbackthiswaywithoutgivingmethelatestdateenteredintherange.Doesanyonehaveinsightonthis?IhavepressedCtrlShift+Enter.Ihavetriedformattingthelookupemployeenumbermakingboththereferenceandthelookuplistsbeformatedtoanumber.Idon’tunderstandwhyitisnotworking. ThatwasreallyhelpfulI’vebeensearchingforitforages:))) Wouldyoupleasedomeafavorandexplainwhyitisnotworkingwithoutarray-enteringit??what’sthelogicbehindarray-enter??? Ineedtounderstand^_^ Thanks Hey,thanks!!Helped.CanyoupleasesharethelogicofwhyCntrl+Shift+EnterandnotjustEnterworks.Itriedtypinginthe“{”signswiththekeyboardratherthan“Cntrl+Shift+Enter”…thatdidnotwork.. Brilliant!Thankyou!(Asalwayssomeonehastheanswertowhatyouneedinexcel,it’sjustaquestionoffindingit!) Greatexample!Thanksalot! Hi,thankyouverymuch.IwasabletodothesamewithLARGEfunction.ThetrickwastouseCtrl+Shift+Entertoarrayarray-entertheformulaanditworkedasexpected.Verykindofyoutosharethisknowledgewithus. I’mhavingdifficultieswiththeresultsasIhaveinmylistdatesinsteadofnumbers,asyouknowdatesarenumbersaswell.AlsoIhavemylistofvariableseaA,B,C,DetcinwhichforAIhavefroexample4differentdatesandforBcouldbe2differentdatesandCjustonedateandDcouldbe2or3dates,nowwhenapplyingtheformulaitbringsforeaccasethemaxdatefromthewholelistnotfromthespecificvariable,cananybodyhelpwiththis? HelloDebra, IamtryingtoreturnminandmaxdatesbutIkeepgetting1/0/1900asmydatewhichisnotaccurate.Doyouknowwhatmightbecausingthis? Hi, Ihaveafilewithasheet(“Donations”)containingalistofdonations.EachdonoristaggedwithanalphanumericUIDendinginletterswhichcorrespondtovariouscriteria–anAintheirUIDmeansthey’reanActiveMember,Xforex-trustees,Pforprospectdonors,Vforvolunteers;aUIDcanhavemultiplelettersiftheymeetmorethanoneofthosecriteria. ColumnBofmySheet1listseachoftheuniquecriteriacodes(P,V,X….).OntheDonationssheetcolumnAliststheUIDsandcolumnDliststhedonationgivenbyeachdonor. Icaneasilyworkoutthetotalandaveragedonationamountsforeachofthosecriteriacodes(whereI’mlookingupthecriteriacodeinrow34): =SUMIF(donations!A:A,”*”&B34&”*”,donations!D:D) and =AVERAGEIF(donations!A:A,”*”&B34&”*”,donations!D:D) ButhowdoIworkouttheminimumandmaximumamountsgivenbyeachcode?I’vetried: {=MIN(IF((donations!A:A=”*”&B34&”*”),(donations!D:D)))} butitjustgivesmeazerovalue.IuseCtrl+Shift+Entersinceit’sanarrayformula. Canyouhelp? Loveyourworkbytheway. Thanks! YoucanusetheSEARCHfunctiontocheckfortheletters,andISNUMBERtotestifanumberwasreturned. Thisisanarrayformula,sopressCtrl+Shift+Enter =MIN(IF(ISNUMBER(SEARCH($B34,Donations!$A$2:$A$6)),Donations!$D$2:$D$6)) SamethingforMAX =MAX(IF(ISNUMBER(SEARCH($B34,Donations!$A$2:$A$6)),Donations!$D$2:$D$6)) hi,idontknowwhy,butevenificopytheformulafromthispage,clickctlshiftandenteritdoestgivemevalues,excellocksmeaskingifiamnottryingtotypeformula. anditshowthepopup,justafteriput”,”after=min(if(A1:A5;A7,pleasehelp Dependingonyourregionalsettings,youmightneedtouseasemi-colonasaseparator,insteadofacomma =MIN(IF(A1:A5;A7; Howcouldweadjustthisformulatograbtheminimumvaluethatisgreaterthanzero? Hichris,usethesmallfunction:=SMALL(array,k)where=SMALL(array,1)=sameas=MIN(array)askisthek’thsmallest =SMALL(IF($C$2:$C$8=$C$11,$D$2:$D$8),2)0 Iwanttograbatextfromtheminimumvalueof3,Eg a=1 b=2 c=3 d=1 minofa,b,c&dis1soreturn“a”(ifyouhavemanyincommonofselectfromaprioritylist) Thanks! CanIuseMINandISNUMBER?iwanttosumarangeonlyifacellcontainsnumericvalue.pleaseassist ThankYouSoMuch Veryveryusefultip,savemetonsoftime!ThankyousomuchDebra!! pleasesolvebelowproblem Ifinoneexcelhave1to100codeandinanotherexcelalsohavethesamecodebutwithadifferentorder,howwecross-checkinbothexcelhavingcodes Commentsareclosed. Postnavigation PreviousPreviouspost:NoDuplicatesinMultipleSelectionExcelDropDownNextNextpost:ExcelFunctionFriday:AverageTop10Scores ©2022ContexturesInc. AboutContextures ExcelTutorials Policies Searchfor: Search ContexturesExcelTips Debra'sBlog PivotTableBlog SpreadsheetDayBlog AsanAmazonAssociateIearnfromqualifyingpurchases