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
-
-2
votes1
answer40
viewsDifference in calculation between Excel and PHP
I am transforming an excel spreadsheet into a PHP system, but when validating some values I noticed that PHP is different from excel. I have to do the following: PHP (166 / 161,1) = 1,03416 Excel…
-
-2
votes1
answer35
viewsError in excel vba, using . offset, to search for products in a spreadsheet
Hello, I’m trying to learn Excel vba to help my father in his company, I use the version of excel 2016, in the code I built following the course, it was time to enter the product code, it shows the…
-
-2
votes1
answer87
viewsHow to download a table of the quasar in excel format (xlsx)?
The quasar only provides examples of how to download a table in CSV format. I wonder if it is possible, using the same logic, to download tables in excel. Code of how I am doing. The file comes to…
-
-2
votes0
answers18
viewsExcel Help || POWER PIVOT
I am trying to learn how to use power pivot in conjunction with power query for obtaining and modeling data in excel. I was able to import the databases and include them in the excel data model,…
-
-2
votes0
answers18
viewsC# cannot interact with Excel
Hello. I am programming Forms with C# in Visual Studio Community 2019. My program triggers Excel and creates a spreadsheet. On my computer everything goes well, but when I installed the executable…
-
-3
votes2
answers9083
viewsVBA function to make text uppercase
Good afternoon. How to capitalize the spans of just a few cells of a form mounted on an excel sheet? Numeric and e-mail field cells should not be altered. I only found formulas and functions for…
-
-3
votes1
answer704
viewsHow do I read . xlsx files with PHP or JS?
Hello, I am developing a project where I need to show data from an Excel spreadsheet that is in format . xlsx on a page. I researched and found on the Phpexcel but the same was discontinued. I…
-
-3
votes2
answers5456
viewsRemove space between words in Excel
I have a spreadsheet of 7 thousand lines and I need to remove the space between the numbers. I tried to use the function ARRUMAR or TRIM but it didn’t work. On the spreadsheet it’s like this: 11…
-
-3
votes1
answer53
viewsExtract names formatted with specific colors at different positions
I have names and they have colors corresponding to the name of the color itself. I intend to extract these names referring to the colors I want. The problem is that they are in different positions,…
excelasked 5 years, 2 months ago Elienay Junior 527 -
-3
votes1
answer19
viewsExcel, how to extract data from a column with two variables relating these variables to two other variables
My idea here would be to put the CA1 QTD at the time of 14:49 in column B 2x2, and so on, organizing all the schedules.…
-
-3
votes2
answers82
viewsDoubts in the combobox
I have two combobox, the first is the managers and the second I have the coordinators. MANAGER - FABIO - ADRIANA - LEANDRO COORDINATORS - TEREZA - GERALDO - GABRIELE - JOICE - VALDIR -ROSE - KATIA…
-
-3
votes1
answer136
views -
-3
votes1
answer143
viewsMerge multiple excel sheets into one
Hey there, guys. So, I have a folder on my computer where several spreadsheets are played and I need the spreadsheet1.xlsm, worksheet2.xlsm, worksheet3.xlsm... but they are together from other…
-
-3
votes1
answer25
viewsAssign formula to a cell in VBA - Appears a @
I am learning VBA and in a sub where I try to assign the command below: =PROCX([@[Empresa Emitente]];FORNECEDORES[Empresa Emitente];FORNECEDORES[DEPART];"";0;1) Sub EXTRAIR_DEPART_UPDATE() Dim…
-
-3
votes0
answers16
viewsExport Table to Excel ANGULAR
I wonder what I might be doing wrong in my code. I need to export the table to Excel, but when I do that the table is empty, I have no idea where I went wrong. Follows the code: "code html"…
-
-4
votes1
answer50
viewsExcel Repeat Value Check
How to check in Excel if the value of a cell is repeated, row value in the same column,I did not make any command attempt. I would like to know if there is a specific formula?
excelasked 6 years, 10 months ago Rodrigo Sodre Dias 1 -
-4
votes0
answers15
viewsExcel to real-time database with C#
Is it possible to take the data from an Excel spreadsheet (which is updated every second) and save the information every second in a database? The worksheet should be kept open at all times for the…