Hi guys,
I have a question regarding how to calculate minimum cost (using MIN function) per category of items.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I'm trying to figure out how to return in Column D the lowest cost (Column C) per each fund (Column A) so that I could filter out all the more expensive funds and only have the data for the least expensive Class of each fund.
Thanks a lot in advance for the help, it will be very appreciated.
Gabriel
I have a question regarding how to calculate minimum cost (using MIN function) per category of items.
Fund Name & Series | =LEFT(A2,20) | COST (% of assets) | =MIN COST PER FUND |
AGF Canadian Money Market Fund MF Series | AGF Canadian Money M | 0.626851 | |
AGF Canadian Money Market Fund MF Series | AGF Canadian Money M | 0.626851 | |
AGF Canadian Money Market Fund MF Series | AGF Canadian Money M | 0.626851 | |
Invesco Canada Money Market Fund Ser A | Invesco Canada Money | 0.700001 | |
Invesco Canada Money Market Fund Ser A | Invesco Canada Money | 0.700001 | |
Invesco Canada Money Market Fund Ser A | Invesco Canada Money | 0.700001 | |
Invesco Canada Money Market Fund Ser A | Invesco Canada Money | 0.700001 | |
National Bank Short Term Canadian Income Fund Inv | National Bank Short | 0.5042 | |
Barreau du Quebec Bond Fund | Barreau du Quebec Bo | 0.784 | |
Scotia T-Bill Fund - Series A | Scotia T-Bill Fund - | 0.48 | |
Scotia Canadian Bond Index Fund Series A | Scotia Canadian Bond | 0.85 | |
Scotia Money Market Fund Series A | Scotia Money Market | 0.76 | |
Scotia Premium T-Bill ($100M - $250M) Series A | Scotia Premium T-Bil | 0.46 | |
Scotia Premium T-Bill ($250M - $1MM) Series A | Scotia Premium T-Bil | 0.46 | |
Scotia Premium T-Bill $>$1MM Series A | Scotia Premium T-Bil | 0.46 | |
BMO Money Market Fund Series A | BMO Money Market Fun | 0.81 | |
BMO Money Market Fund Series A | BMO Money Market Fun | 0.81 | |
CI Money Market Fund Class A | CI Money Market Fund | 0.76 | |
CI Money Market Fund Class A | CI Money Market Fund | 0.76 | |
CI Money Market Fund Class A | CI Money Market Fund | 0.76 | |
CIBC Money Market Fund Class A | CIBC Money Market Fu | 0.65 | |
CIBC Canadian T-Bill Fund Premium Class | CIBC Canadian T-Bill | 0.38 | |
CI Short-Term Corporate Class A | CI Short-Term Corpor | 0.78 | |
CI Short-Term Corporate Class A | CI Short-Term Corpor | 0.78 | |
CI Short-Term Corporate Class A | CI Short-Term Corpor | 0.78 | |
CI Short-Term Corporate Class A | CI Short-Term Corpor | 0.78 | |
Desjardins Money Market Fund A Class | Desjardins Money Mar | 0.68 | |
Manulife Money Fund Advisor Series | Manulife Money Fund | 0.18 | |
Manulife Money Fund Advisor Series | Manulife Money Fund | 0.18 | |
Manulife Money Fund Advisor Series | Manulife Money Fund | 0.18 | |
Manulife Money Fund Advisor Series | Manulife Money Fund | 0.18 | |
Manulife Money Fund Advisor Series | Manulife Money Fund | 0.18 | |
Fidelity Canadian Money Market Fund Series A | Fidelity Canadian Mo | 0.64 | |
Fidelity Canadian Money Market Fund Series A | Fidelity Canadian Mo | 0.64 | |
Fidelity Canadian Money Market Fund Series A | Fidelity Canadian Mo | 0.64 | |
FMOQ Money Market Fund | FMOQ Money Market Fu | 0.4 | |
FDP Cash Management Portfolio Series A | FDP Cash Management | 0.6 | |
Beutel Goodman Income Fund Class D | Beutel Goodman Incom | 0.78 | |
Beutel Goodman Money Market Fund Class D | Beutel Goodman Money | 0.22 | |
United Global Fixed Income Pool Class W | United Global Fixed | 0.2 | |
United Global Fixed Income Pool Class W | United Global Fixed | 0.2 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I'm trying to figure out how to return in Column D the lowest cost (Column C) per each fund (Column A) so that I could filter out all the more expensive funds and only have the data for the least expensive Class of each fund.
Thanks a lot in advance for the help, it will be very appreciated.
Gabriel