Formula for Comparisons and Subtraction

Glasgowsmile

Board Regular
Joined
Apr 14, 2018
Messages
141
Good Morning,

I've posted a photo so you can see what I'm doing but basically...

I want to compare two columns and then subtract the numbers next to them if they match.

I want to compare column K and column N, find the matches and then subtract column L from column O to paste into column Q.

https://imgur.com/kwG55fr

 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

AlanY

Well-known Member
Joined
Oct 30, 2014
Messages
4,146
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
may be

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Comparison</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">A</td><td style="text-align: right;;">12</td><td style="text-align: right;;"></td><td style=";">B</td><td style="text-align: right;;">6</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">10</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">B</td><td style="text-align: right;;">10</td><td style="text-align: right;;"></td><td style=";">D</td><td style="text-align: right;;">4</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">4</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style=";">C</td><td style="text-align: right;;">5</td><td style="text-align: right;;"></td><td style=";">C</td><td style="text-align: right;;">8</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">-3</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style=";">D</td><td style="text-align: right;;">9</td><td style="text-align: right;;"></td><td style=";">A</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">5</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">E</td><td style="text-align: right;;">8</td><td style="text-align: right;;"></td><td style=";">E</td><td style="text-align: right;;">5</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">3</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style=";">F</td><td style="text-align: right;;">7</td><td style="text-align: right;;"></td><td style=";">F</td><td style="text-align: right;;">1</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">6</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style=";">G</td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style=";">H</td><td style="text-align: right;;">1</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">0</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style=";">H</td><td style="text-align: right;;">6</td><td style="text-align: right;;"></td><td style=";">I</td><td style="text-align: right;;">7</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">5</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style=";">I</td><td style="text-align: right;;">5</td><td style="text-align: right;;"></td><td style=";">G</td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">-2</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet2</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">Q2</th><td style="text-align:left">=L2-INDEX(<font color="Blue">$O$2:$O$10,MATCH(<font color="Red">K2,$N$2:$N$10,0</font>)</font>)</td></tr></tbody></table></td></tr></table><br />
 

Glasgowsmile

Board Regular
Joined
Apr 14, 2018
Messages
141
This is great, how could I expand this if I increase the data set?

For example, let's say K:L are Week 1, N:O are Week 2. What if I wanted to add a Week 3 / 4 and it compares across all 4 weeks what the changes are?
 

AlanY

