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
votes5
answers19696
viewsRemoving the last name of a cell
I have a table with the full name of users and needed nourish column put the last name, someone help me with the formula? A2 = Ricardo Simoes B2 = Simoes I’ve been trying like this But make a…
excelasked 9 years, 7 months ago Ricardo Simoes 83 -
0
votes0
answers67
viewsManipulate Decimal Values in EXCEL + VB
I have an application that provides a webservice(Ws) (java) but I need to carry data to an excel sheet and print, my problem is, when I get Ws values depending on the operating system’s Reginal…
-
0
votes2
answers86
viewsHow to take the file path and insert it into a table?
I need to create a Mysql statement that takes all the file paths of the files in a specific folder and inserts them into a Mysql table. For example, if my folder is called PastaTeste, I need…
-
0
votes1
answer805
viewsVBA does not recognize values
I am trying to get data type values from a certain excel cell, however, my macro does not recognize the values of the cell, even if it is filled (date). Remembering that there are three Heets. With…
-
0
votes1
answer1226
viewsProblem when exporting data from c# datagridview to excel spreadsheet
Good morning guys, I have the following code below, in it I am taking the data from the datagridview and exporting to one . xls, I’m going through everything like String, the texts, names, which are…
-
0
votes1
answer1988
viewsList returns only last element
Eae guys, after a lot of work I managed to get several xml tags to play in an Excel report. But when I populate the list with my object and step into the report only the last element is listed. I’ve…
-
0
votes2
answers555
viewsSecurity Message on Activex control
System: Windows 8 and Microsoft Office 2013 I am having problems with an alert screen on Activex control that has been bothering me for some time: Before opening the Form where the Windows Media…
-
0
votes1
answer42
viewsDoubt in excel
I need the following formula: If salary less than R $ 1399,12, calculate 8% If salary greater than R $ 1399,13 and less than R $ 2331,88, calculate 9% If salary greater than R $ 2331,89 and less…
-
0
votes1
answer1193
viewsProblems with Error '9': subscribed out of range
I’m creating a customer register, and every time I debug when it comes to: totaldelinhas = Worksheets("bancodedados").UsedRange.Rows.Count + 1 caixa_Localizar.RowSourceType = "bancodedados!a2:a90"…
-
0
votes1
answer583
viewsHow to drag some objects and forms in VBA/Excel and prevent the drag of others?
I’m having difficulties when trying to control "drag forms" and "drag objects" in VBA/Excel. For example: I have the main form that I don’t want to be moved, a second form is called from the main…
-
0
votes1
answer861
viewsExport Mysql database data to Excel
I am running a post that send a string with all titles and fields of a database, but it only exports when I send up to 4 months. I wish I could send up to 1 year, how could I improve the code below…
-
0
votes0
answers65
views -
0
votes0
answers818
viewsOpen and read an Excel spreadsheet by Lazarus Using OLE
The code below works perfectly in Delphi, but when ported to Lazarus, the code compiles without problems, but at the time of execution an exception occurs and the program is closed. function…
-
0
votes2
answers651
viewsFill value in Internet page
So people want to put a value on a web page, but before that I log into it and I’m directed to another page, there I navigate to a different page, and I took a look at the page code and the place…
-
0
votes0
answers163
viewsOrganizing EXCEL data
My goal is to interpolate Cubic Spline. For this I am organizing my data as follows: I made a simple modification. I calculated the working days between the day in column B and the dates. For the…
-
0
votes1
answer48
viewsDoubt in table generation in excel file
I have a Javascript function that generates the table of a page in an Excel spreadsheet. Follow the code below: function montaExcel(){ var tab_text = "<table><tr><td><img…
-
0
votes0
answers362
viewsReading cells with HLOOKUP formulas
I’m having a hard time evaluating a formula with the Apache Poi API in a cell that contains the formula HLOOKUP(B9,$AK$8:$AS$68,2,FALSE). The same thing happens to be a file .xls or .xlsx. The excel…
-
0
votes0
answers941
viewsExport Table in EXCEL with PHP
I am exporting my data to excel format, but when I export the accents do not return correctly, this is my script: <?php include_once "bancodedados.php"; $table="smt_cadastro_sociedades"; $select…
-
0
votes0
answers188
viewsPass data from a list of a sheet 1 to another list of sheet 2 being ordered by the largest to smallest of a numerical column
In sheet 1 I have an occurrence list that has several columns of C to AI, I’m looking forward to going over the data from this column list C6:C25 and AI6:AI25 for spreadsheet 2, for columns D6:D25…
-
0
votes1
answer546
viewsnumber even, odd, zero and more than 10 how to find?
For g = 1 To 10 For f = 1 To 10 Cells(f, g) = Int(100 * Rnd()) k = Cells(f, g) If Int(k / 2) - k / 2 = 0 Then pares = pares + 1 Else Impares = Impares + 1 End If If k = 0 Then Zeros = Zeros + 1 If k…
-
0
votes1
answer845
viewsColor Palette (VBA/Excel), "right mouse" event for Frame objects
I found no reference to the event that is triggered by the right mouse button on a Frame object. With the event of the left mouse button select the desired color, this is working, however, with the…
-
0
votes1
answer443
viewsHow to make a public routine for all forms without being tied to a form?
I have several forms in my application, and I can start the call by some of them running partial for testing (not necessarily START from the main form). In addition to the public variables that are…
-
0
votes1
answer172
viewsError while exporting Datagridview to Datatable
I am trying to generate an Excel spreadsheet based on a Datatable, all data are in the given format, but the Date format is in the American standard ("MM/dd/YYYY"). Follow the function code:…
-
0
votes1
answer155
viewsCONT.SES BETWEEN DIFFERENT LIBREOFFICE/EXCEL FILES
I’m using the CONT.SES amid different files, but I’m getting: ERROR:504. The formula is like this:…
excelasked 8 years, 2 months ago Jaciel Barros 21 -
0
votes1
answer184
viewshow to establish a numerical range for average calculation
I want to calculate the average of a variable with the following formula: =MÉDIASE(M2:M487;">=20 <25";O2:O487) or I want the values of M2 to M487 to be greater than or equal to 20 and smaller…
excelasked 8 years, 1 month ago Jurandir Godoy Duarte 1 -
0
votes0
answers65
viewsCalculation in Excel and PHP/SQL with different result
I made the calculation of a column in my spreadsheet and the value is X. However, when I calculate the column with SQL using SUM, or even in a loop with PHP, the value is different. The funny thing…
-
0
votes1
answer369
viewsSearch substring in column
What I need is almost a procv. I have a cell with a word and I need to search for that word in a column in another spreadsheet. But in the cells in that column there are several words. For example,…
-
0
votes1
answer1416
viewsGenerate an XLS without using Excel (BIFF)
How to generate a file .xls without using Excel? I don’t wish to use the OLE, before entering the information in binary format, using the structure BIFF8 or something similar. The problem is I can’t…
-
0
votes1
answer380
viewsHow to paste text in the same Excel column?
I copy data from a PDF and would like each row to be pasted all in the same column "A", because then I have a macro that does all the work of dividing into columns that works very well. On my…
-
0
votes1
answer181
viewsExcel - VBA: Need support to lynch the Max function
How can I reference a certain column sheet through the command below in VBA? Application.WorksheetFunction.Max
-
0
votes0
answers272
viewsCompare field values of two excel tables in different files
I have two tables in 2 excel files, and I want to compare each value of the A column of the file_1 with each value of the A column of the file_2 and also each value of the F column of the file_1…
-
0
votes1
answer2542
viewsHow to color column date type according to current date
I have an Excel schedule table, which I need the color to change according to the date,. If the date is longer than the current date will turn red as well (Schedule expired). I tried conditional…
excelasked 7 years, 11 months ago Chefe Druida 1,086 -
0
votes1
answer281
viewsAdd photo in excel from local folder
Hello, I followed every step here - Add photo in excel spreadsheet from local folder And it all worked out well. But I wanted to resize the images and align them to the center of the cell -…
-
0
votes1
answer641
viewsHow to generate Microsoft Excel spreadsheets in . NET Core?
I need to generate Microsoft Excel spreadsheets through .NET Core, there is some library that does this? In my research I could only find the Open XML SDK from Microsoft itself, but support for .…
-
0
votes3
answers11310
viewsExtract text with VBA
I need to create a macro in EXCEL that goes to a cell that has a text, and brings me a piece of this text. The problem is that the text has no pattern, only know that somewhere in this text will be…
-
0
votes1
answer314
viewsMacro Excel capture link redirects
It is possible to create a macro that copies the redirects I have on links in cells A1:A100 ? For example in the cell A1 have www.pplware.com, but when we open this url I am redirected to another…
-
0
votes2
answers2106
viewsHow to calculate time intervals in excel
I have a spreadsheet that tells me where a truck was at a certain time: DATA/HORA COD. REVENDA 24/1/17 0:50 1 24/1/17 0:51 1 24/1/17 0:53 1 24/1/17 0:54 1 24/1/17 0:56 1 24/1/17 0:57 1 24/1/17 0:59…
excelasked 7 years, 9 months ago mrlucasrib 641 -
0
votes0
answers241
viewsTabulation in excel
Hello I have a spreadsheet with some data on imports from the IRS. On this worksheet I do a tabulation of data, based on one of the columns that comes in this worksheet called "product description",…
-
0
votes2
answers6462
viewsCreate excel file with c#
I have a problem: I have to generate a class in C# to create an Excel file, but I’m not getting it. Someone can help me? The idea is to generate an Excel file with a menu and a line with values.…
-
0
votes0
answers110
viewsGraphic design
Good evening. You would know how to mount the graphic of the figure below, being that in the graph the numbers 1, 2 .... should take the 3 columns on the side, leaving something like: 1 1 of 10; 10%…
excelasked 7 years, 7 months ago Clebson Omena 63 -
0
votes2
answers4697
viewsVBA: Filter multiple items of a Dynamic Table containing certain text
I am trying to run a code that shows all the items of a Dynamic Table that contain a certain text. I imagined that only using asterisks (*) before and after my keyword I could get results, but the…
-
0
votes2
answers68
viewsConditions if nested
I would like to create a formula SE using the following conditions: 1-Se A for maior ou igual a 1 e menor ou igual a 3 devolve B, caso não 0 2-Se A for maior ou igual a 4 e menor ou igual a 6…
-
0
votes1
answer702
viewsFailure to generate TXT file by routine for printing in VBA/Excel
The form below refers to the code under VBA (Excel) presented below. This code refers to the printing of a spreadsheet on Excel by name "Imprint", as shown in the figure below. By the parameters…
-
0
votes1
answer3868
viewsUpdate all Dynamic Tables when selecting a Worksheet
I need all the dynamic tables in my spreadsheet to be updated every time I select one of my worksheets that serves as Dashboard. I used the most logical code, but I think something is missing, since…
-
0
votes1
answer32
viewsAssociation condition E as formatting between numerical ranges
I would like a hint of how I do to enable the equation below: =SE(E($Q1744=W10;8>=$R1744<=12,99);1;0)
-
0
votes1
answer388
viewsCopy cells to another Worksheet if they do not exist
In the Worksheet "BASE" I enter various customer data (NIF, name, address, telephone, email). I have a Worksheet "DATA" where you have a list of several clients. I need to create a button on the…
-
0
votes1
answer211
viewsWhen I refer more than one column using Formular1c1
good morning! I’m having problems when referencing more than one column in excel using VBA, for example: I make a selection of columns Stock! A:G and create the macro, and generate for me Stock!…
-
0
votes1
answer1201
viewsHow to return the data processing in Matrix passed as parameter for routines in VBA/Excel?
I need to pass separate matrices for a routine that sorts its elements and receive other treatments, and after that I want it to return those ordered and treated values to the original matrix; for…
-
0
votes1
answer165
viewsDisplay return of an SQL query in Excel
My question is divided into two parts. The first, it is possible to perform SQL command by Excel, because I need to display certain information from my Mysql database in an Excel table. Observing: I…
-
0
votes1
answer478
viewsExport Listview to Excel (.xls) from a list populated by LINQ, WPF project (C#)?
Good... I need to export the Listview data populated by the LINQ method of an SQL database... I’m not getting the Column Headers in Excel... Anyone can help? Reference:…