Algeria Modern Excel and Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

Nous sommes aussi sur LinkedIn, AMEPBIUG

Latest Discussion Posts

  • salam alikoum oustad mehdi , I modified the formula you send me( in case there is no number in the names), and I come up with another one using IFERROR the cool thing is with file timing formulas to see the fastest one : yours (=LEFT(J5;MIN(IF(ISNUMBER(FIND({0;1;2;3;4;5;6;7;8;9};J5));FIND({0;1;2;3;4;5;6;7;8;9};J5)))-2) ...

  • yes! great one, with some theory five stars oustade ------------------------------ Abdelkader Gharbi ACCOUNTANT +213558893019 ------------------------------

  • Salam  @Abdelkader Gharbi , First of all, if ealy there is no clear pattern you cannot Apply an Excel formula because if you want to write a formula you need to set assumptions based on a pattern on which you think your data can be processed. So to find ...

    1 person recommends this.
  • salam alikoum  I send this file, a formula for text without a clear pattern if someone has a better solution (with a formula not power query neither flash fill ) let me know ------------------------------ Abdelkader Gharbi ACCOUNTANT +213558893019 - ...

  • Profile Picture

    RE: Map

    Great, waiting for your conclusiion ------------------------------ Regards Mehdi HAMMADI CoGitar / 23389830 mehdi.hammadi@cogitar.com ------------------------------

Announcements

  • Bienvenu

    Le groupe d'usagés "Algeria Modern Excel and Power BI" a pour vocation de rassembler des utilisateurs, principalement Algériens ou résident en Algérie, passionnés d'Excel et de Power BI afin qu'ils partagent, apprennent et développent leurs compétences et leurs opportunités. Que vous soyez novice dans le monde de l'analyse ou expert en analyse et visualisation de données, que vous soyez d'Algérie ou d'ailleurs, cette communauté est pour vous.

    Bookmark www.pbiusergroup.com/algeria pour un accès rapide à notre groupe.

    Chef local:
    @Mehdi HAMMADI

Volunteer Opportunities

Details

  There are no volunteer opportunities at this time! Check back later!

Current Members
23 Members
user group Admin
user group Leadership
Group Leader
user group Admin
user group Admin
user group Admin
user group Admin
user group Admin