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
votes0
answers465
viewsProblems with OPENROWSET in SQL Server 2016 Express (64bit)
Good morning, I’m trying to read an Excel file . xls by the OLEDB driver used in SQL Server for integrations with Microsoft.ACE.OLEDB.12 files. 0 in SQL Server 2016 Express (64bit). Using command…
-
0
votes0
answers933
viewsProblems with openpyxl. Open Excel File with Python
I am trying to read an Excel file but it appears this error message. Warning (from warnings module): File…
-
0
votes2
answers1669
viewsChanging the Python CSV File Delimiter
I have a difficulty in delimiting the cells of the CSV file, when I send the command to save the edited file in CSV escritor.writerow([linhas]) the default delimiter is ,, the more I need to change…
-
0
votes2
answers50
viewsBdmedia Excel function
If I run the Bdmedia function in a table column containing text, it will enter as count on average? For example, in a column with 10 dice, being 9 numbers and 1 text, it will divide the sum of the…
-
0
votes1
answer1214
viewsHow to display the number of rows in the left sidebar of the VBA Excel?
How do I display the line numbering on the side highlighted in red in the VBA?? without showing the number of lines gets very confusing when debugging, as I do to show the number??…
excelasked 6 years, 2 months ago Elienay Junior 527 -
0
votes1
answer90
viewsHow can I tabulate a mass file?
Hello, I have a 64500-line file and 11 tabular columns. The original file came from the counter system, which is a system for printing paper. I already got the headlines out, but I’m having trouble…
-
0
votes2
answers2677
viewsCopy data from one spreadsheet to another
I have a problem in one macro, I am trying to copy data from one spreadsheet and paste into another, but this giving an error when doing the insertion of a new line (in yellow). Spreadsheets: Code:…
-
0
votes1
answer3961
viewsSave data in. xlsx format with pandas
Good afternoon! I want to save in a file . xlsx the loop number that my code is running, but the way it is, saves only the last loop. import time import pandas as pd loop = 0 print('Loop') writer =…
-
0
votes1
answer404
viewsVLOOKUP function does not work in Excel
I’m making formulas in Spreadsheets Google, but when making a conditional formatting is stating that the formula is incorrect. =VLOOKUP(C3; Concursos!C3:H5; 1; FALSE) All cells contain whole…
-
0
votes1
answer33
viewsWrong Return on SE function
=SE(C5<=3,09;"0,15%";SE(C5<=3,1--4,99;"0,20%";SE(C5>=5;C5;"0,30%"))) is returning wrong value in the last function…
-
0
votes1
answer596
viewsHow do I turn my results into txt, excel or word file?
I have a code in Python that does the following: Extracts several data from different tables and performs a linear regression between them. So far so good but how do I make my results come out clean…
-
0
votes0
answers63
viewsRaise Xlrderror - Indicating Sheet_name Python
Good morning. I’m starting with Python and I have a problem. I have N files in Excel and need to read the sheet_name of each indicating their name, the code I have so far is this: os.chdir("work…
-
0
votes0
answers37
viewsDoubt about Excel textbox control
You guys, good night! Reason for my coming here: I have a Textbox control in an Excel Form (VBA). This form is configured to accept line breaks with ENTER and multiline. However, when sending this…
-
0
votes2
answers335
viewsDisable Vba Excel View Mode
How to Disable Display Mode by Vba Excel. Wanted that when opening the spreadsheet the user already came with this enabled feature…
-
0
votes1
answer29
viewsPreview Excel, Power Point, Word on a website
Good morning, I’d like to know how to preview Excel, Power Point, Word on a website. For PDF I managed to do with this code. <embed src="RelatorioM16.pdf" width="760"…
-
0
votes1
answer80
viewsTable for Excel taking too long
Good , I have a query in the database , that returns me to depend on this query 5k lines to 30k lines , I’m generating already in excel through the code below , however when brings me about 5k of…
-
0
votes0
answers15
viewsMultiple Results with two criteria
I have a question in excel. I have a table with the columns "Seller", "Customer" and "City". would like to get a way to see all results achieved, for a particular Seller in a particular city, ie see…
excelasked 5 years, 11 months ago user147478 1 -
0
votes1
answer39
viewsDoes anyone know a function in excel or other program to count the amount of numbers existing between a range of numbers?
I wanted to find the amount of existing numbers in a range of numbers. So I don’t have to look for the numbers manually q are in the value range. Ex: 0,340-0,345. In answer: 6 (0,340 . 0,341 . 0,342…
excelasked 5 years, 11 months ago Ernandes De Melo 1 -
0
votes1
answer2827
viewsHow to change the size of the Activex Excel checkbox (Checkbox)?
I can’t change the size of the activex Excel checkbox, there is some way to change the size because it is too small and the font size option is disabled, I really wanted to leave it the desired…
-
0
votes2
answers3906
viewsHow to add values related to a line, searched with the Index + Corresp function in Excel?
I wanted to add some values related to the names given to the cells "Ref 1, 2 and 3" summing all the values of the columns "N1, N2 and N3" according to the "Ref" sought, for this I used this…
excelasked 5 years, 11 months ago Elienay Junior 527 -
0
votes0
answers119
viewsCriteria to unpack list in excel
I have a list that comes with data from other spreadsheets. Do a MAJOR to get back the 1st largest, and then the 2nd and so on. Then I do a PROCV to get the name referring to this value. Until then…
excelasked 6 years, 10 months ago Ricardo Marzano 11 -
0
votes0
answers48
viewsExporting html to excel does not work in Firefox
Good afternoon, I’m doing a function to export my table in excel... In google chorme works well, however I was testing in firefox and not working and does not return me error, I can not identify…
-
0
votes1
answer123
viewsBlockinput VBA/EXCEL
I need to lock the commands in my macro in Excel. I am using the following function: Public Declare Function BlockInput Lib "user32" (ByVal fblock As Long) As Long On the computer with 64 bit win…
-
0
votes1
answer99
viewsHow to compare two columns and return the sum?
Personal talk, I have the following table below, what I want is that it adds the Price (Column D) of all books with the Situation (Column AND) "Sold". I know I can do with the PROCV function. But I…
-
0
votes1
answer237
viewsFind a sub-string in the first column of a csv file
I am starting learning in python and do not know how to continue this code. I need to check the first column of a csv file, and if I don’t have a date in a cell in that column, insert the one that…
-
0
votes1
answer32
viewsDuplicate spreadsheet
Hello, I have a spreadsheet that contains some important data, I wonder if there is any to duplicate this spreadsheet automatically, so that I manipulate the data in a spreadsheet and when click to…
-
0
votes1
answer562
viewsCopy the contents of a spreadsheet and paste into a new one using VBA
Good afternoon! I need to create a code in VBA that copies the contents of several worksheets and paste into a specific worksheet. In case, it would have to have a repeat loop to open the sheets of…
-
0
votes1
answer357
viewsMacro to join two Excel columns
Hello! I have a question about Excel. I have two columns, I would like a macro that when used, transforms all the rows of these two columns into rows of only one column. I know I can use the…
-
0
votes1
answer972
viewsPHP Application -File Download Problems in xlsx
Hello, I have an application that is having trouble downloading files in the latest Excel format Displays the message from in the application calls this file in php in the upload I have no problems…
-
0
votes1
answer619
viewsUpdate dynamic table with connection to a Stored Procedure using Macro VBA
I aim to bring the data from a Stored Procedure to a spreadsheet in Excel. This Stored Procedure is using two parameters for the query. Excel 2013 SQL Server What do I have I set up a macro that…
-
0
votes1
answer329
viewsError importing data from an Excel spreadsheet to mysql directly on the server
I am trying to import data from an Excel csv spreadsheet, however the following error appears: Invalid column count in CSV input on line 1. I imported directly to the root of the database (created…
-
0
votes1
answer668
viewsHow to add content to the Excel VBA Listbox
Hello, I have a question in a code for Excel VBA. I want the code to search in the spreadsheet the same number that was entered in the TextBox, after finding it sends the information of the entire…
-
0
votes3
answers3521
viewsFailure of RANGE class SELECT method
The intention is that by clicking on the Sintese Euro tab, the macro would impute the "L" character in cell D1 of the Synthesis Local tab and then return to the Euro Synthesis tab. I was able to…
-
0
votes1
answer51
viewsHow do I make a conditional using just using the date MONTH and from it insert a formula into a certain cell?
I’m optimizing a spreadsheet, but this formula is not working =SE($A2="/01/";$S2="=MÊS($A2)";"errado"). I would like the formula to do the following, case in the cell A2 contain the month of January…
excelasked 5 years, 10 months ago Tomás Lacarte 1 -
0
votes2
answers46
viewsSE - Excel function
Good afternoon! I’m having trouble making a field true or false but with 3 variables. If A1 and B1 = "N" will be Null If only A1 = "N" will be True If Only B1 = "N" will be False How can I mount a…
-
0
votes1
answer381
viewsFunction to convert decimal numbers to spellnumber using VBA in Excel
I have a function, =Spellnumber(), that when you put a number there, it drops the number in full. Agr, it drops, in the cents part, and X Cents. I would like her to release with X/100. Does anyone…
-
0
votes1
answer48
viewsReset Page every click
Have in the figure above this small Userform with three pages. On the first page, when clicking the Enable button, the next date is inserted with Textbox Data as False, so that the user does not…
-
0
votes0
answers53
viewsData Input - Listview
Good morning guys! Well, I created a data update form with a listview view! I put the value in the textbox, click on the desired line and click on change and the value on listview is changed but in…
-
0
votes0
answers31
viewsEdit cell value in wrong tab
Guys first good day! I have a problem because I made a button to edit the value of a certain cell, however my file has 10 different tabs, and it is registering in the wrong tab, as I can do to…
-
0
votes1
answer85
viewsFind duplicate values - Excel
How to return a company based on a value, even if the Matrix has several duplicates. You can return the first found.…
-
0
votes1
answer204
views"Fade in and Delete - VBA" effect
for kindness, I’m with a doubt in VBA - MS EXCEL 2016 I need to create a macro that when I trigger it, it looks for a.png image on my computer and inserts it on the spreadsheet with the gradual…
-
0
votes1
answer395
viewsPaint cell according to dates in excel
I have a worksheet to control activities, it contains a table with "expected start" and another with "expected end", within this table have dates as an example: 24/07/19 formatted to leave in this…
excelasked 5 years, 8 months ago Felipe Deolindo 179 -
0
votes1
answer108
viewsProblems with Activex control (option button), counting values according to button marking
I want to count the values according to the marking of the button, for each click on each button, I intend to add 1,2,3 in each cells A29: A31. It also serves only one cell as long as it changes the…
excelasked 5 years, 8 months ago Elienay Junior 527 -
0
votes1
answer41
viewsHow to use hyperlink for spreadsheet with selected cell?
Look at the picture; My goal is to click on the mobile the user is directed to the spreadsheet being the line selected, as it is in the image above it is selecting the line manually. The line of…
-
0
votes1
answer36
viewsOrders of the date of a reference in the middle of other dates and references
The situation becomes simpler to understand with a hypothetical scenario. Imagine I bought 3 pieces: Piece A Piece B Piece C. The supplier, as he did not have everything ready for delivery, divided…
-
0
votes1
answer2546
viewsPROV between two spreadsheets
The result I should show in column authors of the production sheet is the name of all the authors who wrote that discipline. I am using the following function =PROCV(C8;'Remanejamento'!C3:D55;2) but…
-
0
votes1
answer443
viewsDelete whitespace from Activex Excel combo box
I have a default list with values and another list of "Organization" when I delete values from the default list to another organization list, organize values. The problem is that I added a combo box…
-
0
votes1
answer222
viewsFill in combobox on web page via VBA
I am trying through VBA in Excel, fill a combobox on a website. But when I run the code, that error message comes up saying that "the object does not accept this property or method". The part of the…
-
0
votes1
answer38
viewsHow do I copy information from a column in googlePlanillas without repeating data if they have repeated data?
i have a spreadsheet in which a column contains names, I need to copy this data to another column, but without copying the repetitions of the names, example: Coluna A Coluna C Américo Américo…
-
0
votes2
answers60
viewsProblems with formulas to extract texts with different spaces
I intend to extract only the numbers in red for the following table "Red", but the spaces are different and I have tested a lot of formulas to solve this issue. I used a rather complex formula, but…
excelasked 5 years, 7 months ago Elienay Junior 527