Hi, I dn't have Outloo installed to test it so I do not know what errors you get I did modify this code and maybe it can help you Publi...
My idea would be to add a column counting the number of highs, and two columns with the year and the month then see what that gives you, Another an...
Hi, I'm using 2021 and I suppose ArcPro is some kind of compression and decompression like winzip. If you look inside the files in Excel they're AL...
Well, now that you actually attached the file it's there. But, do you want to do this with formulas or macros?
Which Excel version?
Hola, curioso por saber. Lo solucionaste o ya no tienes más interés
I'll download the file and see if I can help
Hola Orlando, De esta manera no vas a recibir ninguna ayuda, la macro aparte de que es un cáos solo indica lo que quieres hacer pero no da ninguna ...
You're explanation is probably clear for you but try to read it as someone that does not know what you're doing and then see for yourself if you under...
And the file will also not work if there are unresolved references because it points either to a renamed file of an entire different file. When pos...
Salim, I also suggest you tell us which version of Office (Excel) you're using
Like I mentioned thereá a link in your formula which I cannot reach or workout. No go this way =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBO...
This is done without VBA but will only work with 365 or 2021
Hi, which version of Excel are you using? How's your VBA knwoledge?
I've downloaded the file there are formula refernece errors so I'll see if I can figure out what you want to achieve.