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
-
0
votes1
answer414
viewsIncrement 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
votes1
answer765
viewsHow to open a Userform with the same name as a button? VBA Language
My program consists of 20 buttons and 20 Userforms. I wanted to simplify the program and make a single Subroutine. Each time I press a button, the Checkbutton Checkbutton analyzes the name of the…
-
0
votes1
answer148
viewsWrite to worksheet from last line without overwriting
I am trying to write in an excel spreadsheet from the last line written without deleting the content that already existed, I have already managed to pick up the last line and write from it, but when…
-
0
votes0
answers44
viewsSite integration with Excel spreadsheet
Hello, I wonder if it is possible to use an excel sheet already configured with formulas and records as a "database" of a website. The intention is for the person to access the page, enter the data…
-
0
votes2
answers131
viewsWhiten figure VBA Excel
Good afternoon. I need a macro to clear a figure, located in the spreadsheet, and reverse the coloring. Excel does not save the macro when I change the settings in the "Format" tab. I have already…
-
0
votes1
answer628
viewsBreak line automatically on export to Excel by Delphi
I’m doing an export to Excel using Delphi. At a certain point, a text ends up being larger than the size of the cell, "popping" its contents out of the cell when opening the file . XLSX generated. I…
-
0
votes1
answer66
viewsHow to fetch excel sheet info to drop down in Visual Basic
I have to dropdown with information that I already have in an excel sheet in Visual Basic, how do I get that same information? And make sure there’s no repeat information? Example: colunaA a a a b b…
-
0
votes1
answer371
viewsCompare first characters of two distinct columns in excel
Is there a function in excel that allows me to compare the first n text characters I want? Por exemplo Tenho a palavra Joaquim e Joana, comparo por "Joa" e ele me retorna verdadeiro ou falso.…
excelasked 6 years, 1 month ago gabrielfalieri 1,231 -
0
votes1
answer365
viewsHow to format cells in excel through php?
I have a php code that retrieves data in a database and generates a CSV file. The client opens this CSV in excel to view the data. So far so good. The demand of the client is that he wants to open…
-
0
votes0
answers38
viewsInsert is not working / Excel
I created a process to make a Insert in a spreadsheet on EXCEL but the data is not being entered. No error is returned. Code: private void AtualizarPerformanceEntrega() { try { DataTable dt =…
-
0
votes1
answer961
viewsExcel VBA changes the date format to mm/dd/yyyy
I’m developing a spreadsheet on Excel using the VBA, which will function as a "micro-system" of registration. I have the following problem: every time I type the date into the cell Cad_0, for…
-
0
votes2
answers139
viewsSort equal rows
I have 4 columns in excel: A,B,C,D right? Only that I need to order to make a comparison because all the information is disorganized I explain myself: Original Archive in . CSV (Disorganized…
-
0
votes0
answers1608
viewsImport access data to excel based on criteria
I have a table in access and I can already pull the data from it to an excel spreadsheet (I can do this using the code below), but I would like to be able to pull only some data (based on criteria,…
-
0
votes2
answers127
viewsConvert HTML5 table + images to CSV or SQL
I’m in big trouble! I have basically 1.5 million records including images in an HTML5 table (it already starts there, the browser does not render all images). My idea was to convert this table to…
-
0
votes1
answer4265
viewsIn EXCEL, How to use Bold formatting of a cell and apply in a "concatenate" function in another cell
I have a small table, I intend to use the bold formatting of the cell "A20" of the number '2001-T' and apply in the function "concatenate" of the cell "F20", but any type of formatting I do in the…
excelasked 6 years ago Elienay Junior 527 -
0
votes1
answer78
viewsListing Codes from a Particular Vendor in Excel
I have a Product Table with Code and Supplier. I would like to know how can in the vendor table list all the codes from a specific vendor. I can do this only through formulas in Excel? Example…
-
0
votes1
answer61
viewsClose Excel after running Macro vba on Qlikview
Macro set obj = ActiveDocument.GetSheetObject("CH1") obj.Export "caminho_para_salvar_arquivo" And now I need to close Excel, I used the following command. obj.Close caminho_para_salvar_arquivo' And…
-
0
votes1
answer42
viewsSave php parameter in vba variable
I have a form I step a parameter and at the same time open an Excel spreadsheet. Following example: <?php if (isset($_GET["param"]) && !empty($_GET["param"])) { $param = $_GET["param"];…
-
0
votes1
answer43
viewsHow to loop in selected cells in Excel?
When I click and drag down the following cells in the appropriate image, in the cell "E21" appears a '3' resulting from tracking the sequence of cells from "A15" to "A18" as I do to loop only the…
excelasked 6 years ago Elienay Junior 527 -
0
votes2
answers403
viewsHow to extract only the penultimate character from a sequence and then use auto-refilling in Excel
I have a numerical sequence separated by spaces, I just want to extract the numbers in red, but when using auto-refill (click and drag down with the cursor) it doesn’t work! how do I extract only…
excelasked 6 years ago Elienay Junior 527 -
0
votes1
answer90
viewsHow to "kill" a class in VBA - Excel
I have a code that calls a Private sub that in turn erases the data from a spreadsheet. If I do the same procedure without closing the form it gives error when deleting the data, but if I create a…
-
0
votes1
answer60
viewsHow to replicate a value depending on what is inside the cell?
I have a code that always puts 264 empty characters after the last word typed inside the cell; then puts more "00000000000000" after 264 empty characters and export to txt, as shown below: My…
-
0
votes1
answer114
viewsScreenupdating x On Error Goto Errorhandler
With the code below: Application.ScreenUpdating = False Application.EnableCancelKey = xlDisabled On Error GoTo ErrorHandler 'Código Exit Sub ErrorHandler:Application.ScreenUpdating = True 'Código…
-
0
votes1
answer84
viewsHow to display separate characters from different sequences by skipping spaces in Excel
I want to display only the numbers in red of the sequence, but this formula only displayed the first specified number and the other after it or before it, I wanted to display jumps in any specific…
excelasked 6 years ago Elienay Junior 527 -
0
votes1
answer120
viewsHow to include weekends in the "=Diatrabalho" function and include additional holidays in Excel?
I have a start date and end of a schedule, I wanted to count the weekends that in case the end date would be 11/11/2018, how to use the function: =DIATRABALHO(C24;E24;Tabela1[DATA]) To count on the…
excelasked 6 years ago Elienay Junior 527 -
0
votes0
answers293
viewsHow to insert color formatting through a formula in Excel?
I have two cells with characters with different color formats, but when using the function Concatenar and other functions to extract the characters in another cell, the color format does not apply…
excelasked 6 years ago Elienay Junior 527 -
0
votes1
answer175
viewsActivate found cell
I’m having trouble activating the cell that was found. The code is as follows:: Private Sub cmdPesquisar_Click() 'Verificar se foi digitado um nome na primeira caixa de texto If Txtnif.Text = ""…
-
0
votes3
answers4298
viewsCount values from one column based on a filter from another column
I have a spreadsheet where I have some data. From this data, I need to count the repeating values of a column SE the value of the cell in the same row but in another column is equal to a given…
excelasked 6 years, 10 months ago Renan Lazarotto 1,025 -
0
votes1
answer221
views"Somarproduct" function of Excel, does not sum the total of two distinct items in relation to the list,?
I used the function "Somarproduto" to add the total of products 1 and 2, but the result of zero, I wanted to add the total values of only two products on the list, but it only works by adding one,…
excelasked 6 years ago Elienay Junior 527 -
0
votes1
answer41
viewsExcel - Insert values within text
Good, I am creating an excel where I would like to insert values (in function) within text. I want to pass values from Column F12 to H12. I want to insert text here where it says [here] UPDATE…
-
0
votes1
answer4727
viewsHow do I use the "LOAD DATA INFILE" command?
It is the following guys, I have a database and in it a table called "people" which contains "id_people" as attribute and I want to test an import of information using this command of the title, I…
-
0
votes1
answer1755
viewsExport html table to excel using javascript by removing a specific column
I have the following script to perform a table export to excel: <script> function fnExcelReport(){ var tab_text="<table border='2px'><tr bgcolor='#87AFC6'>"; var textRange; var…
-
0
votes1
answer3776
viewsExcel: How to make a time series using dynamic table and graph with accumulation of values in the row?
I would like to make a time-series graph showing the accumulated values over time. Therefore, it would not be a zig-zag line, it would be a line denoting an evolution, as values are accumulated. To…
-
0
votes1
answer200
viewsVBA Error when displaying data from a Worksheet
I’m experimenting VBA and managed to add data to a BD in sheet 2. And now I tried to do to show the data on sheet 1 where I choose the ID and it shows the data entered there, but it’s giving me a…
-
0
votes1
answer97
viewsHow to use Excel subtraction on a set of numbers?
I intend to subtract all the values from this small table, but if I have 100 different values, would I have any formula to summarize all the values in the same way as the sum formula, EX:…
excelasked 5 years, 11 months ago Elienay Junior 527 -
0
votes2
answers1621
viewsHow to use Excel’s "PROCH" function to fetch values from the bottom up?
By default the "Proch" function only looks for values from top to bottom, I intend to do the inverse, fetch the values from bottom to top, I want to search for the "40-D" character through the…
excelasked 5 years, 11 months ago Elienay Junior 527 -
0
votes2
answers1066
viewsExcel: Transpose 5 to 5 cells
Hello, I have the following problem, my spreadsheet has hundreds of data all in the same column like this: But I want to find a way to transfer these values to other cells, so that in the first line…
-
0
votes1
answer1114
viewsRuntime error: 9 - subscribed out of range 2
hi! i am having problems with this error. credit that is some problem in the data I entered, but I can not fix. Calcul des cumuls annuels sur l'année hydrologique (1er septembre au 31 aout) For k =…
-
0
votes0
answers205
viewsHow to use the Chunk method of Laravel Excel?
public function uploadNotaCorte(Request $request, EstadoRepository $estadoRepository) { $error = array(); $path = $request->file('file')->getRealPath(); $notasCorte = Excel::load($path,…
-
0
votes0
answers66
viewsHow to unify two tables with repeated primary keys?
I have two tables that we need to unify in one, in a complete way: Consider everything there is in the first, see if it matches with the second and what does not hit or repeat, include in the lines…
-
0
votes0
answers67
viewsWrite an XML using Xmlwriter C# from an Excel table
Hi, I’ve never used Xmlwriter before, this is something totally new to me. I have a table in an excel and need to create an XML file from it, the first column will be the main Node, and each other…
-
0
votes2
answers131
viewsUpdate OLEDB Not working
Good afternoon, I am trying to update an excel spreadsheet but the command is not changing any value, it is only corrupting the spreadsheet. I create the last two columns and rewrite the rest…
-
0
votes1
answer384
viewsHow do I split a chart bar into "%" in Excel
Good morning, I have a graphic that represents a total amount of reasons for delay of 4 companies in total. Does anyone know how to divide the bars, to represent how much each company represents in…
excelasked 5 years, 11 months ago Marcos Henrique 7 -
0
votes1
answer316
viewsHow to calculate Access days lag
Today I use the formula =DIAS(HOJE();H2) to calculate lag time in Excel: But this source I extract from Access, someone knows the syntax to assemble this formula in Access?…
-
0
votes1
answer666
viewsVBA - How to identify last active line, when has formula
The code below identifies the last active line of the worksheet. When column A is filled in manually it works. But when I put a formula to fill that column according to another spreadsheet. The code…
-
0
votes0
answers72
viewsExcel - create a top 10 with all Records
I have a site where generates statistics in . txt, this txt after and generated in excel with all the results. My goal is to create a top of the most viewed articles. This and example: In the…
-
0
votes0
answers77
viewsData Flow Task generates blank Excel file - SQL Server Integration Services
I have a process in SSIS that takes information from a table and exports it to an xlsx file. It happens that, when running Job by SQL Server Agent, often the file is generated blank, even if it has…
-
0
votes1
answer89
viewsFormula SE + PROCV ending in #VALUE!
Guys good afternoon. The formula below is ending in error #WORTH!. The formula is comparing words with hyphenation, I don’t know if it influences anything. =SE(PROCV(R25;'TABELA1'!A:A;1;0);"ERRO DE…
-
0
votes0
answers36
viewsConvert my JSON to Excel
Preci*so from a library that receives the query and when I press a certain button export the result in excel file, detail is that I am using Google’s Chart (graphic) and also intend to put in the…
-
0
votes0
answers59
viewsError "Procv" + "Corresp" function when inserting a combination box (Activex) with numerical references
I made a "procv" + "corresp" function to look for values from a table and added a combo box (activex), and added numbers to the "corresp" to look for the searched value in columns, but when using…
excelasked 5 years, 10 months ago Elienay Junior 527