count formula complicated

nostradamus

nostradamus

Board Regular
Joined
Aug 9, 2010
Messages
143
Office Version
  1. 365
Platform
  1. Windows
Hi, I have a few questions - might get messy, but will try pointwise
Let us assume that there is no correlation bet. cities and states (lame ex. I know)

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cagrubh%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><o:smarttagtype namespaceuri="urn:schemas-microsoft-com:eek:ffice:smarttags" name="City"></o:smarttagtype><o:smarttagtype namespaceuri="urn:schemas-microsoft-com:eek:ffice:smarttags" name="State"></o:smarttagtype><o:smarttagtype namespaceuri="urn:schemas-microsoft-com:eek:ffice:smarttags" name="place"></o:smarttagtype><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if !mso]>******** classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object> <style> st1\:*{behavior:url(#ieooui) } </style> <![endif]--><style> <!-- /* Font Definitions */ @font-face {font-family:Cambria; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1073741899 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> <table class="MsoNormalTable" style="width: 333pt; margin-left: 5.15pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="444"> <tbody><tr style="height: 12.75pt;"> <td style="width: 20pt; border: 1pt solid windowtext; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="27" nowrap="nowrap">
<o:p></o:p>​

</td> <td style="width: 52pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="69" nowrap="nowrap">
A<o:p></o:p>​
</td> <td style="width: 48pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
B<o:p></o:p>​
</td> <td style="width: 48pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
C<o:p></o:p>​
</td> <td style="width: 56pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
D<o:p></o:p>​
</td> <td style="width: 56pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
E<o:p></o:p>​
</td> <td style="width: 53pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="71" nowrap="nowrap">
F<o:p></o:p>​
</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 20pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="27" nowrap="nowrap">
1<o:p></o:p>​
</td> <td style="width: 52pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="69" nowrap="nowrap"> State<o:p></o:p>
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> Cities<o:p></o:p>
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> Nos<o:p></o:p>
</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap"> <o:p></o:p>
</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap"> <o:p></o:p>
</td> <td style="width: 53pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="71" nowrap="nowrap"> <o:p></o:p>
</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 20pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="27" nowrap="nowrap">
2<o:p></o:p>​
</td> <td style="width: 52pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="69" nowrap="nowrap"> <st1:state w:st="on"><st1:place w:st="on">Ohio</st1:place></st1:state><o:p></o:p>
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
<st1:city w:st="on"><st1:place w:st="on">columbus</st1:place></st1:city><o:p></o:p>​
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="64" nowrap="nowrap">
55<o:p></o:p>​
</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
Count<o:p></o:p>​
</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap"> <o:p></o:p>
</td> <td style="width: 53pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="71" nowrap="nowrap">
<o:p></o:p>​

</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 20pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="27" nowrap="nowrap">
3<o:p></o:p>​
</td> <td style="width: 52pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="69" nowrap="nowrap"> <st1:state w:st="on"><st1:place w:st="on">New York</st1:place></st1:state><o:p></o:p>
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
<st1:city w:st="on"><st1:place w:st="on">columbus</st1:place></st1:city><o:p></o:p>​
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="64" nowrap="nowrap">
21<o:p></o:p>​
</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
Dominance<o:p></o:p>​
</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
<o:p></o:p>​

</td> <td style="width: 53pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="71" nowrap="nowrap">
<o:p></o:p>​

</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 20pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="27" nowrap="nowrap">
4<o:p></o:p>​
</td> <td style="width: 52pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="69" nowrap="nowrap"> <st1:state w:st="on"><st1:place w:st="on">Texas</st1:place></st1:state><o:p></o:p>
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
<st1:city w:st="on"><st1:place w:st="on">akron</st1:place></st1:city><o:p></o:p>​
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="64" nowrap="nowrap">
32<o:p></o:p>​
</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
Percent<o:p></o:p>​
</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
<o:p></o:p>​

</td> <td style="width: 53pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="71" nowrap="nowrap">
<o:p></o:p>​

</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 20pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="27" nowrap="nowrap">
5<o:p></o:p>​
</td> <td style="width: 52pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="69" nowrap="nowrap"> <st1:state w:st="on"><st1:place w:st="on">Idaho</st1:place></st1:state><o:p></o:p>
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
<st1:city w:st="on"><st1:place w:st="on">athens</st1:place></st1:city><o:p></o:p>​
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="64" nowrap="nowrap">
68<o:p></o:p>​
</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
<o:p></o:p>​

</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
<o:p></o:p>​

</td> <td style="width: 53pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="71" nowrap="nowrap">
<o:p></o:p>​

</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 20pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="27" nowrap="nowrap">
6<o:p></o:p>​
</td> <td style="width: 52pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="69" nowrap="nowrap"> <st1:state w:st="on"><st1:place w:st="on">Washington</st1:place></st1:state><o:p></o:p>
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
<st1:city w:st="on"><st1:place w:st="on">bedford</st1:place></st1:city><o:p></o:p>​
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="64" nowrap="nowrap">
24<o:p></o:p>​
</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
<o:p></o:p>​

</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
<o:p></o:p>​

</td> <td style="width: 53pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="71" nowrap="nowrap">
<o:p></o:p>​

</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 20pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="27" nowrap="nowrap">
7<o:p></o:p>​
</td> <td style="width: 52pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="69" nowrap="nowrap"> <st1:state w:st="on"><st1:place w:st="on">Montana</st1:place></st1:state><o:p></o:p>
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
bexley<o:p></o:p>​
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="64" nowrap="nowrap">
15<o:p></o:p>​
</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
<o:p></o:p>​

</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
<o:p></o:p>​

</td> <td style="width: 53pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="71" nowrap="nowrap">
<o:p></o:p>​

</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 20pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="27" nowrap="nowrap">
8<o:p></o:p>​
</td> <td style="width: 52pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="69" nowrap="nowrap"> <st1:state w:st="on"><st1:place w:st="on">Oklahoma</st1:place></st1:state><o:p></o:p>
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
bexley<o:p></o:p>​
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="64" nowrap="nowrap">
54<o:p></o:p>​
</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
<o:p></o:p>​

</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
<o:p></o:p>​

</td> <td style="width: 53pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="71" nowrap="nowrap">
<o:p></o:p>​

</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 20pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="27" nowrap="nowrap">
9<o:p></o:p>​
</td> <td style="width: 52pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="69" nowrap="nowrap"> <st1:state w:st="on"><st1:place w:st="on">Arkansas</st1:place></st1:state><o:p></o:p>
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
bexley<o:p></o:p>​
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="64" nowrap="nowrap">
71<o:p></o:p>​
</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
<o:p></o:p>​

</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
<o:p></o:p>​

</td> <td style="width: 53pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="71" nowrap="nowrap">
<o:p></o:p>​

</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 20pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="27" nowrap="nowrap">
10<o:p></o:p>​
</td> <td style="width: 52pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="69" nowrap="nowrap"> <st1:state w:st="on"><st1:place w:st="on">Maine</st1:place></st1:state><o:p></o:p>
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
<st1:city w:st="on"><st1:place w:st="on">bryan</st1:place></st1:city><o:p></o:p>​
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="64" nowrap="nowrap">
18<o:p></o:p>​
</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
<o:p></o:p>​

</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
<o:p></o:p>​

</td> <td style="width: 53pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="71" nowrap="nowrap">
<o:p></o:p>​

</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 20pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="27" nowrap="nowrap">
11<o:p></o:p>​
</td> <td style="width: 52pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="69" nowrap="nowrap"> <st1:state w:st="on"><st1:place w:st="on">Florida</st1:place></st1:state><o:p></o:p>
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
clyde<o:p></o:p>​
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="64" nowrap="nowrap">
19<o:p></o:p>​
</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
<o:p></o:p>​

</td> <td style="width: 56pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap">
<o:p></o:p>​

</td> <td style="width: 53pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="71" nowrap="nowrap">
<o:p></o:p>​

</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 20pt; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="27" nowrap="nowrap"> <o:p> </o:p>
</td> <td style="width: 52pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="69" nowrap="nowrap">
Total<o:p></o:p>​
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 12.75pt;" x:num="" x:fmla="=SUM(D3:D12)" valign="bottom" width="64" nowrap="nowrap">
377<o:p></o:p>​
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o:p> </o:p>
</td> <td style="width: 56pt; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap"> <o:p> </o:p>
</td> <td style="width: 56pt; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="75" nowrap="nowrap"> <o:p> </o:p>
</td> <td style="width: 53pt; padding: 0in 5.4pt; height: 12.75pt;" valign="bottom" width="71" nowrap="nowrap"> <o:p> </o:p>
</td> </tr> </tbody></table>
1. Count # of Cities under Col E2 (I know it's 7), but need formula
2. Count # of States under col F2 (from col A range)
3. under col E3 = city that occurs max no. of times under col B
4. under col F3 = total value from col C of the city that occurs max under col B
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Sort by date Sort by votes
3. under col E3 = city that occurs max no. of times under col B
Click to expand...

What should happen in the case of a draw (i.e. two Cities appear the same number of times)?

Matty
 
Upvote 0
all of these are array formulas (entered with ctrl+shift+enter)

1. Count # of Cities under Col E2 (I know it's 7), but need formula
=SUM(1/COUNTIF(B2:B11,B2:B11))

2. Count # of States under col F2 (from col A range)
=SUM(1/COUNTIF(A2:A11,A2:A11))

3. under col E3 = city that occurs max no. of times under col B
=INDEX(B2:B11,MAX(IF(COUNTIF(B2:B11,B2:B11)=MAX(COUNTIF(B2:B11,B2:B11)),ROW(B2:B11)))-1)

4. under col F3 = total value from col C of the city that occurs max under col B
=SUM(IF(COUNTIF(B2:B11,B2:B11)=MAX(COUNTIF(B2:B11,B2:B11)),C2:C11,FALSE))
 
Last edited:
Upvote 0
I'd change #3 and 4
=INDEX(B:B,MAX(IF(COUNTIF(B2:B11,B2:B11)=MAX(COUNTIF(B2:B11,B2:B11)),ROW(B2:B11)))-1)
 
Upvote 0
Wouldn't #4 simply be:

Code: 
=SUMIF(B2:B11,E3,C2:C11)

And we still don't know what's going on in case of a draw situation...

Matty
 
Last edited:
Upvote 0
Matty,
Interesting point you make, what if 2 cities occur the same no. of times. Hadn't thought about that
In that case I'll have to show both cities, or all the cities that have same values.
Would have to find a way for top 4 ranking cities to appear under col. E3, F3, G3, H3.
Thanks :)
 
Upvote 0
Perhaps a set up like this could work for you:

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 73px"><COL style="WIDTH: 62px"><COL style="WIDTH: 29px"><COL style="WIDTH: 86px"><COL style="WIDTH: 157px"><COL style="WIDTH: 67px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">State</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Cities</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Nos</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Occurrences</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Cities</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">States</TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Ohio</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">columbus</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">55</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">2</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Count</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">7</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">10</TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">New York</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">columbus</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">21</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Most Frequent</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">3</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Texas</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">akron</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">32</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Count of Most Frequent</TD><TD style="TEXT-ALIGN: right">1</TD><TD></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Idaho</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">athens</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">68</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Dominance</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">bexley</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">140</TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Washington</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">bedford</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">24</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Montana</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">bexley</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">3</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Oklahoma</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">bexley</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">54</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Arkansas</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">bexley</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">71</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Maine</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">bryan</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">18</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Florida</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">clyde</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">19</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Total</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">377</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR></TBODY></TABLE>

Formulas are...

D2, and copied down to D11:

Code: 
=IF(B2<>"",IF(ISNUMBER(MATCH(B2,B$1:B1,0)),"",COUNTIF(B$2:B$11,B2)),"")

F2 (array entry):

Code: 
=SUM(IF(FREQUENCY(IF(B2:B11<>"",MATCH(B2:B11,B2:B11,0)),ROW(B2:B11)-ROW(B2)+1),1))

G2 (array entry):

Code: 
=SUM(IF(FREQUENCY(IF(A2:A11<>"",MATCH(A2:A11,A2:A11,0)),ROW(A2:A11)-ROW(A2)+1),1))

F3:

Code: 
=MAX(D2:D11)

F4:

Code: 
=COUNTIF(D2:D11,F3)

F5, and copied down as far as likely to be required (array entry):

Code: 
=IF(ROWS(F$5:F5)<=F$4,INDEX(B$2:B$11,SMALL(IF(D$2:D$11=F$3,ROW(D$2:D$11)-ROW(D$2)+1),ROWS(F$5:F5))),"")

G5, and copied down as far as likely to be required

Code: 
=IF(F5<>"",SUMIF(B2:B11,F5,C2:C11),"")

You will need to find a new place to house Percent, as the Cells in that Row are now used by the Dominance formulas...

Hope this helps.

Matty
 
Upvote 0
Thanks Matty, I'll take a few to go thru your formulas with my head unmuddled
:oops:
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
836
gvsumich
G
E
  • Question
Adding a custom message.
Replies
1
Views
431
Micron
M
E
  • Question
VBA for Web Scraping help
Replies
0
Views
594
epactheactor
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C

Forum statistics

Threads
1,215,066
Messages
6,122,948
Members
449,095
Latest member
nmaske

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