excel","text":"excel","time":"2016-06-21T14:08:51.129-07:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}},{"__typename":"TagEdge","cursor":"MjUuM3wyLjF8b3wxMHxfTlZffDI","node":{"__typename":"Tag","id":"tag:Macros and VBA","text":"Macros and VBA...
N'entrez pas le {}, mais quittez la formule avec CTRL + SHIFT + ENTRÉE or with VBA Code -ou avec code VBA: 'French VBA Code Sub test()Dim c As Range Dim xgroß As Long Dim ygroß As Long For Each c In Range("A1:A"&Cells(Rows.Count,1).End(xlUp).Row)If Left(c.Va...
Do not enter the {}, but exit the formula with CTRL + SHIFT + ENTER French: =MAX(SI(ESTNUM(CHERCHE("voslettres1";A1:A999;1));STXT(A1:A999;CHERCHE("-";A1:A999;1)+1;99)*1;"")) N'entrez pas le {}, mais quittez la formule avec CTRL + SHIFT + ENTRÉE or with VBA Code...
N'entrez pas le {}, mais quittez la formule avec CTRL + SHIFT + ENTRÉE or with VBA Code -ou avec code VBA:
That's VBA function installed with some add-in or like. Perhaps here Fonction Excel : SOMME_SI_COULEUR (excel-pratique.com) you may find more details how to install it. Sorry, don't understand French.","kudosSumWeight":0,"repliesCount":2,"postTime":"2021-01-06T04:06:46.403-08:00"...