Need help with a formula - hlookup maybe?

M

MagnumOpus

New Member
Joined
Apr 27, 2011
Messages
17
Hi,

I'm trying to compare two arrays that each contain 4 numbers, along with another array that contains 3 numbers to find common numbers between all three arrays. The "Key Digits" are in columns R-S-T-U, the "Mirrors" are in columns Y-Z-AA-AB, and the "RBG" numbers are in columns AE-AF-AG. I'd like a 'pull-down' formula that does a comparison and displays matching numbers into columns AH-AI-AJ (labeled "Match" below). Here's the tricky part: because there are three columns to contain these "matching" numbers, there could be up to 3 digits that match, but there could also be no digits that match. If there are no digits that match, I'd like the function to leave the cells blank. There won't be duplicate values among matching digits. I've been doing this manually but there's a lot of data and I'm making mistakes due to eye strain and fatigue, so any help would be appreciated.

It looks like this:

<table style="width: 717px; height: 74px;" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:1365; width:29pt" width="38" span="3"> <col style="mso-width-source:userset;mso-width-alt:1365;width:29pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:1080;width:23pt" width="30"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:910;width:19pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:1365; width:29pt" width="38" span="3"> <col style="mso-width-source:userset;mso-width-alt:1365;width:29pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:910;width:19pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:2247;width:47pt" width="63"> <col style="mso-width-source:userset;mso-width-alt:1223; width:26pt" width="34" span="2"> <col style="mso-width-source:userset;mso-width-alt:1223;width:26pt" width="34"> <col style="mso-width-source:userset;mso-width-alt:1223; width:26pt" width="34" span="2"> <col style="mso-width-source:userset;mso-width-alt:1223;width:26pt" width="34"> </colgroup><tbody><tr style="height:14.4pt" height="19"> <td colspan="4" class="xl80" style="height:14.4pt;width:116pt" width="152" height="19">Key Digits
</td> <td class="xl77" style="width:23pt" width="30">
</td> <td class="xl77" style="width:48pt" width="64">Accuracy</td> <td class="xl72" style="border-left:none;width:19pt" width="26">
</td> <td colspan="4" class="xl81" style="border-right:.5pt solid black; border-left:none;width:116pt" width="152">Mirrors</td> <td class="xl75" style="width:19pt" width="26">
</td> <td class="xl77" style="width:47pt" width="63">Accuracy</td> <td colspan="3" class="xl76" style="border-right:.5pt solid black; width:78pt" width="102">RBG</td> <td colspan="3" class="xl82" style="border-right:.5pt solid black; border-left:none;width:78pt" width="102">Match</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl76" style="height:14.4pt" height="19">2</td> <td class="xl76">5</td> <td class="xl76">6</td> <td class="xl77">9</td> <td class="xl77">
</td> <td class="xl71">0%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl76">7</td> <td class="xl76">0</td> <td class="xl76">1</td> <td class="xl77">4</td> <td class="xl75">
</td> <td class="xl71">0%</td> <td class="xl76">4</td> <td class="xl76">5</td> <td class="xl77">9</td> <td class="xl78">
</td> <td class="xl78">
</td> <td class="xl79">
</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl76" style="height:14.4pt" height="19">2</td> <td class="xl76">5</td> <td class="xl76">6</td> <td class="xl77">9</td> <td class="xl77">
</td> <td class="xl71">0%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl76">7</td> <td class="xl76">0</td> <td class="xl76">1</td> <td class="xl77">4</td> <td class="xl75">
</td> <td class="xl71">0%</td> <td class="xl76">4</td> <td class="xl76">5</td> <td class="xl77">9</td> <td class="xl78">
</td> <td class="xl78">
</td> <td class="xl79">
</td> </tr> </tbody></table>
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Sort by date Sort by votes
Is the match ordinal? Or any position matches any position? Must appear in all three? Or any two of the three?

Probably help enormously if you could provide five to eight rows of (differing) sample data and example desired results.
 
