Posts by soushinsha • 65 points
6 posts
-
3
votes1
answer62
viewsQ: Excel with Conditional Formula per month
I have this formula in the calculation column in the table: =+(K5+L5)*(1+8%) working! I changed the conditional calculation per month, example:…
-
1
votes1
answer810
viewsA: Search and copy file using Powershell ISE
I found the solution. Warning: If there are files with the same name, the previous one will be overwritten. # Copiaremos os arquivos deste disco $fonte = "D:\" # Colocamos a data e hora nesta…
powershellanswered soushinsha 65 -
0
votes1
answer810
viewsQ: Search and copy file using Powershell ISE
To copy png image files from one disk to another, we use: Copy-Item "D:\" -Filter "*.png" -Destination "F:\Files_PNG" -Recurse -Force Copies the files and the Directories structure. What parameters…
powershellasked soushinsha 65 -
0
votes1
answer414
viewsQ: Increment in String in VBA excel
A Strign in VBA excel has the following value: "T110A17014". I need to increment this string every time. To increase only the last position the code below works! Now if we have this value:…
-
0
votes3
answers173
viewsA: Function =VLOOKUP(MAX($B$5:$B$11);$A$5:$A$11;1;0) Excel 2010
Ola Junior and Denis solved the problem with this formula: =INDEX(A$4:A$11; MATCH(MAX(B5:B11); B$4:B$11; 0)) https://stackoverflow.com/questions/33335845/function-vlookupmaxb5b11a4b1111-excel-2010…
-
2
votes3
answers173
viewsQ: Function =VLOOKUP(MAX($B$5:$B$11);$A$5:$A$11;1;0) Excel 2010
I’m using the function: =VLOOKUP(MAX($B$5:$B$11);$A$5:$A$11;1;0) in cell B23 in Excel 2010. Result: #N/A! Can someone help me fix my formula? Thank you very much, Silvio.…