excel 2003 Countifs

D

DerekWooley

New Member
Joined
May 1, 2018
Messages
34
Hello, I am trying to find a way to rank the items in the below table by quarter from earliest to latest and then by month from earliest to latest after quarter in excel 2003. When I use the below sumproduct formula, it only ranks the months for each quarter but doesn't rank the quarters themselves. What do I need to add to rank quarter first, then month? Also, I want to see if it is possible to add other criteria like item type, material type, etc as secondary criteria to group items by.



Here is the sum product formula I am using: SUMPRODUCT(--(E3=$E$3:$E$46),--(F3>$F$3:$F$46))+1
I am trying to do a rank to get around sorting by multiple fields and excel 2003 only has 3 max sort criteria.​

I also want to know if it is possible to get a smoothed ranking from 1 to the end of my data instead of starting over each time it hits a new criteria; so instead of having to sort on multiple columns, I could just sort on one column or use a pivot table with the ranking first to pull in the prioritized items.

Below is what my table looks like.​


[TABLE="width: 583"]
<colgroup style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: 400; line-height: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><col style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: 400; line-height: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><col style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: 400; line-height: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><col style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: 400; line-height: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;" span="7"></colgroup><tbody style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: 400; line-height: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;">[TR="bgcolor: transparent"]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]Item[/TD]
[TD]Actual Date[/TD]
[TD]Quarter Text[/TD]
[TD]Month Text[/TD]
[TD]Quarter Value[/TD]
[TD]Month Value[/TD]
[TD]Material[/TD]
[TD]Size[/TD]
[TD]Sum Product Ranking[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]970[/TD]
[TD]8/4/2019[/TD]
[TD]20193[/TD]
[TD]20198[/TD]
[TD]4/14/1955[/TD]
[TD]4/19/1955[/TD]
[TD]Brass[/TD]
[TD]0.21875[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]254[/TD]
[TD]12/2/2018[/TD]
[TD]20184[/TD]
[TD]201812[/TD]
[TD]4/5/1955[/TD]
[TD]7/15/2452[/TD]
[TD]Brass[/TD]
[TD]0.09375[/TD]
[TD]4[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]345[/TD]
[TD]1/24/2019[/TD]
[TD]20191[/TD]
[TD]20191[/TD]
[TD]4/12/1955[/TD]
[TD]4/12/1955[/TD]
[TD]Brass[/TD]
[TD]0.09375[/TD]
[TD]6[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]883[/TD]
[TD]5/28/2018[/TD]
[TD]20182[/TD]
[TD]20185[/TD]
[TD]4/3/1955[/TD]
[TD]4/6/1955[/TD]
[TD]Steel[/TD]
[TD]0.25[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]988[/TD]
[TD]7/20/2018[/TD]
[TD]20183[/TD]
[TD]20187[/TD]
[TD]4/4/1955[/TD]
[TD]4/8/1955[/TD]
[TD]Wood[/TD]
[TD]0.25[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]302[/TD]
[TD]8/17/2018[/TD]
[TD]20183[/TD]
[TD]20188[/TD]
[TD]4/4/1955[/TD]
[TD]4/9/1955[/TD]
[TD]Plastic[/TD]
[TD]0.25[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]94[/TD]
[TD]8/11/2018[/TD]
[TD]20183[/TD]
[TD]20188[/TD]
[TD]4/4/1955[/TD]
[TD]4/9/1955[/TD]
[TD]Brass[/TD]
[TD]0.0625[/TD]
[TD]2[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]242[/TD]
[TD]11/26/2018[/TD]
[TD]20184[/TD]
[TD]201811[/TD]
[TD]4/5/1955[/TD]
[TD]7/14/2452[/TD]
[TD]Brass[/TD]
[TD]0.0625[/TD]
[TD]2[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]280[/TD]
[TD]11/8/2018[/TD]
[TD]20184[/TD]
[TD]201811[/TD]
[TD]4/5/1955[/TD]
[TD]7/14/2452[/TD]
[TD]Brass[/TD]
[TD]0.21875[/TD]
[TD]3[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]606[/TD]
[TD]11/10/2018[/TD]
[TD]20184[/TD]
[TD]201811[/TD]
[TD]4/5/1955[/TD]
[TD]7/14/2452[/TD]
[TD]Brass[/TD]
[TD]0.21875[/TD]
[TD]3[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]347[/TD]
[TD]10/8/2018[/TD]
[TD]20184[/TD]
[TD]201810[/TD]
[TD]4/5/1955[/TD]
[TD]7/13/2452[/TD]
[TD]Plastic[/TD]
[TD]0.1875[/TD]
[TD]3[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]965[/TD]
[TD]10/18/2018[/TD]
[TD]20184[/TD]
[TD]201810[/TD]
[TD]4/5/1955[/TD]
[TD]7/13/2452[/TD]
[TD]Plastic[/TD]
[TD="bgcolor: transparent"]0.1875[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]479[/TD]
[TD="bgcolor: transparent"]4/6/2019[/TD]
[TD]20192[/TD]
[TD]20194[/TD]
[TD]4/13/1955[/TD]
[TD]4/15/1955[/TD]
[TD="bgcolor: transparent"]Poly[/TD]
[TD="bgcolor: transparent"]0.125[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]313[/TD]
[TD="bgcolor: transparent"]5/3/2019[/TD]
[TD]20192[/TD]
[TD]20195[/TD]
[TD]4/13/1955[/TD]
[TD]4/16/1955[/TD]
[TD="bgcolor: transparent"]Poly[/TD]
[TD="bgcolor: transparent"]0.125[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]354[/TD]
[TD="bgcolor: transparent"]10/20/2019[/TD]
[TD]20194[/TD]
[TD]201910[/TD]
[TD]4/15/1955[/TD]
[TD]10/21/2452[/TD]
[TD="bgcolor: transparent"]Brass[/TD]
[TD="bgcolor: transparent"]0.21875[/TD]
[TD]3[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]419[/TD]
[TD="bgcolor: transparent"]6/8/2020[/TD]
[TD]20202[/TD]
[TD]20206[/TD]
[TD]4/23/1955[/TD]
[TD]4/27/1955[/TD]
[TD="bgcolor: transparent"]Brass[/TD]
[TD="bgcolor: transparent"]0.09375[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]201[/TD]
[TD="bgcolor: transparent"]7/12/2019[/TD]
[TD]20193[/TD]
[TD]20197[/TD]
[TD]4/14/1955[/TD]
[TD]4/18/1955[/TD]
[TD="bgcolor: transparent"]Brass[/TD]
[TD="bgcolor: transparent"]0.09375[/TD]
[TD]3[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]960[/TD]
[TD="bgcolor: transparent"]1/7/2019[/TD]
[TD]20191[/TD]
[TD]20191[/TD]
[TD]4/12/1955[/TD]
[TD]4/12/1955[/TD]
[TD="bgcolor: transparent"]Wood[/TD]
[TD="bgcolor: transparent"]0.25[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]593[/TD]
[TD="bgcolor: transparent"]2/5/2019[/TD]
[TD]20191[/TD]
[TD]20192[/TD]
[TD]4/12/1955[/TD]
[TD]4/13/1955[/TD]
[TD="bgcolor: transparent"]Plastic[/TD]
[TD="bgcolor: transparent"]0.25[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]224[/TD]
[TD="bgcolor: transparent"]5/2/2020[/TD]
[TD]20202[/TD]
[TD]20205[/TD]
[TD]4/23/1955[/TD]
[TD]4/26/1955[/TD]
[TD="bgcolor: transparent"]Brass[/TD]
[TD="bgcolor: transparent"]0.21875[/TD]
[TD]3[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]114[/TD]
[TD="bgcolor: transparent"]5/10/2019[/TD]
[TD]20192[/TD]
[TD]20195[/TD]
[TD]4/13/1955[/TD]
[TD]4/16/1955[/TD]
[TD="bgcolor: transparent"]Brass[/TD]
[TD="bgcolor: transparent"]0.0625[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]235[/TD]
[TD="bgcolor: transparent"]8/14/2019[/TD]
[TD]20193[/TD]
[TD]20198[/TD]
[TD]4/14/1955[/TD]
[TD]4/19/1955[/TD]
[TD="bgcolor: transparent"]Brass[/TD]
[TD="bgcolor: transparent"]0.0625[/TD]
[TD]3[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]81[/TD]
[TD="bgcolor: transparent"]8/10/2019[/TD]
[TD]20193[/TD]
[TD]20198[/TD]
[TD]4/14/1955[/TD]
[TD]4/19/1955[/TD]
[TD="bgcolor: transparent"]Brass[/TD]
[TD="bgcolor: transparent"]0.21875[/TD]
[TD]4[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]660[/TD]
[TD="bgcolor: transparent"]7/17/2019[/TD]
[TD]20193[/TD]
[TD]20197[/TD]
[TD]4/14/1955[/TD]
[TD]4/18/1955[/TD]
[TD="bgcolor: transparent"]Brass[/TD]
[TD="bgcolor: transparent"]0.21875[/TD]
[TD]4[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]272[/TD]
[TD="bgcolor: transparent"]4/6/2019[/TD]
[TD]20192[/TD]
[TD]20194[/TD]
[TD]4/13/1955[/TD]
[TD]4/15/1955[/TD]
[TD="bgcolor: transparent"]Brass[/TD]
[TD="bgcolor: transparent"]0.21875[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]819[/TD]
[TD="bgcolor: transparent"]2/14/2022[/TD]
[TD]20221[/TD]
[TD]20222[/TD]
[TD]5/12/1955[/TD]
[TD]5/13/1955[/TD]
[TD="bgcolor: transparent"]Plastic[/TD]
[TD="bgcolor: transparent"]0.1875[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]268[/TD]
[TD="bgcolor: transparent"]7/5/2019[/TD]
[TD]20193[/TD]
[TD]20197[/TD]
[TD]4/14/1955[/TD]
[TD]4/18/1955[/TD]
[TD="bgcolor: transparent"]Plastic[/TD]
[TD="bgcolor: transparent"]0.1875[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]30[/TD]
[TD="bgcolor: transparent"]12/22/2019[/TD]
[TD]20194[/TD]
[TD]201912[/TD]
[TD]4/15/1955[/TD]
[TD]10/23/2452[/TD]
[TD="bgcolor: transparent"]Poly[/TD]
[TD="bgcolor: transparent"]0.125[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]606[/TD]
[TD="bgcolor: transparent"]1/19/2020[/TD]
[TD]20201[/TD]
[TD]20201[/TD]
[TD]4/22/1955[/TD]
[TD]4/22/1955[/TD]
[TD="bgcolor: transparent"]Poly[/TD]
[TD="bgcolor: transparent"]0.125[/TD]
[TD]2[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]107[/TD]
[TD="bgcolor: transparent"]7/7/2020[/TD]
[TD]20203[/TD]
[TD]20207[/TD]
[TD]4/24/1955[/TD]
[TD]4/28/1955[/TD]
[TD="bgcolor: transparent"]Brass[/TD]
[TD="bgcolor: transparent"]0.21875[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]350[/TD]
[TD="bgcolor: transparent"]5/18/2019[/TD]
[TD]20192[/TD]
[TD]20195[/TD]
[TD]4/13/1955[/TD]
[TD]4/16/1955[/TD]
[TD="bgcolor: transparent"]Paper[/TD]
[TD="bgcolor: transparent"]0.25[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]563[/TD]
[TD="bgcolor: transparent"]6/26/2020[/TD]
[TD]20202[/TD]
[TD]20206[/TD]
[TD]4/23/1955[/TD]
[TD]4/27/1955[/TD]
[TD="bgcolor: transparent"]Brass[/TD]
[TD="bgcolor: transparent"]0.21875[/TD]
[TD]3[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]250[/TD]
[TD="bgcolor: transparent"]8/18/2019[/TD]
[TD]20193[/TD]
[TD]20198[/TD]
[TD]4/14/1955[/TD]
[TD]4/19/1955[/TD]
[TD="bgcolor: transparent"]Brass[/TD]
[TD="bgcolor: transparent"]0.21875[/TD]
[TD]3[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]366[/TD]
[TD="bgcolor: transparent"]6/16/2019[/TD]
[TD]20192[/TD]
[TD]20196[/TD]
[TD]4/13/1955[/TD]
[TD]4/17/1955[/TD]
[TD="bgcolor: transparent"]Brass[/TD]
[TD="bgcolor: transparent"]0.21875[/TD]
[TD]4[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]550[/TD]
[TD="bgcolor: transparent"]11/10/2021[/TD]
[TD]20214[/TD]
[TD]202111[/TD]
[TD]5/5/1955[/TD]
[TD]5/10/2453[/TD]
[TD="bgcolor: transparent"]Brass[/TD]
[TD="bgcolor: transparent"]0.0625[/TD]
[TD]6[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]492[/TD]
[TD="bgcolor: transparent"]11/11/2020[/TD]
[TD]20204[/TD]
[TD]202011[/TD]
[TD]4/25/1955[/TD]
[TD]1/30/2453[/TD]
[TD="bgcolor: transparent"]Wood[/TD]
[TD="bgcolor: transparent"]0.25[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]428[/TD]
[TD="bgcolor: transparent"]5/25/2020[/TD]
[TD]20202[/TD]
[TD]20205[/TD]
[TD]4/23/1955[/TD]
[TD]4/26/1955[/TD]
[TD="bgcolor: transparent"]Steel[/TD]
[TD="bgcolor: transparent"]0.25[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]235[/TD]
[TD="bgcolor: transparent"]11/27/2020[/TD]
[TD]20204[/TD]
[TD]202011[/TD]
[TD]4/25/1955[/TD]
[TD]1/30/2453[/TD]
[TD="bgcolor: transparent"]Paper[/TD]
[TD="bgcolor: transparent"]0.25[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]826[/TD]
[TD="bgcolor: transparent"]4/26/2025[/TD]
[TD]20252[/TD]
[TD]20254[/TD]
[TD]6/12/1955[/TD]
[TD]6/14/1955[/TD]
[TD="bgcolor: transparent"]Wood[/TD]
[TD="bgcolor: transparent"]0.25[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]243[/TD]
[TD="bgcolor: transparent"]2/14/2021[/TD]
[TD]20211[/TD]
[TD]20212[/TD]
[TD]5/2/1955[/TD]
[TD]5/3/1955[/TD]
[TD="bgcolor: transparent"]Brass[/TD]
[TD="bgcolor: transparent"]0.21875[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]349[/TD]
[TD="bgcolor: transparent"]4/5/2021[/TD]
[TD]20212[/TD]
[TD]20214[/TD]
[TD]5/3/1955[/TD]
[TD]5/5/1955[/TD]
[TD="bgcolor: transparent"]Brass[/TD]
[TD="bgcolor: transparent"]0.21875[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]673[/TD]
[TD="bgcolor: transparent"]8/21/2022[/TD]
[TD]20223[/TD]
[TD]20228[/TD]
[TD]5/14/1955[/TD]
[TD]5/19/1955[/TD]
[TD="bgcolor: transparent"]Brass[/TD]
[TD="bgcolor: transparent"]0.21875[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]828[/TD]
[TD="bgcolor: transparent"]9/6/2022[/TD]
[TD]20223[/TD]
[TD]20229[/TD]
[TD]5/14/1955[/TD]
[TD]5/20/1955[/TD]
[TD="bgcolor: transparent"]Brass[/TD]
[TD="bgcolor: transparent"]0.21875[/TD]
[TD]1[/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD]154[/TD]
[TD="bgcolor: transparent"]12/2/2024[/TD]
[TD]20244[/TD]
[TD]202412[/TD]
[TD]6/4/1955[/TD]
[TD]3/7/2454[/TD]
[TD="bgcolor: transparent"]Brass[/TD]
[TD="bgcolor: transparent"]0.0625[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="width: 583"]
<colgroup style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: 400; line-height: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><col style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: 400; line-height: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><col style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: 400; line-height: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><col style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: 400; line-height: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;" span="7"></colgroup><tbody style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: 400; line-height: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;">[TR="bgcolor: transparent"]
[TD]Thank you,[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: transparent"]
[TD][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Sort by date Sort by votes
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]
A​
[/th][th]
B​
[/th][th]
C​
[/th][th]
D​
[/th][th]
E​
[/th][th]
F​
[/th][th]
G​
[/th][th]
H​
[/th][th]
I​
[/th][th]
J​
[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
1​
[/td][td]Item[/td][td]Actual Date[/td][td]Quarter Text[/td][td]Month Text[/td][td]Quarter Value[/td][td]Month Value[/td][td]Material[/td][td]Size[/td][td]Sum Product Ranking[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
2​
[/td][td]
970​
[/td][td]
8/4/2019​
[/td][td]
20193​
[/td][td]
20198​
[/td][td]
4/14/1955​
[/td][td]
4/19/1955​
[/td][td]Brass[/td][td]
0.21875​
[/td][td]
1​
[/td][td]
19.16​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
3​
[/td][td]
254​
[/td][td]
12/2/2018​
[/td][td]
20184​
[/td][td]
201812​
[/td][td]
4/5/1955​
[/td][td]
7/15/2452​
[/td][td]Brass[/td][td]
0.09375​
[/td][td]
4​
[/td][td]
4.37​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
4​
[/td][td]
345​
[/td][td]
1/24/2019​
[/td][td]
20191​
[/td][td]
20191​
[/td][td]
4/12/1955​
[/td][td]
4/12/1955​
[/td][td]Brass[/td][td]
0.09375​
[/td][td]
6​
[/td][td]
10.4​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
5​
[/td][td]
883​
[/td][td]
5/28/2018​
[/td][td]
20182​
[/td][td]
20185​
[/td][td]
4/3/1955​
[/td][td]
4/6/1955​
[/td][td]Steel[/td][td]
0.25​
[/td][td]
1​
[/td][td]
0​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
6​
[/td][td]
988​
[/td][td]
7/20/2018​
[/td][td]
20183​
[/td][td]
20187​
[/td][td]
4/4/1955​
[/td][td]
4/8/1955​
[/td][td]Wood[/td][td]
0.25​
[/td][td]
1​
[/td][td]
1.1​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
7​
[/td][td]
302​
[/td][td]
8/17/2018​
[/td][td]
20183​
[/td][td]
20188​
[/td][td]
4/4/1955​
[/td][td]
4/9/1955​
[/td][td]Plastic[/td][td]
0.25​
[/td][td]
1​
[/td][td]
1.2​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
8​
[/td][td]
94​
[/td][td]
8/11/2018​
[/td][td]
20183​
[/td][td]
20188​
[/td][td]
4/4/1955​
[/td][td]
4/9/1955​
[/td][td]Brass[/td][td]
0.0625​
[/td][td]
2​
[/td][td]
1.2​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
9​
[/td][td]
242​
[/td][td]
11/26/2018​
[/td][td]
20184​
[/td][td]
201811​
[/td][td]
4/5/1955​
[/td][td]
7/14/2452​
[/td][td]Brass[/td][td]
0.0625​
[/td][td]
2​
[/td][td]
4.34​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
10​
[/td][td]
280​
[/td][td]
11/8/2018​
[/td][td]
20184​
[/td][td]
201811​
[/td][td]
4/5/1955​
[/td][td]
7/14/2452​
[/td][td]Brass[/td][td]
0.21875​
[/td][td]
3​
[/td][td]
4.34​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
11​
[/td][td]
606​
[/td][td]
11/10/2018​
[/td][td]
20184​
[/td][td]
201811​
[/td][td]
4/5/1955​
[/td][td]
7/14/2452​
[/td][td]Brass[/td][td]
0.21875​
[/td][td]
3​
[/td][td]
4.34​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
12​
[/td][td]
347​
[/td][td]
10/8/2018​
[/td][td]
20184​
[/td][td]
201810​
[/td][td]
4/5/1955​
[/td][td]
7/13/2452​
[/td][td]Plastic[/td][td]
0.1875​
[/td][td]
3​
[/td][td]
4.32​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
13​
[/td][td]
965​
[/td][td]
10/18/2018​
[/td][td]
20184​
[/td][td]
201810​
[/td][td]
4/5/1955​
[/td][td]
7/13/2452​
[/td][td]Plastic[/td][td]
0.1875​
[/td][td]
1​
[/td][td]
4.32​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
14​
[/td][td]
479​
[/td][td]
4/6/2019​
[/td][td]
20192​
[/td][td]
20194​
[/td][td]
4/13/1955​
[/td][td]
4/15/1955​
[/td][td]Poly[/td][td]
0.125​
[/td][td]
1​
[/td][td]
13.7​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
15​
[/td][td]
313​
[/td][td]
5/3/2019​
[/td][td]
20192​
[/td][td]
20195​
[/td][td]
4/13/1955​
[/td][td]
4/16/1955​
[/td][td]Poly[/td][td]
0.125​
[/td][td]
1​
[/td][td]
13.9​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
16​
[/td][td]
354​
[/td][td]
10/20/2019​
[/td][td]
20194​
[/td][td]
201910​
[/td][td]
4/15/1955​
[/td][td]
10/21/2452​
[/td][td]Brass[/td][td]
0.21875​
[/td][td]
3​
[/td][td]
26.38​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
17​
[/td][td]
419​
[/td][td]
6/8/2020​
[/td][td]
20202​
[/td][td]
20206​
[/td][td]
4/23/1955​
[/td][td]
4/27/1955​
[/td][td]Brass[/td][td]
0.09375​
[/td][td]
1​
[/td][td]
29.23​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
18​
[/td][td]
201​
[/td][td]
7/12/2019​
[/td][td]
20193​
[/td][td]
20197​
[/td][td]
4/14/1955​
[/td][td]
4/18/1955​
[/td][td]Brass[/td][td]
0.09375​
[/td][td]
3​
[/td][td]
19.13​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
19​
[/td][td]
960​
[/td][td]
1/7/2019​
[/td][td]
20191​
[/td][td]
20191​
[/td][td]
4/12/1955​
[/td][td]
4/12/1955​
[/td][td]Wood[/td][td]
0.25​
[/td][td]
1​
[/td][td]
10.4​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
20​
[/td][td]
593​
[/td][td]
2/5/2019​
[/td][td]
20191​
[/td][td]
20192​
[/td][td]
4/12/1955​
[/td][td]
4/13/1955​
[/td][td]Plastic[/td][td]
0.25​
[/td][td]
1​
[/td][td]
10.6​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
21​
[/td][td]
224​
[/td][td]
5/2/2020​
[/td][td]
20202​
[/td][td]
20205​
[/td][td]
4/23/1955​
[/td][td]
4/26/1955​
[/td][td]Brass[/td][td]
0.21875​
[/td][td]
3​
[/td][td]
29.21​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
22​
[/td][td]
114​
[/td][td]
5/10/2019​
[/td][td]
20192​
[/td][td]
20195​
[/td][td]
4/13/1955​
[/td][td]
4/16/1955​
[/td][td]Brass[/td][td]
0.0625​
[/td][td]
1​
[/td][td]
13.9​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
23​
[/td][td]
235​
[/td][td]
8/14/2019​
[/td][td]
20193​
[/td][td]
20198​
[/td][td]
4/14/1955​
[/td][td]
4/19/1955​
[/td][td]Brass[/td][td]
0.0625​
[/td][td]
3​
[/td][td]
19.16​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
24​
[/td][td]
81​
[/td][td]
8/10/2019​
[/td][td]
20193​
[/td][td]
20198​
[/td][td]
4/14/1955​
[/td][td]
4/19/1955​
[/td][td]Brass[/td][td]
0.21875​
[/td][td]
4​
[/td][td]
19.16​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
25​
[/td][td]
660​
[/td][td]
7/17/2019​
[/td][td]
20193​
[/td][td]
20197​
[/td][td]
4/14/1955​
[/td][td]
4/18/1955​
[/td][td]Brass[/td][td]
0.21875​
[/td][td]
4​
[/td][td]
19.13​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
26​
[/td][td]
272​
[/td][td]
4/6/2019​
[/td][td]
20192​
[/td][td]
20194​
[/td][td]
4/13/1955​
[/td][td]
4/15/1955​
[/td][td]Brass[/td][td]
0.21875​
[/td][td]
1​
[/td][td]
13.7​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
27​
[/td][td]
819​
[/td][td]
2/14/2022​
[/td][td]
20221​
[/td][td]
20222​
[/td][td]
5/12/1955​
[/td][td]
5/13/1955​
[/td][td]Plastic[/td][td]
0.1875​
[/td][td]
1​
[/td][td]
39.28​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
28​
[/td][td]
268​
[/td][td]
7/5/2019​
[/td][td]
20193​
[/td][td]
20197​
[/td][td]
4/14/1955​
[/td][td]
4/18/1955​
[/td][td]Plastic[/td][td]
0.1875​
[/td][td]
1​
[/td][td]
19.13​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
29​
[/td][td]
30​
[/td][td]
12/22/2019​
[/td][td]
20194​
[/td][td]
201912​
[/td][td]
4/15/1955​
[/td][td]
10/23/2452​
[/td][td]Poly[/td][td]
0.125​
[/td][td]
1​
[/td][td]
26.39​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
30​
[/td][td]
606​
[/td][td]
1/19/2020​
[/td][td]
20201​
[/td][td]
20201​
[/td][td]
4/22/1955​
[/td][td]
4/22/1955​
[/td][td]Poly[/td][td]
0.125​
[/td][td]
2​
[/td][td]
28.2​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
31​
[/td][td]
107​
[/td][td]
7/7/2020​
[/td][td]
20203​
[/td][td]
20207​
[/td][td]
4/24/1955​
[/td][td]
4/28/1955​
[/td][td]Brass[/td][td]
0.21875​
[/td][td]
1​
[/td][td]
33.25​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
32​
[/td][td]
350​
[/td][td]
5/18/2019​
[/td][td]
20192​
[/td][td]
20195​
[/td][td]
4/13/1955​
[/td][td]
4/16/1955​
[/td][td]Paper[/td][td]
0.25​
[/td][td]
1​
[/td][td]
13.9​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
33​
[/td][td]
563​
[/td][td]
6/26/2020​
[/td][td]
20202​
[/td][td]
20206​
[/td][td]
4/23/1955​
[/td][td]
4/27/1955​
[/td][td]Brass[/td][td]
0.21875​
[/td][td]
3​
[/td][td]
29.23​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
34​
[/td][td]
250​
[/td][td]
8/18/2019​
[/td][td]
20193​
[/td][td]
20198​
[/td][td]
4/14/1955​
[/td][td]
4/19/1955​
[/td][td]Brass[/td][td]
0.21875​
[/td][td]
3​
[/td][td]
19.16​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
35​
[/td][td]
366​
[/td][td]
6/16/2019​
[/td][td]
20192​
[/td][td]
20196​
[/td][td]
4/13/1955​
[/td][td]
4/17/1955​
[/td][td]Brass[/td][td]
0.21875​
[/td][td]
4​
[/td][td]
13.12​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
36​
[/td][td]
550​
[/td][td]
11/10/2021​
[/td][td]
20214​
[/td][td]
202111​
[/td][td]
5/5/1955​
[/td][td]
5/10/2453​
[/td][td]Brass[/td][td]
0.0625​
[/td][td]
6​
[/td][td]
38.42​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
37​
[/td][td]
492​
[/td][td]
11/11/2020​
[/td][td]
20204​
[/td][td]
202011​
[/td][td]
4/25/1955​
[/td][td]
1/30/2453​
[/td][td]Wood[/td][td]
0.25​
[/td][td]
1​
[/td][td]
34.4​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
38​
[/td][td]
428​
[/td][td]
5/25/2020​
[/td][td]
20202​
[/td][td]
20205​
[/td][td]
4/23/1955​
[/td][td]
4/26/1955​
[/td][td]Steel[/td][td]
0.25​
[/td][td]
1​
[/td][td]
29.21​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
39​
[/td][td]
235​
[/td][td]
11/27/2020​
[/td][td]
20204​
[/td][td]
202011​
[/td][td]
4/25/1955​
[/td][td]
1/30/2453​
[/td][td]Paper[/td][td]
0.25​
[/td][td]
1​
[/td][td]
34.4​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
40​
[/td][td]
826​
[/td][td]
4/26/2025​
[/td][td]
20252​
[/td][td]
20254​
[/td][td]
6/12/1955​
[/td][td]
6/14/1955​
[/td][td]Wood[/td][td]
0.25​
[/td][td]
1​
[/td][td]
43.31​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
41​
[/td][td]
243​
[/td][td]
2/14/2021​
[/td][td]
20211​
[/td][td]
20212​
[/td][td]
5/2/1955​
[/td][td]
5/3/1955​
[/td][td]Brass[/td][td]
0.21875​
[/td][td]
1​
[/td][td]
36.26​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
42​
[/td][td]
349​
[/td][td]
4/5/2021​
[/td][td]
20212​
[/td][td]
20214​
[/td][td]
5/3/1955​
[/td][td]
5/5/1955​
[/td][td]Brass[/td][td]
0.21875​
[/td][td]
1​
[/td][td]
37.27​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
43​
[/td][td]
673​
[/td][td]
8/21/2022​
[/td][td]
20223​
[/td][td]
20228​
[/td][td]
5/14/1955​
[/td][td]
5/19/1955​
[/td][td]Brass[/td][td]
0.21875​
[/td][td]
1​
[/td][td]
40.29​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
44​
[/td][td]
828​
[/td][td]
9/6/2022​
[/td][td]
20223​
[/td][td]
20229​
[/td][td]
5/14/1955​
[/td][td]
5/20/1955​
[/td][td]Brass[/td][td]
0.21875​
[/td][td]
1​
[/td][td]
40.3​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
45​
[/td][td]
154​
[/td][td]
12/2/2024​
[/td][td]
20244​
[/td][td]
202412​
[/td][td]
6/4/1955​
[/td][td]
3/7/2454​
[/td][td]Brass[/td][td]
0.0625​
[/td][td]
2​
[/td][td]
42.43​
[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet29[/td][/tr][/table]

Formula in cell J2:
=(COUNTIF($E$2:$E$45,"<"&E2)&"."&COUNTIF($F$2:$F$45,"<"&F2))*1
 
Upvote 0
Wow, that is very cool. How would I add more criteria? I tried the below to bring in material but I got the #value error.

=(COUNTIF($E$3:$E$45,"<"&E3)&"."&COUNTIF($F$3:$F$45,"<"&F3)&"."&COUNTIF($G$3:$G$45,"<"&G3))*1
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
1K
AndyEd
A
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C
A
  • Solved
Calendar issue
Replies
1
Views
2K
AndyEd
A
L
  • Question Question
VBA works on work PC but not home PC
Replies
3
Views
2K
rollis13
rollis13

Forum statistics

Threads
1,224,823
Messages
6,181,178
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top