My goal is to add up the Short Volume for each stock, based on the same Stock Symbol and same date. Some stocks show on both lists, some don't. Some dates match on each list, some don't.
I have tried using vlookup, as well as Index/Match, but I get confused because I am unfamiliar with dealing with multiple criteria. (Note I am using Excel 2016. Also, I don't seem to know how to copy an excel worksheet, except Copy & Paste... is there a more proper way on this website?)
<tbody>
</tbody>
I have tried using vlookup, as well as Index/Match, but I get confused because I am unfamiliar with dealing with multiple criteria. (Note I am using Excel 2016. Also, I don't seem to know how to copy an excel worksheet, except Copy & Paste... is there a more proper way on this website?)
Date | Stock Symbol (List 1) | Short Volume | Date | Stock Symbol (List 2) | Short Volume | Unique Symbols from both lists | Total Short Volume 8/1/2017 | Total Short Volume 8/2/2017 | Total Short Volume 8/3/2017 | ||
08/01/17 | A | 66,333 | 08/01/17 | A | 122 | A | 66,455 | 92,258 | 0 | ||
08/02/17 | A | 92,258 | 08/03/17 | A | 28 | B | 0 | 426,004 | 0 | ||
09/13/17 | A | 92,530 | 08/24/17 | A | 2,900 | C | 0 | 0 | 0 | ||
09/14/17 | A | 58,635 | 08/25/17 | A | 161 | D | 0 | 230,824 | 69,742 | ||
11/09/17 | A | 35,674 | 08/28/17 | A | 857 | ||||||
11/10/17 | A | 60,920 | 08/29/17 | A | 482 | ||||||
08/02/17 | B | 426,004 | 08/30/17 | A | 1,964 | ^^^^^ | |||||
08/03/17 | B | 194,379 | 08/31/17 | A | 1,654 | Note: In above table, I have a "0", when there is | |||||
08/04/17 | B | 246,117 | 09/01/17 | A | 1,164 | no data available from column on the left. | |||||
08/07/17 | B | 602,109 | 09/05/17 | A | 678 | ||||||
08/08/17 | B | 965,440 | 11/02/17 | A | 638 | ||||||
08/09/17 | B | 433,013 | 11/03/17 | A | 426 | ||||||
08/10/17 | B | 16,713 | 08/08/17 | B | 56,600 | ||||||
08/11/17 | B | 9,721 | 08/09/17 | B | 59,568 | ||||||
09/12/17 | B | 28,125 | 09/06/17 | C | 454,004 | ||||||
09/13/17 | B | 40,076 | 09/07/17 | C | 541,540 | ||||||
09/14/17 | B | 36,849 | 09/08/17 | C | 124,652 | ||||||
09/15/17 | B | 33,945 | 09/11/17 | C | 245,004 | ||||||
08/02/17 | D | 115,412 | 09/12/17 | C | 54,693 | ||||||
08/03/17 | D | 34,871 | 09/13/17 | C | 567,410 | ||||||
08/08/17 | D | 24,654 | 08/02/17 | D | 115,412 | ||||||
08/09/17 | D | 65,188 | 08/03/17 | D | 34,871 | ||||||
08/22/17 | D | 27,401 | |||||||||
08/23/17 | D | 243,200 | |||||||||
08/25/17 | D | 546,358 |
<tbody>
</tbody>
Last edited: