Forum Discussion

Alioune Badara DIOUF's avatar
Alioune Badara DIOUF
Copper Contributor
Sep 29, 2017

I use the function, but excel says you can not override 64 imbrication so I would like to replace it with a marco. My problem is In my life I never uses macro.. Even know how to began.. I know nuthing about that.

CARLOS ADRIAN's avatar
CARLOS ADRIAN
Copper Contributor
Oct 02, 2017

Also, going by Sergei Baklan's answer, so you are able to update data faster, I've made it into a table so you only use that reference and copy the table to a hidden sheet. The formula is at right from his.

  • Alioune Badara DIOUF's avatar
    Alioune Badara DIOUF
    Copper Contributor
    Oct 02, 2017

    Thaankk U so Much Carlos Adrian, Im so glad, I add 1  column named "COTATION" to complet my work.

    And thanks for all for your help.

Resources