creating a template

Hello I am creating a template for a database that requires a list of funds per currecny. I need to have each fund repeated multiple times per currency, is there a way to do this without VB or a macro?

Please see the example provided.
Book2.xlsx

Hi Johny,

Try using below formulas for fund and currency respectively:-

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

see attached:- Book2.xlsx


Regards,
DILIPandey
<click on below * if this helps>