Upvote 0
Thanks for the responses. Here's what a match looks like:

<table width="717" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:1365; width:29pt" width="38" span="3"> <col style="mso-width-source:userset;mso-width-alt:1365;width:29pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:1080;width:23pt" width="30"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:910;width:19pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:1365; width:29pt" width="38" span="3"> <col style="mso-width-source:userset;mso-width-alt:1365;width:29pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:910;width:19pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:2247;width:47pt" width="63"> <col style="mso-width-source:userset;mso-width-alt:1223; width:26pt" width="34" span="2"> <col style="mso-width-source:userset;mso-width-alt:1223;width:26pt" width="34"> <col style="mso-width-source:userset;mso-width-alt:1223; width:26pt" width="34" span="2"> <col style="mso-width-source:userset;mso-width-alt:1223;width:26pt" width="34"> </colgroup><tbody><tr style="height:14.4pt" height="19"> <td colspan="4" class="xl80" style="height:14.4pt;width:116pt" width="152" height="19">Key Digits</td> <td class="xl76" style="width:23pt" width="30">
</td> <td class="xl76" style="width:48pt" width="64">Accuracy</td> <td class="xl72" style="border-left:none;width:19pt" width="26">
</td> <td colspan="4" class="xl81" style="border-right:.5pt solid black; border-left:none;width:116pt" width="152">Key Digit Mirrors</td> <td class="xl75" style="width:19pt" width="26">
</td> <td class="xl76" style="width:47pt" width="63">Accuracy</td> <td colspan="3" class="xl77" style="border-right:.5pt solid black; width:78pt" width="102">RBG</td> <td colspan="3" class="xl82" style="border-right:.5pt solid black; border-left:none;width:78pt" width="102">Match</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl77" style="height:14.4pt" height="19">2</td> <td class="xl77">5</td> <td class="xl77">6</td> <td class="xl76">9</td> <td class="xl76">
</td> <td class="xl71">0%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl77">7</td> <td class="xl77">0</td> <td class="xl77">1</td> <td class="xl76">4</td> <td class="xl75">
</td> <td class="xl71">0%</td> <td class="xl77">4</td> <td class="xl77">5</td> <td class="xl76">9</td> <td class="xl79">
</td> <td class="xl79">
</td> <td class="xl78">
</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl77" style="height:14.4pt" height="19">2</td> <td class="xl77">5</td> <td class="xl77">6</td> <td class="xl76">9</td> <td class="xl76">
</td> <td class="xl71">0%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl77">7</td> <td class="xl77">0</td> <td class="xl77">1</td> <td class="xl76">4</td> <td class="xl75">
</td> <td class="xl71">0%</td> <td class="xl77">4</td> <td class="xl77">5</td> <td class="xl76">9</td> <td class="xl79">
</td> <td class="xl79">
</td> <td class="xl78">
</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl77" style="height:14.4pt" height="19">0</td> <td class="xl77">5</td> <td class="xl77">6</td> <td class="xl76">9</td> <td class="xl76">
</td> <td class="xl71">0%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl77">5</td> <td class="xl77">0</td> <td class="xl77">1</td> <td class="xl76">4</td> <td class="xl75">
</td> <td class="xl71">0%</td> <td class="xl77">8</td> <td class="xl77">9</td> <td class="xl76">
</td> <td class="xl79">
</td> <td class="xl79">
</td> <td class="xl78">
</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl77" style="height:14.4pt" height="19">0</td> <td class="xl77">5</td> <td class="xl77">6</td> <td class="xl76">9</td> <td class="xl76">
</td> <td class="xl71">0%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl77">5</td> <td class="xl77">0</td> <td class="xl77">1</td> <td class="xl76">4</td> <td class="xl75">
</td> <td class="xl71">0%</td> <td class="xl77">8</td> <td class="xl77">9</td> <td class="xl76">
</td> <td class="xl79">
</td> <td class="xl79">
</td> <td class="xl78">
</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl77" style="height:14.4pt" height="19">2</td> <td class="xl77">5</td> <td class="xl77">6</td> <td class="xl76">9</td> <td class="xl76">
</td> <td class="xl71">0%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl77">7</td> <td class="xl77">0</td> <td class="xl77">1</td> <td class="xl76">4</td> <td class="xl75">
</td> <td class="xl71">0%</td> <td class="xl77">5</td> <td class="xl77">8</td> <td class="xl76">9</td> <td class="xl79">
</td> <td class="xl79">
</td> <td class="xl78">
</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl77" style="height:14.4pt" height="19">2</td> <td class="xl77">5</td> <td class="xl77">6</td> <td class="xl76">9</td> <td class="xl76">
</td> <td class="xl71">0%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl77">7</td> <td class="xl77">0</td> <td class="xl77">1</td> <td class="xl76">4</td> <td class="xl75">
</td> <td class="xl71">0%</td> <td class="xl77">5</td> <td class="xl77">8</td> <td class="xl76">9</td> <td class="xl79">
</td> <td class="xl79">
</td> <td class="xl78">
</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl77" style="height:14.4pt" height="19">2</td> <td class="xl77">4</td> <td class="xl77">5</td> <td class="xl76">9</td> <td class="xl76">
</td> <td class="xl71">0%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl77">7</td> <td class="xl77">9</td> <td class="xl77">0</td> <td class="xl76">4</td> <td class="xl75">
</td> <td class="xl71">0%</td> <td class="xl77">8</td> <td class="xl77">9</td> <td class="xl76">
</td> <td class="xl79">4</td> <td class="xl79">9</td> <td class="xl78">
</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl77" style="height:14.4pt" height="19">2</td> <td class="xl77">4</td> <td class="xl77">5</td> <td class="xl76">9</td> <td class="xl76">
</td> <td class="xl71">0%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl77">7</td> <td class="xl77">9</td> <td class="xl77">0</td> <td class="xl76">4</td> <td class="xl75">
</td> <td class="xl71">0%</td> <td class="xl77">8</td> <td class="xl77">9</td> <td class="xl76">
</td> <td class="xl79">4</td> <td class="xl79">9</td> <td class="xl78">
</td> </tr> </tbody></table>
 
Upvote 0
Greg Truby said:
Is the match ordinal? Or any position matches any position? Must appear in all three? Or any two of the three?
Click to expand...

I suppose the match is ordinal. Not all matches will contain all three digits. Actually most often there are only 1 or 2 matches if any.
 
Upvote 0
Magnum,

While you provided eight lines of data, you only provided four examples. Posting identical rows of data doesn't really offer any benefit.

Like Aladin, I'm stuggling to discern the logic here. As Aladin asked already, can you please articulate why the 4 & 9 are considered matches in the last row (and its twin above)?
 
Upvote 0
Sorry fellas, I've been working on this all week and apparently my eyes aren't working well today anymore :). Here's a revised example:

<table width="717" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:1365; width:29pt" width="38" span="3"> <col style="mso-width-source:userset;mso-width-alt:1365;width:29pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:1080;width:23pt" width="30"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:910;width:19pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:1365; width:29pt" width="38" span="3"> <col style="mso-width-source:userset;mso-width-alt:1365;width:29pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:910;width:19pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:2247;width:47pt" width="63"> <col style="mso-width-source:userset;mso-width-alt:1223; width:26pt" width="34" span="2"> <col style="mso-width-source:userset;mso-width-alt:1223;width:26pt" width="34"> <col style="mso-width-source:userset;mso-width-alt:1223; width:26pt" width="34" span="2"> <col style="mso-width-source:userset;mso-width-alt:1223;width:26pt" width="34"> </colgroup><tbody><tr style="height:14.4pt" height="19"> <td colspan="4" class="xl80" style="height:14.4pt;width:116pt" width="152" height="19">Key Digits</td> <td class="xl77" style="width:23pt" width="30">
</td> <td class="xl77" style="width:48pt" width="64">Accuracy</td> <td class="xl72" style="border-left:none;width:19pt" width="26">
</td> <td colspan="4" class="xl81" style="border-right:.5pt solid black; border-left:none;width:116pt" width="152">Key Digit Mirrors</td> <td class="xl75" style="width:19pt" width="26">
</td> <td class="xl77" style="width:47pt" width="63">Accuracy</td> <td colspan="3" class="xl76" style="border-right:.5pt solid black; width:78pt" width="102">RBG</td> <td colspan="3" class="xl82" style="border-right:.5pt solid black; border-left:none;width:78pt" width="102">Match</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl76" style="height:14.4pt" height="19">2</td> <td class="xl76">4</td> <td class="xl76">6</td> <td class="xl77">9</td> <td class="xl77">
</td> <td class="xl71">0%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl76">7</td> <td class="xl76">9</td> <td class="xl76">1</td> <td class="xl77">4</td> <td class="xl75">
</td> <td class="xl71">0%</td> <td class="xl76">4</td> <td class="xl76">5</td> <td class="xl77">9</td> <td class="xl78">4</td> <td class="xl78">9</td> <td class="xl79">
</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl76" style="height:14.4pt" height="19">2</td> <td class="xl76">4</td> <td class="xl76">6</td> <td class="xl77">9</td> <td class="xl77">
</td> <td class="xl71">0%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl76">7</td> <td class="xl76">9</td> <td class="xl76">1</td> <td class="xl77">4</td> <td class="xl75">
</td> <td class="xl71">0%</td> <td class="xl76">4</td> <td class="xl76">5</td> <td class="xl77">9</td> <td class="xl78">4</td> <td class="xl78">9</td> <td class="xl79">
</td> </tr> </tbody></table>
 