Well-known Member
Joined
Oct 30, 2014
Messages
4,146
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
it's basically just copy the formula across

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th><th>S</th><th>T</th><th>U</th><th>V</th><th>W</th><th>X</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Comparison</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">Wk1</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Wk2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Wk3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Wk4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Wk1 > Wk2</td><td style=";">Wk2 > Wk3</td><td style=";">Wk3 > Wk4</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">A</td><td style="text-align: right;;">12</td><td style="text-align: right;;"></td><td style=";">B</td><td style="text-align: right;;">6</td><td style="text-align: right;;"></td><td style=";">A</td><td style="text-align: right;;">6</td><td style="text-align: right;;"></td><td style=";">B</td><td style="text-align: right;;">11</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">10</td><td style="text-align: right;background-color: #E2EFDA;;">-4</td><td style="text-align: right;background-color: #E2EFDA;;">5</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style=";">B</td><td style="text-align: right;;">10</td><td style="text-align: right;;"></td><td style=";">D</td><td style="text-align: right;;">4</td><td style="text-align: right;;"></td><td style=";">B</td><td style="text-align: right;;">1</td><td style="text-align: right;;"></td><td style=";">D</td><td style="text-align: right;;">11</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">4</td><td style="text-align: right;background-color: #E2EFDA;;">5</td><td style="text-align: right;background-color: #E2EFDA;;">-10</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style=";">C</td><td style="text-align: right;;">5</td><td style="text-align: right;;"></td><td style=";">C</td><td style="text-align: right;;">8</td><td style="text-align: right;;"></td><td style=";">C</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style=";">C</td><td style="text-align: right;;">5</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">-3</td><td style="text-align: right;background-color: #E2EFDA;;">6</td><td style="text-align: right;background-color: #E2EFDA;;">-3</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">D</td><td style="text-align: right;;">9</td><td style="text-align: right;;"></td><td style=";">A</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style=";">D</td><td style="text-align: right;;">9</td><td style="text-align: right;;"></td><td style=";">A</td><td style="text-align: right;;">1</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">5</td><td style="text-align: right;background-color: #E2EFDA;;">-5</td><td style="text-align: right;background-color: #E2EFDA;;">-2</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style=";">E</td><td style="text-align: right;;">8</td><td style="text-align: right;;"></td><td style=";">E</td><td style="text-align: right;;">5</td><td style="text-align: right;;"></td><td style=";">E</td><td style="text-align: right;;">6</td><td style="text-align: right;;"></td><td style=";">E</td><td style="text-align: right;;">1</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">3</td><td style="text-align: right;background-color: #E2EFDA;;">-1</td><td style="text-align: right;background-color: #E2EFDA;;">5</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style=";">F</td><td style="text-align: right;;">7</td><td style="text-align: right;;"></td><td style=";">F</td><td style="text-align: right;;">1</td><td style="text-align: right;;"></td><td style=";">F</td><td style="text-align: right;;">9</td><td style="text-align: right;;"></td><td style=";">F</td><td style="text-align: right;;">11</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">6</td><td style="text-align: right;background-color: #E2EFDA;;">-8</td><td style="text-align: right;background-color: #E2EFDA;;">-2</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style=";">G</td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style=";">H</td><td style="text-align: right;;">1</td><td style="text-align: right;;"></td><td style=";">G</td><td style="text-align: right;;">10</td><td style="text-align: right;;"></td><td style=";">H</td><td style="text-align: right;;">1</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">0</td><td style="text-align: right;background-color: #E2EFDA;;">-7</td><td style="text-align: right;background-color: #E2EFDA;;">7</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style=";">H</td><td style="text-align: right;;">6</td><td style="text-align: right;;"></td><td style=";">I</td><td style="text-align: right;;">7</td><td style="text-align: right;;"></td><td style=";">H</td><td style="text-align: right;;">12</td><td style="text-align: right;;"></td><td style=";">I</td><td style="text-align: right;;">10</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">5</td><td style="text-align: right;background-color: #E2EFDA;;">-11</td><td style="text-align: right;background-color: #E2EFDA;;">11</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style=";">I</td><td style="text-align: right;;">5</td><td style="text-align: right;;"></td><td style=";">G</td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style=";">I</td><td style="text-align: right;;">4</td><td style="text-align: right;;"></td><td style=";">G</td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">-2</td><td style="text-align: right;background-color: #E2EFDA;;">3</td><td style="text-align: right;background-color: #E2EFDA;;">-6</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">V3</th><td style="text-align:left">=INDEX(<font color="Blue">$K$3:$K$11,MATCH(<font color="Red">$J3,$J$3:$J$11,0</font>)</font>)-INDEX(<font color="Blue">$N$3:$N$11,MATCH(<font color="Red">$J3,$M$3:$M$11,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">W3</th><td style="text-align:left">=INDEX(<font color="Blue">$N$3:$N$11,MATCH(<font color="Red">$J3,$M$3:$M$11,0</font>)</font>)-INDEX(<font color="Blue">$Q$3:$Q$11,MATCH(<font color="Red">$J3,$P$3:$P$11,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">X3</th><td style="text-align:left">=INDEX(<font color="Blue">$Q$3:$Q$11,MATCH(<font color="Red">$J3,$P$3:$P$11,0</font>)</font>)-INDEX(<font color="Blue">$T$3:$T$11,MATCH(<font color="Red">$J3,$S$3:$S$11,0</font>)</font>)</td></tr></tbody></table></td></tr></table><br />
 

Glasgowsmile

Board Regular
Joined
Apr 14, 2018
Messages
141

ADVERTISEMENT

Not quite what I had in mind, what if I wanted a column that was Week 1 vs Week 2 Comparison and then another Column that compared Week 1 to Week 2 & 3, and then a 3rd that compared Week 1 to 2, 3, & 4?
 

AlanY

Well-known Member
Joined
Oct 30, 2014
Messages
4,146
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
Not quite what I had in mind, what if I wanted a column that was Week 1 vs Week 2 Comparison and then another Column that compared Week 1 to Week 2 & 3, and then a 3rd that compared Week 1 to 2, 3, & 4?

say for A

Wk1 10
Wk2 9
Wk3 8
Wk4 7

what results are you expected for compared Week 1 to Week 2 & 3, and
Week 1 to 2, 3, & 4 ?
 

Glasgowsmile

Board Regular
Joined
Apr 14, 2018
Messages
141
For example for A, I'm trying to see how A has grown or declined over the last 3 weeks compared to week 1 - so I want to compared week 1 against all other weeks to pull A-G, in this example, so I can see how it stacks up over time.
 

AlanY

Well-known Member
Joined
Oct 30, 2014
Messages
4,146
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
ok, have a look of this

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th><th>S</th><th>T</th><th>U</th><th>V</th><th>W</th><th>X</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Comparison</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">Wk1</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Wk2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Wk3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Wk4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Wk2</td><td style=";">Wk3</td><td style=";">Wk4</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">A</td><td style="text-align: right;;">12</td><td style="text-align: right;;"></td><td style=";">B</td><td style="text-align: right;;">6</td><td style="text-align: right;;"></td><td style=";">A</td><td style="text-align: right;;">6</td><td style="text-align: right;;"></td><td style=";">B</td><td style="text-align: right;;">11</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">10</td><td style="text-align: right;background-color: #E2EFDA;;">6</td><td style="text-align: right;background-color: #E2EFDA;;">11</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style=";">B</td><td style="text-align: right;;">10</td><td style="text-align: right;;"></td><td style=";">D</td><td style="text-align: right;;">4</td><td style="text-align: right;;"></td><td style=";">B</td><td style="text-align: right;;">1</td><td style="text-align: right;;"></td><td style=";">D</td><td style="text-align: right;;">11</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">4</td><td style="text-align: right;background-color: #E2EFDA;;">9</td><td style="text-align: right;background-color: #E2EFDA;;">-1</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style=";">C</td><td style="text-align: right;;">5</td><td style="text-align: right;;"></td><td style=";">C</td><td style="text-align: right;;">8</td><td style="text-align: right;;"></td><td style=";">C</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style=";">C</td><td style="text-align: right;;">5</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">-3</td><td style="text-align: right;background-color: #E2EFDA;;">3</td><td style="text-align: right;background-color: #E2EFDA;;">0</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">D</td><td style="text-align: right;;">9</td><td style="text-align: right;;"></td><td style=";">A</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style=";">D</td><td style="text-align: right;;">9</td><td style="text-align: right;;"></td><td style=";">A</td><td style="text-align: right;;">1</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">5</td><td style="text-align: right;background-color: #E2EFDA;;">0</td><td style="text-align: right;background-color: #E2EFDA;;">-2</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style=";">E</td><td style="text-align: right;;">8</td><td style="text-align: right;;"></td><td style=";">E</td><td style="text-align: right;;">5</td><td style="text-align: right;;"></td><td style=";">E</td><td style="text-align: right;;">6</td><td style="text-align: right;;"></td><td style=";">E</td><td style="text-align: right;;">1</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">3</td><td style="text-align: right;background-color: #E2EFDA;;">2</td><td style="text-align: right;background-color: #E2EFDA;;">7</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style=";">F</td><td style="text-align: right;;">7</td><td style="text-align: right;;"></td><td style=";">F</td><td style="text-align: right;;">1</td><td style="text-align: right;;"></td><td style=";">F</td><td style="text-align: right;;">9</td><td style="text-align: right;;"></td><td style=";">F</td><td style="text-align: right;;">11</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">6</td><td style="text-align: right;background-color: #E2EFDA;;">-2</td><td style="text-align: right;background-color: #E2EFDA;;">-4</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style=";">G</td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style=";">H</td><td style="text-align: right;;">1</td><td style="text-align: right;;"></td><td style=";">G</td><td style="text-align: right;;">10</td><td style="text-align: right;;"></td><td style=";">H</td><td style="text-align: right;;">1</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">0</td><td style="text-align: right;background-color: #E2EFDA;;">-7</td><td style="text-align: right;background-color: #E2EFDA;;">0</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style=";">H</td><td style="text-align: right;;">6</td><td style="text-align: right;;"></td><td style=";">I</td><td style="text-align: right;;">7</td><td style="text-align: right;;"></td><td style=";">H</td><td style="text-align: right;;">12</td><td style="text-align: right;;"></td><td style=";">I</td><td style="text-align: right;;">10</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">5</td><td style="text-align: right;background-color: #E2EFDA;;">-6</td><td style="text-align: right;background-color: #E2EFDA;;">5</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style=";">I</td><td style="text-align: right;;">5</td><td style="text-align: right;;"></td><td style=";">G</td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style=";">I</td><td style="text-align: right;;">4</td><td style="text-align: right;;"></td><td style=";">G</td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">-2</td><td style="text-align: right;background-color: #E2EFDA;;">1</td><td style="text-align: right;background-color: #E2EFDA;;">-5</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">V3</th><td style="text-align:left">=INDEX(<font color="Blue">$K$3:$K$11,MATCH(<font color="Red">$J3,$J$3:$J$11,0</font>)</font>)-INDEX(<font color="Blue">$N$3:$N$11,MATCH(<font color="Red">$J3,$M$3:$M$11,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">W3</th><td style="text-align:left">=INDEX(<font color="Blue">$K$3:$K$11,MATCH(<font color="Red">$J3,$J$3:$J$11,0</font>)</font>)-INDEX(<font color="Blue">$Q$3:$Q$11,MATCH(<font color="Red">$J3,$P$3:$P$11,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">X3</th><td style="text-align:left">=INDEX(<font color="Blue">$K$3:$K$11,MATCH(<font color="Red">$J3,$J$3:$J$11,0</font>)</font>)-INDEX(<font color="Blue">$T$3:$T$11,MATCH(<font color="Red">$J3,$S$3:$S$11,0</font>)</font>)</td></tr></tbody></table></td></tr></table><br />
 

Watch MrExcel Video

Forum statistics

Threads
1,108,492
Messages
5,523,260
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top