Thank you for your help p45cal, I only changed the month of January, but it will be selected every month, I know that other months gave errors
It could be the Excel 2016 formula, I'll change it to other months later
Good morning
In the Summary % worksheet I need this formula
I need to bring the Income through the month and company selected list validations. Average cover Investment for cell F or cell I depending on the Company and the month
Other information is in Brazilian Portuguese
Holidays are in...
Gentlemen, thank you for your help.
I noticed that it is not possible to move a value by cell address
Thank you for your time to help
Consider this doubt closed
Thank you very much
Décio
I have the calculated address of a cell, with the ADDRESS formula, how do I put a value directly in that cell?
It is possible, only in formula, Version 2016 and 365
Decio
Bosco
That's why I like this forum.
I learn a lot from you, Bosco thank you very much for your dedication and the humility of teaching.
A strong hug
Decio
Bosco, good morning.
It also worked perfectly
Thanks
Peter, Good morning.
I really enjoyed seeing the sequence for the solution of the result
Worked perfectly
Thanks
Decio
Gentlemen, good morning.
I need all accented words from this column to be extracted and copied to another adjacent column as per Template
Important only in formulas.
Thank you very much in advance
Hugs
bosco_yip Good morning.
I hope you're overcoming all this, I'm together thinking positive for your progress and recovery, now you can notice that in this 2021 version no need to type anymore CTRL+SHIFT+ENTER anymore.
A big hugs
Decio
jneiblas
Another way is to format all the cells that you don't want result with zeros with custom formatting
Simple example 0; -0;; @ or not show zeros in the result in hours hh:mm;;""
Decio
John Jairo V
I ask you to attach the model with the formula, so Excel itself will convert the formula.
Example of formula in English VLOOKUP and in Portuguese Brazil automatically translated by Excel is PROCV
So I believe that if you put the model Excel will automatically convert the VSTACK...
p45cal
It worked perfectly for Excel 365 version thanks
I also need for Excel 2016 version I have more than 20 sheets with this version
John Jairo V
In my version of Excel 365 it doesn't have this VSTACK function I'll wait for a soft update but I saved this formula, Thank you
I also need...
Good Morning.
I didn't find a way to do this solution according to the attached spreadsheet
I need it in non-VBA non Power Bi formulas non table.
It can be Excel version 2016 or 365
thank you in advance
Ken U, Good morning. Worked, thank you.
p45cal, Good Morning It worked thank you.
bosco_yip, Good Morning, You are correct some versions do not have this function, your solution also worked thank you very much.
Decio
Gentlemen, good morning.
I can't solve it, I ask for your help, explanation in the model
Remembering I need formula for version of Excel 2016 and also for version 365
Not VBA and not Power BI
thanks in advance
Decio
p45cal
With the template attached, the formula was translated and I loved it because it has a lot of features.
In English ARRAYTOTEXT translated to Portuguese Brazil MATRIZPARATEXTO
Worked perfectly
Thanks