Most voted "excel" questions
Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X that allows advanced use of mathematical formulas and functions and statistics. For questions about programming in VBA Excel, also use the excel-vba tag. Note that non-programming issues are within the scope of the Stack Overflow, for example those involving the basic use of the tool.
Learn more…1,117 questions
Sort by count of
-
1
votes1
answer188
viewsRename worksheet tab
I’m having trouble renaming an Excell file tab. I’m debugging and after it gives the set the new name.. i can see the new name changed in the execution but in practice the file itself is not…
-
1
votes0
answers95
viewsExcel how to compare 4 equal criteria in a table
I have a table of player characteristics. I need a formula that checks [TRUTH/FALSE] if all characteristics were repeated The table is contained in the following interval: $R$3:$X$2004 The range of…
excelasked 6 years, 3 months ago Silvio Sampaio 13 -
1
votes0
answers63
viewsWhat formula do I use Excel for product input and output?
I have a small table, where the 'QTD_E' = Input and 'QTD_S' = Output, for each withdrawal of the quantity of product in the 'QTD_E' I wanted to add how many products were removed in the 'QTD_S',…
excelasked 6 years, 3 months ago Elienay Junior 527 -
1
votes0
answers30
viewspaint cell through an "ok" in another cell
Good morning, I don’t know if you can understand my reasoning, but come on..... I have a cell that has names example: SABRINA (A1), I need to put OK in the cell (B1), and after putting the "OK", I…
-
1
votes0
answers99
viewsPopup Preventing Macro from Advancing
I have a macro that enters a particular site, fills in a form, and sends a save for the system, generates a request. After that, a popup is issued with a button "OK". This ok has a eventClick that…
-
1
votes1
answer79
viewsHow can I merge the rest of the data with the first query in SQL
Personal I have a query in SQL that returns the values not duplicated column: Nº Tel, and that has the Status equal to TEMPORARY MALFUNCTION SELECT DISTINCT [Nº Tel] FROM [export$] WHERE [Status] =…
-
1
votes2
answers111
viewsExcel function recognizes "" as 0
I’m doing a very simple function in Excel, but I’m having problems, because it is recognizing "" as 0, follows the function: =SE(E4=0;"0x0";"") The problem is that it is returning "0x0" when I leave…
excelasked 6 years, 1 month ago Fernando Fragoso 35 -
1
votes1
answer44
viewsSkip digits when running
I have a problem, I took right here a script to enter the ninth digit if the phone starts with 6,7,8,9.. Function ValidarCelular(Myrange As Range) As String On Error GoTo ErrHandler: Dim regEx As…
-
1
votes1
answer75
viewsFunction to pick a row from an Excel table and slice
You can take a row from the table and divide it into as many pieces as you want? I can take cell by cell from the table using an approach I learned here on the forum in an already answered question,…
-
1
votes1
answer535
viewsImport xls file to R
The data can be obtained by Link <- https://github.com/marcosvafg/salario_juizes But precisely the file name is Salarios_juizes_tjsp_122017. The file is protected, so I can’t change it. I wanted…
-
1
votes1
answer279
viewsHow to update a website page after changing the value of a field by VBA
Good night. I wonder how I can update the page with the date I informed by VBA. I put the date but the page does not change. Since there’s no button, I don’t know what to do. Sub Links() Dim ie As…
-
1
votes1
answer42
viewsError #VALUE! when using IF operation
I have this table in Excel and in column E I have the following expression:=IF(AND(SEARCH("qwe*";B:B);SEARCH("qaz";C:C));TRUE;FALSE) I don’t understand why I should appear FALSE error #VALUE!.…
excelasked 6 years, 11 months ago msm.oliveira 642 -
1
votes2
answers374
viewsSUMS with reference within the array
I would like to use the following formula:: =SUM(SUMS(A:A;B:B;{"car";"bicycle"})) It turns out that I do not want to leave the criteria "car" and "bike" fixed, I would like to put in there a…
-
1
votes1
answer1025
viewsHow to Load a listview with more than 30 columns?
I’m trying to carry a ListView with more than thirty columns using the following code: With ListV_P Sheets("BANCO").Select Dim UltimaLinha As Variant Dim Linha As String '.GetFirstVisible = True…
-
1
votes0
answers76
viewsDoubts in excel
I’m creating a macro where you send emails, but I’m stuck in a process. I wonder if it is possible to create a column where I select a reason for pending, for example "lack of rg" that when…
-
1
votes1
answer160
viewsShow diluted value according to the last day of the month! Excel
[Example][1] [1]: http://prntscr.com/jsd694 1 - investment by the client; 2 - commencement of contract; 3 - duration of contract; 4 - rate of return for each customer; 5 - whether the customer has…
-
1
votes0
answers67
viewsExcel VBA on MAC
Good night! I use a lot of Excel VBA on a PC computer. The VBA used in Excel for MAC is the same?
-
1
votes1
answer1233
viewsExcel: load list of names according to the selection of another list
in the school I work has a file with the class spreadsheets (the name of the spreadsheet is the class number. Ex: 100, 200, ...). I need to make a spreadsheet in this same file to generate…
-
1
votes1
answer497
viewsExcel and SQL - Connection between Excel file
I have the code on (end) that I picked up on the internet. This line of code gives error in WHERE, because it is a text: strSQL = " SELECT [VENDAS$].[Data], [VENDAS$].[Vendedor], [VENDAS$].[Total]"…
-
1
votes2
answers261
viewsDoubt about Excel, how to block columns?
Hello I would like to know if there is an option in Excel, which to block certain columns so that only columns are available that are always edited... Example: I have this column selected, and I…
excelasked 5 years, 11 months ago Lucas pereira 171 -
1
votes1
answer254
viewsTake text from excel cell
I have an application that reads Excel data, but I can only read the value of the cell and I can’t read what the cell is literally showing. For example: Here I select where the spreadsheet is and…
-
1
votes1
answer72
viewsSE function with 3 final values
---Rephrasing the question--- A formula expressing the following information: -When Column I and J is written "Letter N" will return in column C the writing "PSI" -When Column K and L is written…
-
1
votes1
answer103
viewsPopular Excel with Java object
Hi, I’m having a problem to popular a table the way I need, I want to do something like this. But with my code I can only get people like this. How do I format the same way? I tried to skip the…
-
1
votes1
answer845
viewsError when exporting Excel using Maatwebsite / Laravel-Excel
The excel export works well up to 10000 records but above that it returns me the error: "127.0.0.1 is Currently Unable to Handle this request. HTTP ERROR 500" Someone’s had that problem before?…
-
1
votes1
answer3335
viewsRead multiple sets xlsx file with PHP - Phpspreadsheet
I have a file in xlsx format with two spreadsheets and I need to read the data in PHP to create an import script in the database. I’m using the Phpspreadsheet library to read the files. I can do…
-
1
votes1
answer2238
viewsVBA - Delete only last row of table containing text
I’m having a very specific question. I hope you can help me I have a spreadsheet that contains a table called "Activities". I have some form controls to fill the same but I emerged the need to…
-
1
votes1
answer193
viewsChanging the name of a data set field - Powerbi
Hello I have a data set (Excel) that was loaded in Powerbi. When I change the name of a column/field in Excel Powerbi does not actualize the data because it does not recognize the name of the column…
-
1
votes1
answer98
viewsGenerating an xlsx file from a Gridview that is powered by a Database
Good afternoon, I am facing a problem when it comes to generating an Excel file, I was able to make the information appear in Excel and be shown on the screen, but found me with doubt when I try to…
-
1
votes2
answers3166
viewsVBA - Read a file. TXT and manipulate its lines
I’m trying to make a Query generator using Excel (VBA), but I’m not able to manipulate some data inside a file . sql. Ex.: Select * From Tabela t Where t.id = 1 <PROP> Every time he finds a…
-
1
votes0
answers37
viewsHow can I automate a dowload of an excel file on the web?
Hello guys I’m having a problem, I wanted to automate a routine would download an Excel file on a certain site, if possible using Python or java, I wonder if there is already a program/code that…
-
1
votes1
answer279
views -
1
votes0
answers294
viewsRecover last entered value in a specific column of Excel VBA
I need to retrieve the last entered value in a specific cell of the worksheet, for example: coluna ID 1 2 3 4 ... 2550 I need to get the value of ID (2550) to be able to increase and execute other…
-
1
votes1
answer849
viewsHow to "clean" a csv file with Python?
Hello! I’m extremely new to programming, so I apologize if I can’t explain what I’m trying to do or if my code is really wrong. I have a recurring task in my job which is to open a list of…
-
1
votes0
answers165
viewsProblems with Excel file generation (.xlsx) with Phpspreadsheet library
I am working on a project where I need to generate Excel files with database information (reports). I managed to do this with the Phpspreadsheet library, but the file is saved to the server, and…
-
1
votes0
answers27
views -
1
votes2
answers57
viewsCondition Se in Excel
I’m trying to create a condition in excel where if the text in a sheet is = yes then does an action, I tried to do so but says it’s a circular reference. =SE('Dados do paciente'!N3="Sim";0;…
excelasked 4 years, 8 months ago Ricardo Martins 23 -
1
votes1
answer388
viewsHow to increase upload size in php?
Good morning, I need to upload a csv file that is larger than the standard php that is 2M (the file is around 10 to 15M) The application works perfectly for files smaller than 2MB. I’ve tried in…
-
1
votes1
answer41
viewsVBA formulas with @
When you write the formula of a function by VBA, and add some excel formula, it increments a @ before the formula automatically. For example: Selection = "=SOMA(A1)" In the spreadsheet formula bar…
-
1
votes2
answers118
viewsHow to improve the performance of an xls file generator in my Delphi 4 + SQL Server 2000 application?
I implemented the following procedure in an application made in Delphi 4, but the time to generate an xls file with Dataset data is 55 seconds and the dataset has approximately 50 lines. Any tips on…
-
1
votes1
answer1097
viewsError pasting data in Excel with VBS
I have a simple spreadsheet in Excel(3 cols and 2 lines) and am trying to create a script to open it, copy your data and insert them into other spreadsheet with the same structure using a form.…
-
1
votes0
answers57
viewsCount value in an Excel dynamic cell
I have a cell in excel that is changing value automatically based on the quotation of an action. what I need is to count whenever the value is changed. The function below works if called only for an…
excelasked 4 years, 1 month ago Marcio Woppe 19 -
1
votes0
answers86
viewsRecurring errors generating a word file from fields of an excel spreadsheet (VBA)
Good afternoon, I never programmed in VBA but I found myself in a need where I am needing to generate a word document from some cells of a spreadsheet in excel, after searching several websites on…
-
1
votes0
answers62
viewsImport Excel that does not have standard for SQL SERVER with C#
I have the following scenario: I have an Excel spreadsheet that is provided by several private companies. This spreadsheet contains social security data. The problem is this: I have columns that…
-
1
votes0
answers185
viewsHow to Subscribe to Email by Excel?
I have a code to copy the page from Excel, but I can’t put my signature. Sub Send_Range_Or_Whole_Worksheet_with_MailEnvelope_SI() 'Working in Excel 2002-2016 Dim AWorksheet As Worksheet Dim Sendrng…
-
1
votes1
answer30
viewsReplace word set in Excel
I have an Excel spreadsheet with some columns, for example: Fruta | Veículo | Profissões -------------------------- Banana Carro Médico Pera Moto Programador Maça Barco Engenheiro Morango Avião…
-
1
votes1
answer1254
viewsExcel - cell with "hidden" characters
I identified this "anomaly" when I tried to use the PROCV and Excel returned me not available (#N/D). What happens is that there’s a cell that’s apparently "normal," but when you do: CTRL+C, CTRL+L,…
-
1
votes1
answer611
viewsReturn HIGHER value with condition
good night. I have a spreadsheet in NUMBERS (spreadsheet program similar to Excel), because I use Mac and have been used to it for years. Serves me well although I know there is Excel for Mac. My…
excelasked 6 years, 2 months ago Alan Fernandes 31 -
1
votes2
answers6120
viewsExtract SAP data through Excel
Hello! I’m trying to integrate Excel with SAP via VBA. I would like to run the transaction "MB51" with some parameters like date, deposit and movement and bring the data obtained to the Excel…
-
1
votes0
answers63
viewsMacros outside of Excel?
I’m venturing through the world of programming, and at first, I’m using a lot of VBA in the company, and it’s helping me a lot, tasks that took hours, I’m doing in a few seconds using macros! I work…
-
1
votes2
answers422
viewsFinding students without a class - Python / Excel
I have a spreadsheet in Excel with all my students and their respective grades (5th to 9th). I need to find all my students who aren’t in any class. Through the Excel filter I can do, but I have…