Upvote 0
MagnumOpus said:
Sorry fellas, I've been working on this all week and apparently my eyes aren't working well today anymore :). Here's a revised example:

<TABLE border=0 cellSpacing=0 cellPadding=0 width=717><COLGROUP><COL style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1365" span=3 width=38><COL style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1365" width=38><COL style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 1080" width=30><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 19pt; mso-width-source: userset; mso-width-alt: 910" width=26><COL style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1365" span=3 width=38><COL style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1365" width=38><COL style="WIDTH: 19pt; mso-width-source: userset; mso-width-alt: 910" width=26><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2247" width=63><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1223" span=2 width=34><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1223" width=34><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1223" span=2 width=34><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1223" width=34></COLGROUP><TBODY><TR style="HEIGHT: 14.4pt" height=19><TD style="WIDTH: 116pt; HEIGHT: 14.4pt" class=xl80 height=19 width=152 colSpan=4>Key Digits</TD><TD style="WIDTH: 23pt" class=xl77 width=30>


</TD><TD style="WIDTH: 48pt" class=xl77 width=64>Accuracy</TD><TD style="BORDER-LEFT: medium none; WIDTH: 19pt" class=xl72 width=26>


</TD><TD style="BORDER-LEFT: medium none; WIDTH: 116pt; BORDER-RIGHT: black 0.5pt solid" class=xl81 width=152 colSpan=4>Key Digit Mirrors</TD><TD style="WIDTH: 19pt" class=xl75 width=26>


</TD><TD style="WIDTH: 47pt" class=xl77 width=63>Accuracy</TD><TD style="WIDTH: 78pt; BORDER-RIGHT: black 0.5pt solid" class=xl76 width=102 colSpan=3>RBG</TD><TD style="BORDER-LEFT: medium none; WIDTH: 78pt; BORDER-RIGHT: black 0.5pt solid" class=xl82 width=102 colSpan=3>Match</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="HEIGHT: 14.4pt" class=xl76 height=19>2</TD><TD class=xl76>4</TD><TD class=xl76>6</TD><TD class=xl77>9</TD><TD class=xl77>


</TD><TD class=xl71>0%</TD><TD style="BORDER-LEFT: medium none" class=xl72>


</TD><TD class=xl76>7</TD><TD class=xl76>9</TD><TD class=xl76>1</TD><TD class=xl77>4</TD><TD class=xl75>


</TD><TD class=xl71>0%</TD><TD class=xl76>4</TD><TD class=xl76>5</TD><TD class=xl77>9</TD><TD class=xl78>4</TD><TD class=xl78>9</TD><TD class=xl79>


</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="HEIGHT: 14.4pt" class=xl76 height=19>2</TD><TD class=xl76>4</TD><TD class=xl76>6</TD><TD class=xl77>9</TD><TD class=xl77>


</TD><TD class=xl71>0%</TD><TD style="BORDER-LEFT: medium none" class=xl72>


</TD><TD class=xl76>7</TD><TD class=xl76>9</TD><TD class=xl76>1</TD><TD class=xl77>4</TD><TD class=xl75>


</TD><TD class=xl71>0%</TD><TD class=xl76>4</TD><TD class=xl76>5</TD><TD class=xl77>9</TD><TD class=xl78>4</TD><TD class=xl78>9</TD><TD class=xl79>


</TD></TR></TBODY></TABLE>
Click to expand...

<TABLE style="WIDTH: 552pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=739><COLGROUP><COL style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 1109" width=31><COL style="WIDTH: 27pt; mso-width-source: userset; mso-width-alt: 1280" span=2 width=36><COL style="WIDTH: 25pt; mso-width-source: userset; mso-width-alt: 1194" width=34><COL style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 824" width=23><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2531" width=71><COL style="WIDTH: 18pt; mso-width-source: userset; mso-width-alt: 853" width=24><COL style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1365" span=2 width=38><COL style="WIDTH: 28pt; mso-width-source: userset; mso-width-alt: 1308" width=37><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1251" width=35><COL style="WIDTH: 22pt; mso-width-source: userset; mso-width-alt: 1052" width=30><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2958" width=83><COL style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1479" width=42><COL style="WIDTH: 28pt; mso-width-source: userset; mso-width-alt: 1336" width=38><COL style="WIDTH: 25pt; mso-width-source: userset; mso-width-alt: 1194" width=34><COL style="WIDTH: 28pt; mso-width-source: userset; mso-width-alt: 1308" width=37><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1223" width=34><COL style="WIDTH: 28pt; mso-width-source: userset; mso-width-alt: 1336" width=38><TBODY><TR style="HEIGHT: 14.4pt; mso-height-source: userset" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 102pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19 width=137 colSpan=4>Key Digits</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 17pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=23> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 53pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=71>Accuracy</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 18pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=24> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 112pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=148 colSpan=4>Key Digit Mirrors</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 22pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=30> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 62pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=83>Accuracy</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 84pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=114 colSpan=3>RBG</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=71 colSpan=2>Match</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 28pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=38> </TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 23pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=19 width=31 align=right>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 27pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=36 align=right>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 27pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=36 align=right>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=34 align=right>9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 17pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=23> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 53pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 width=71 align=right>0%</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 18pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=24> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 29pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=38 align=right>7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 29pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=38 align=right>9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 28pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=37 align=right>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 26pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=35 align=right>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 22pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=30> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 62pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 width=83 align=right>0%</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 31pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=42 align=right>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 28pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=38 align=right>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=34 align=right>9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 28pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=37 align=right>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 26pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=34 align=right>9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67> </TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 23pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=19 width=31 align=right>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 27pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=36 align=right>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 27pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=36 align=right>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=34 align=right>9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 17pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=23> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 53pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 width=71 align=right>0%</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 18pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=24> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 29pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=38 align=right>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 29pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=38 align=right>9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 28pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=37 align=right>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 26pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=35 align=right>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 22pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=30> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 62pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 width=83 align=right>0%</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 31pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=42 align=right>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 28pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=38 align=right>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=34 align=right>9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 28pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=37 align=right>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 26pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=34 align=right>9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67> </TD></TR></TBODY></TABLE>

