Hey all, trying to display a range of ounces for various laundry detergent but my formula has broke. Anyone see where im going wrong here? I'd like to have it display like this: 45 - 50 oz in cell F21.Thanks in advance...
=IFERROR(IF(MIN(IF(B:B=B17,IF(A:A=" ",G:G)))=MAX(IF(B:B=B17,IF(A:A=" ",G:G))),MIN(IF(B:B=B17,IF(A:A="",G:G)))&" "&H18,MIN(IF(B:B=B17,IF(A:A=" ",G:G)))&" - "&MAX(IF(B:B=B17,IF(A:A=" ",G:G)))&" "&H18),"")
[B]Excel 2010[/B][TABLE]
<tbody>[TR]
[TH][/TH]
[TH]E[/TH]
[TH]F[/TH]
[TH]G[/TH]
[TH]H[/TH]
[TH]I[/TH]
[/TR]
[TR]
[TD="align: center"]19[/TD]
[TD]ARM & HAMMER BAKING SODA 16 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]16[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]16 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD]ARM & HAMMER BAKING SODA FRIDGE-N-FREEZER 16 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]16[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]16 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]21[/TD]
[TD="align: right"][/TD]
[TD="align: center"]0 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]22[/TD]
[TD]ARM & HAMMER DTRNGT LNDRY LIQ OXICLN FRSH 45 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]45[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]45 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]23[/TD]
[TD]ARM & HAMMER LIQ LAUNDRY 2X CONC SENS SKIN 50 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]50 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]24[/TD]
[TD]ARM & HAMMER DTRNGT LNDRY LIQ LVNDR/LN CNCT 50 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]50 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]25[/TD]
[TD]ARM & HAMMER LQ DET 2X CN CLEAN BURST 32LD 50 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]50 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]26[/TD]
[TD]ARM & HAMMER LQ DT 2X PURFUME/DYE FREE 32LD 50 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]50 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]27[/TD]
[TD]ARM & HAMMER DTRNGT LNDRY LIQ ORCH BLM 50 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]50 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]28[/TD]
[TD]ARM & HAMMER LQ DT 2X CLN BRST W/BLCH 26LD 50 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]50 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]29[/TD]
[TD]ARM & HAMMER DETERGENT LIQ BIOENZYM BOT SPR 43.75 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]43.75[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]43.75 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]30[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]
[CENTER][COLOR=#161120][B]Ad Analysis- Core Mailer UP[/B][/COLOR][/CENTER]
=IFERROR(IF(MIN(IF(B:B=B17,IF(A:A=" ",G:G)))=MAX(IF(B:B=B17,IF(A:A=" ",G:G))),MIN(IF(B:B=B17,IF(A:A="",G:G)))&" "&H18,MIN(IF(B:B=B17,IF(A:A=" ",G:G)))&" - "&MAX(IF(B:B=B17,IF(A:A=" ",G:G)))&" "&H18),"")
<tbody>[TR]
[TH][/TH]
[TH]E[/TH]
[TH]F[/TH]
[TH]G[/TH]
[TH]H[/TH]
[TH]I[/TH]
[/TR]
[TR]
[TD="align: center"]19[/TD]
[TD]ARM & HAMMER BAKING SODA 16 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]16[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]16 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD]ARM & HAMMER BAKING SODA FRIDGE-N-FREEZER 16 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]16[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]16 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]21[/TD]
[TD="align: right"][/TD]
[TD="align: center"]0 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]22[/TD]
[TD]ARM & HAMMER DTRNGT LNDRY LIQ OXICLN FRSH 45 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]45[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]45 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]23[/TD]
[TD]ARM & HAMMER LIQ LAUNDRY 2X CONC SENS SKIN 50 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]50 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]24[/TD]
[TD]ARM & HAMMER DTRNGT LNDRY LIQ LVNDR/LN CNCT 50 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]50 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]25[/TD]
[TD]ARM & HAMMER LQ DET 2X CN CLEAN BURST 32LD 50 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]50 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]26[/TD]
[TD]ARM & HAMMER LQ DT 2X PURFUME/DYE FREE 32LD 50 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]50 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]27[/TD]
[TD]ARM & HAMMER DTRNGT LNDRY LIQ ORCH BLM 50 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]50 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]28[/TD]
[TD]ARM & HAMMER LQ DT 2X CLN BRST W/BLCH 26LD 50 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]50 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]29[/TD]
[TD]ARM & HAMMER DETERGENT LIQ BIOENZYM BOT SPR 43.75 OZ[/TD]
[TD="align: center"][/TD]
[TD="align: center"]43.75[/TD]
[TD="align: center"]OZ[/TD]
[TD="align: center"]43.75 OZ[/TD]
[/TR]
[TR]
[TD="align: center"]30[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]
[CENTER][COLOR=#161120][B]Ad Analysis- Core Mailer UP[/B][/COLOR][/CENTER]
Last edited: