Hi,
Can someone please help with the following:
DATE NAME SHARES
08-02-2020 OPP 540
08-02-2020 ABE 265
08-02-2020 STI 145
08-02-2020 ABE 137
08-02-2020 GEN 111
08-02-2020 GEN 108
15-01-2020 OPP 540
15-01-2020 ABE 265
15-01-2020 STI 145
15-01-2020 ABE 137
15-01-2020 PIN 105
22-01-2020 OPP 540
22-01-2020 ABE 137
22-01-2020 STI 145
22-01-2020 ABE 265
22-01-2020 XLZ 123
In the above data I wish to display the top 5 large names on 08-02-2020. I want excel to add up the shares for a name (e.g. ABE) at a given date (e.g. 08-02-2020) and then display the top 5 names. How do I do that without using PIVOT? The sample file is attached as well. Thanks.
Can someone please help with the following:
DATE NAME SHARES
08-02-2020 OPP 540
08-02-2020 ABE 265
08-02-2020 STI 145
08-02-2020 ABE 137
08-02-2020 GEN 111
08-02-2020 GEN 108
15-01-2020 OPP 540
15-01-2020 ABE 265
15-01-2020 STI 145
15-01-2020 ABE 137
15-01-2020 PIN 105
22-01-2020 OPP 540
22-01-2020 ABE 137
22-01-2020 STI 145
22-01-2020 ABE 265
22-01-2020 XLZ 123
In the above data I wish to display the top 5 large names on 08-02-2020. I want excel to add up the shares for a name (e.g. ABE) at a given date (e.g. 08-02-2020) and then display the top 5 names. How do I do that without using PIVOT? The sample file is attached as well. Thanks.