Posts by PedroMVM • 293 points
6 posts
-
1
votes2
answers87
viewsA: I have this query and I’m not able to group by month
You didn’t put the columns year and month in the SELECT. To use the clause GROUP BY it is necessary that the columns that will be aggregated are in the SELECT.…
-
0
votes2
answers3002
viewsA: How to assign the formula of cell D2 to a variable?
To get the cell value A2 use Range("A2").Value. You can replace your text ** A2 ** therefore, but do not forget to put the & before the ".png".…
-
0
votes2
answers68
viewsA: Conditions if nested
You need to match the function SE with the function E. The function SE has the following format: SE(condição;resultado se verdadeiro;resultado se falso) Already the function E has the format:…
-
2
votes4
answers7295
viewsA: How to generate a spreadsheet from another using VBA
I did the code below following the good programming practices, using more appropriate variable names with their use, and not using ActiveCell, Offset and other things like that. I hope you prefer it…
-
1
votes1
answer1590
viewsA: Open another instance of Excel while VBA runs
Yes, you can open another instance. Use Windows Run (Win + R key) and type Excel -x.
-
2
votes1
answer46
viewsA: SQL Search - Results not duplicated
You need to use the clause DISTINCTwith the column you want the single die: select DISTINCT(user_id) from wps_history where inserted between "2016-11-01 00:00:00" AND "2016-11-30 23:59:59"…