A1:D3 houses the key digits, the header inclusive.

H1:K3 houses the key digit mirrors, the header inclusive.

N1:P3 houses the RGB digits including the header.

Q1:S3 is the area for the match results, the header included.

Q2, control+shift+enter, not just enter, and copy across then down:
Code: 
=IFERROR(SMALL(IF(ISNUMBER(MATCH(N2:P2,
    IF(ISNUMBER(MATCH(H2:K2,A2:D2,0)),H2:K2,"#"),0)),N2:P2),
      COLUMNS($Q$2:Q2)),"")

Might need a bit more checking...
 
Last edited:
Upvote 0
Wow, that's really close. Only problems are that it's erasing my 4,9 match and replacing it with 9,9 matches, and it's displaying a 0 where it shouldn't be.

The formula now looks like this with the actual cell references.

=IFERROR(SMALL(IF(ISNUMBER(MATCH(AE2:AG2,
IF(ISNUMBER(MATCH(Y2:AB2,R2:U2,0)),Y2:AB2,"#"),0)),AE2:AG2),
COLUMNS($AH$2:AH2)),"")

it's displaying this:

<table width="717" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:1365; width:29pt" width="38" span="3"> <col style="mso-width-source:userset;mso-width-alt:1365;width:29pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:1080;width:23pt" width="30"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:910;width:19pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:1365; width:29pt" width="38" span="3"> <col style="mso-width-source:userset;mso-width-alt:1365;width:29pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:910;width:19pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:2247;width:47pt" width="63"> <col style="mso-width-source:userset;mso-width-alt:1223; width:26pt" width="34" span="2"> <col style="mso-width-source:userset;mso-width-alt:1223;width:26pt" width="34"> <col style="mso-width-source:userset;mso-width-alt:1223; width:26pt" width="34" span="2"> <col style="mso-width-source:userset;mso-width-alt:1223;width:26pt" width="34"> </colgroup><tbody><tr style="height:14.4pt" height="19"> <td colspan="4" class="xl84" style="height:14.4pt;width:116pt" width="152" height="19">Key Digits For The Day</td> <td class="xl81" style="width:23pt" width="30">
</td> <td class="xl81" style="width:48pt" width="64">Accuracy</td> <td class="xl72" style="border-left:none;width:19pt" width="26">
</td> <td colspan="4" class="xl85" style="border-right:.5pt solid black; border-left:none;width:116pt" width="152">Key Digit Mirrors</td> <td class="xl75" style="width:19pt" width="26">
</td> <td class="xl81" style="width:47pt" width="63">Accuracy</td> <td colspan="3" class="xl82" style="border-right:.5pt solid black; width:78pt" width="102">RBG</td> <td colspan="3" class="xl86" style="border-right:.5pt solid black; border-left:none;width:78pt" width="102">Match</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl82" style="height:14.4pt" height="19">2</td> <td class="xl82">5</td> <td class="xl82">6</td> <td class="xl81">9</td> <td class="xl81">
</td> <td class="xl71">100%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl82">7</td> <td class="xl82">0</td> <td class="xl82">1</td> <td class="xl81">4</td> <td class="xl75">
</td> <td class="xl71">0%</td> <td class="xl82" style="font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:#60497B;mso-pattern:black none">4</td> <td class="xl82" style="font-size:11.0pt;color:black;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:red;mso-pattern:black none">5</td> <td class="xl81" style="font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid windowtext; border-bottom:none;border-left:none;background:#7030A0;mso-pattern:black none">9</td> <td class="xl83">
</td> <td class="xl83">
</td> <td class="xl83">
</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl82" style="height:14.4pt" height="19">2</td> <td class="xl82">5</td> <td class="xl82">6</td> <td class="xl81">9</td> <td class="xl81">
</td> <td class="xl71">0%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl82">7</td> <td class="xl82">0</td> <td class="xl82">1</td> <td class="xl81">4</td> <td class="xl75">
</td> <td class="xl71">0%</td> <td class="xl82" style="font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:#60497B;mso-pattern:black none">4</td> <td class="xl82" style="font-size:11.0pt;color:black;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:red;mso-pattern:black none">5</td> <td class="xl81" style="font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid windowtext; border-bottom:none;border-left:none;background:#7030A0;mso-pattern:black none">9</td> <td class="xl83">
</td> <td class="xl83">
</td> <td class="xl83">
</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl82" style="height:14.4pt" height="19">0</td> <td class="xl82">5</td> <td class="xl82">6</td> <td class="xl81">9</td> <td class="xl81">
</td> <td class="xl71">67%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl82">5</td> <td class="xl82">0</td> <td class="xl82">1</td> <td class="xl81">4</td> <td class="xl75">
</td> <td class="xl71">67%</td> <td class="xl82" style="font-size:11.0pt;color:black;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:#FFC000;mso-pattern:black none">8</td> <td class="xl82" style="font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:#7030A0;mso-pattern:black none">9</td> <td class="xl81" style="font-size:11.0pt;color:windowtext;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid windowtext; border-bottom:none;border-left:none;background:#DDD9C3;mso-pattern:black none">
</td> <td class="xl83">0</td> <td class="xl83">
</td> <td class="xl83">
</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl82" style="height:14.4pt" height="19">0</td> <td class="xl82">5</td> <td class="xl82">6</td> <td class="xl81">9</td> <td class="xl81">
</td> <td class="xl71">67%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl82">5</td> <td class="xl82">0</td> <td class="xl82">1</td> <td class="xl81">4</td> <td class="xl75">
</td> <td class="xl71">33%</td> <td class="xl82" style="font-size:11.0pt;color:black;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:#FFC000;mso-pattern:black none">8</td> <td class="xl82" style="font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:#7030A0;mso-pattern:black none">9</td> <td class="xl81" style="font-size:11.0pt;color:windowtext;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid windowtext; border-bottom:none;border-left:none;background:#DDD9C3;mso-pattern:black none">
</td> <td class="xl83">0</td> <td class="xl83">
</td> <td class="xl83">
</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl82" style="height:14.4pt" height="19">2</td> <td class="xl82">5</td> <td class="xl82">6</td> <td class="xl81">9</td> <td class="xl81">
</td> <td class="xl71">33%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl82">7</td> <td class="xl82">0</td> <td class="xl82">1</td> <td class="xl81">4</td> <td class="xl75">
</td> <td class="xl71">33%</td> <td class="xl82" style="font-size:11.0pt;color:black;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:red;mso-pattern:black none">5</td> <td class="xl82" style="font-size:11.0pt;color:black;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:#FFC000;mso-pattern:black none">8</td> <td class="xl81" style="font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid windowtext; border-bottom:none;border-left:none;background:#7030A0;mso-pattern:black none">9</td> <td class="xl83">
</td> <td class="xl83">
</td> <td class="xl83">
</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl82" style="height:14.4pt" height="19">2</td> <td class="xl82">5</td> <td class="xl82">6</td> <td class="xl81">9</td> <td class="xl81">
</td> <td class="xl71">67%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl82">7</td> <td class="xl82">0</td> <td class="xl82">1</td> <td class="xl81">4</td> <td class="xl75">
</td> <td class="xl71">33%</td> <td class="xl82" style="font-size:11.0pt;color:black;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:red;mso-pattern:black none">5</td> <td class="xl82" style="font-size:11.0pt;color:black;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:#FFC000;mso-pattern:black none">8</td> <td class="xl81" style="font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid windowtext; border-bottom:none;border-left:none;background:#7030A0;mso-pattern:black none">9</td> <td class="xl83">
</td> <td class="xl83">
</td> <td class="xl83">
</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl76" style="height:14.4pt" height="19">2</td> <td class="xl76">4</td> <td class="xl76">5</td> <td class="xl77">9</td> <td class="xl77">
</td> <td class="xl79">67%</td> <td class="xl78" style="border-left:none">
</td> <td class="xl76">7</td> <td class="xl76">9</td> <td class="xl76">0</td> <td class="xl77">4</td> <td class="xl80">
</td> <td class="xl79">67%</td> <td class="xl76" style="font-size:11.0pt;color:black;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:#FFC000;mso-pattern:black none">8</td> <td class="xl76" style="font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:#7030A0;mso-pattern:black none">9</td> <td class="xl77" style="font-size:11.0pt;color:windowtext;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid windowtext; border-bottom:none;border-left:none;background:#DDD9C3;mso-pattern:black none">
</td> <td class="xl83">9</td> <td class="xl83">9</td> <td class="xl83">
</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl82" style="height:14.4pt" height="19">2</td> <td class="xl82">4</td> <td class="xl82">5</td> <td class="xl81">9</td> <td class="xl81">
</td> <td class="xl71">33%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl82">7</td> <td class="xl82">9</td> <td class="xl82">0</td> <td class="xl81">4</td> <td class="xl75">
</td> <td class="xl71">33%</td> <td class="xl82" style="font-size:11.0pt;color:black;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:#FFC000;mso-pattern:black none">8</td> <td class="xl82" style="font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:#7030A0;mso-pattern:black none">9</td> <td class="xl81" style="font-size:11.0pt;color:windowtext;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid windowtext; border-bottom:none;border-left:none;background:#DDD9C3;mso-pattern:black none">
</td> <td class="xl83">9</td> <td class="xl83">9</td> <td class="xl83">
</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl82" style="height:14.4pt" height="19">1</td> <td class="xl82">4</td> <td class="xl82">5</td> <td class="xl81">9</td> <td class="xl81">
</td> <td class="xl71">33%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl82">6</td> <td class="xl82">9</td> <td class="xl82">0</td> <td class="xl81">4</td> <td class="xl75">
</td> <td class="xl71">33%</td> <td class="xl82" style="font-size:11.0pt;color:black;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:#FFC000;mso-pattern:black none">8</td> <td class="xl82" style="font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:#7030A0;mso-pattern:black none">9</td> <td class="xl81" style="font-size:11.0pt;color:windowtext;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid windowtext; border-bottom:none;border-left:none;background:#DDD9C3;mso-pattern:black none">
</td> <td class="xl83">9</td> <td class="xl83">9</td> <td class="xl83">
</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl82" style="height:14.4pt" height="19">1</td> <td class="xl82">4</td> <td class="xl82">5</td> <td class="xl81">9</td> <td class="xl81">
</td> <td class="xl71">67%</td> <td class="xl72" style="border-left:none">
</td> <td class="xl82">6</td> <td class="xl82">9</td> <td class="xl82">0</td> <td class="xl81">4</td> <td class="xl75">
</td> <td class="xl71">33%</td> <td class="xl82" style="font-size:11.0pt;color:black;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:#FFC000;mso-pattern:black none">8</td> <td class="xl82" style="font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border:none;background:#7030A0;mso-pattern:black none">9</td> <td class="xl81" style="font-size:11.0pt;color:windowtext;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid windowtext; border-bottom:none;border-left:none;background:#DDD9C3;mso-pattern:black none">
</td> <td class="xl83">9</td> <td class="xl83">9</td> <td class="xl83">
</td> </tr> </tbody></table>
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
619
smozgur
smozgur
M
  • Question Question
Help with FilterXML formula
Replies
0
Views
2K
montex01
M
A
  • Question Question
exel 2002 total accumulated payments
Replies
4
Views
730
anon125
A
T
  • Question Question
VBA to launch userform by selecting a cell
2
Replies
10
Views
2K
Logit
Logit
C
  • Question Question
Sum
Replies
3
Views
1K
pbornemeier
pbornemeier

Forum statistics

Threads
1,224,548
Messages
6,179,445
Members
452,915
Latest member
hannnahheileen

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