Posts by tsachetto • 11 points
9 posts
-
0
votes2
answers374
viewsA: SUMS with reference within the array
Oops, try it like: =SOMASES(A:A;B:B;G1)+SOMASES(A:A;B:B;G2) which would be more or less: =SOMASES(A:A;B:B;"carro")+SOMASES(A:A;B:B;"bicicleta")
-
0
votes1
answer179
viewsQ: Export Postgre SQL table to text (csv) via psycopg2
I am trying to export a table from the Postgres database to a txt (csv) file via Python, via psycopg2. However, I am encountering an error. The code is as follows (I switched login information to…
-
0
votes2
answers47
viewsA: How to Filter specific values with Excel and add them in another table?
Hey, try it like this: In the cell: J3 Enter the formula: =SE(CONT.SE(F:F;"A")-LIN()+3>0;"A";"") Then drag down and sideways at will!
-
0
votes1
answer1307
viewsA: VBA, create a macro so that I can compare two lists of names?
Hello, in that case I could try the following code, but it does not repair the mess. And if you need to adjust something, let me know! ALTERED: Sub Organizar() Dim aw As String Dim ln As Long aw =…
-
-1
votes1
answer424
views -
0
votes1
answer1214
viewsA: How to display the number of rows in the left sidebar of the VBA Excel?
Unfortunately the Excel VBA editor does not have this native option on the system. You would have to look for alternative Addons capable of filling that gap, such as:…
-
0
votes1
answer474
viewsA: How to use Err.Clear correctly
Hello, try the following command to "reset" the errors at the beginning of the loop: On Error GoTo -1 Abs!
-
0
votes1
answer405
viewsA: Get User name from an Excel login
Hey, that depends on. From what I understand, you log in to a cell, but want the next logins to be stored, for example, in the cells below, without risk of overlapping from the previous login.…
-
1
votes1
answer1532
viewsA: VBA - Copy and paste data without column sequence to rows
Hello, under these specific circumstances that you reported, try to insert a new module in the VBA edition, paste the code below and go to the tab that you want the result and run it: Sub getdata()…