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
-
5
votes2
answers21680
viewsRedeem the largest number of a matrix with criteria
I need some formula or logic to rescue the largest number of a matrix, but with certain criteria. As well as the formulas CONT.SES and SOMASES that counts and sums the numbers of a matrix when the…
excelasked 9 years, 4 months ago Iago Correia Guimarães 799 -
5
votes1
answer5689
viewsDifference between hours greater than 24 hours excel
How to calculate difference between hours in Excel when it exceeds 24 hours? Example: A1 = 05/01/2016 11:40:53 B2 = 06/01/2016 12:29:53 B2-A1 = 24h:49min But he returns 00:49…
-
5
votes1
answer677
viewsHow to modify VBA function to write a number greater than 1 trillion in EXCEL cell?
In 2013 a user sent a question about how to write out a number stored in an EXCEL cell. One of the answers contained a VBA function that had already been published by UOL for some time. I consider…
-
5
votes1
answer3351
viewsMACRO in Excel - printing with sequential numbers
I have a macro from a few years ago that still works, when I click to print the production orders of my company, I put the start and end number, and the macro prints the Ops with the numbers in…
-
5
votes1
answer5547
viewsImporting data from a web page to Excel via VBA
Here’s the thing: I found the code on the Internet that works perfectly with what you’re indicating, but I need to adapt it to a project and I’m not getting it. In short, the macro accesses the page…
-
5
votes1
answer859
viewsWord search in excel spreadsheet and return of the entire line containing that word in PYTHON
Hi, how are you? I am a beginner in Python and would like to run a script that given a spreadsheet in excel, the user could search a word inside this spreadsheet (input) and if the word was found to…
-
5
votes1
answer235
viewsBug in code, function repeats calling when opening excel file
Further to this question: /a/112899/13237 Code: Function PrinciQualidade14(LNumber As Integer) As String If LNumber < 15 And LNumber > 0 Then InsertPictureInRange LNumber,…
-
5
votes1
answer1790
viewsImport Excel to Sql Server C#
I need to import a file excel for a table SQL. However, I need to pick up the lines and go between them because it won’t be all the information I will get from excel. I have exactly what I need but…
-
5
votes3
answers5352
viewsHow to convert from Text to Number via code to EXCEL in C#
I have a program that reads data from a text file and exports it to an excel report. I have a problem in the transcription of the numbers, in the txt file I have data in this format: 8,000000 this…
-
5
votes2
answers4543
viewsHandle spreadsheet with userform loaded (excel vba)?
When we’re with a userform loaded, it is possible alter/navigate in the spreadsheets of excel?
-
5
votes2
answers17620
viewsHow to remove semicolon character with excel
I am trying to use an excel formula to remove the semicolon, but even with the correct formula line I am not able to solve. What I got now is this: =SUBSTITUIR(SUBSTITUIR(K2;".";"");",00";"") I’m…
excelasked 7 years, 8 months ago adventistapr 5,498 -
5
votes2
answers728
viewsFind equal ranges in a list
I am a beginner and I tried almost everything but I could not solve the issue and I wonder if someone could help me. In a column I have numeric values and I would like to compare the intervals of…
-
5
votes1
answer1118
viewsReturn Dowload Excel via MVC Controller
I have a method that generates an excel file and writes it in a directory, but then I take the path of the directory and I need to download the excel file, but nothing occurs, no error. Can anyone…
-
5
votes5
answers32003
viewswhat formula do I make for ranges of values in excel?
I need a formula in excel that identifies ranges, e.g. 0-30 = 20% 31-60 = 98,5% 61-90 = 100% 91-120 = 101,5% if f2<= 30 inform 20%; if f2>30 and <60 inform 98,5%, etc. How do I do?…
-
5
votes1
answer595
viewsImport multiple excel tables at the same time
I want to import 27 Excel tables into R without having to type 27 times the import command already, that the table names go from tab101 to tab127. I tried that way, but you made a mistake:…
-
4
votes3
answers12958
viewsGenerate Excel with php query
I need some help. I have a query in php and Mysql and would like to add to this query the option to export the data also to excel. It is possible to do this with php? <div id="tabs">…
-
4
votes1
answer2188
viewsRead rows and columns merged in excel, using python
I’m having trouble reading the information from a spreadsheet that has rows and columns merged. I tried to use merged_cell to get the value, but I don’t understand how it works. Can anyone help me?…
-
4
votes1
answer2749
viewsImport Excel Data to SQL Server
I need to import the data that is in excel into a table in sql. I looked at several websites but nothing has worked so far. Using sql server management studio I have done the following so far,…
-
4
votes1
answer138
viewsDoubt in string comparison and list value for all lines
I have a table of 5 rows and 5 columns. For each column I have a name, for example: Name, Age, Gender, Weight, Height. And all cells 5*5 are filled. I need the following formatting: Idade João - 15…
-
4
votes1
answer1312
viewsDrop-down list with repeat criteria
I have a conference list, where in Plan1, column A', will be typed only the cods that are in Plan2, column A' more with a criterion can only repeat the total of times that is in plan2. To type in…
-
4
votes1
answer228
viewsCalculation with Excel hours are not very accurate
I have a spreadsheet that calculates the hours a company car is used in a month. each race is scheduled starting time and final time taking 30-minute intervals. at the end of the month then I have a…
-
4
votes1
answer10937
viewsUse sheet name extracted from a cell
I am creating a workbook in excel that will serve as a template for many others that will be generated through it. This template workbook has 5 worksheets, and one of it can be replicated several…
excelasked 10 years, 1 month ago Juarez Turrini 191 -
4
votes1
answer12788
viewsRounding of hours (every 30 minutes)
Does anyone have any idea of any logic for rounding the hour, but every 30 minutes? Example: vem assim -> vira assim 15:34:32 -> 15:30 15:47:21 -> 15:30 16:00:40 -> 16:00 17:28:30 ->…
-
4
votes1
answer1716
viewsValues within a given range
I want to make the following formula but I’m not getting it. I don’t know if it’s with =SE(), but what I need to know is whether a value lies within a range (from 1 to 2) or not.…
-
4
votes1
answer21806
viewsRead rows and columns by Python, by excel
My doubt is if there is any resource for me to be able to read excel rows and columns. For example: I have experimental data in excel containing header in the first row having about 12 columns of…
-
4
votes1
answer1376
viewsDividing integers in MS Excel (exact division)
I have a problem in Excel that I thought would be easy to solve, but to breaking my head is the following: I have an order grid, for example, 2,010 pairs, and the production control and the…
excelasked 9 years, 6 months ago Denis L. Murara 645 -
4
votes0
answers76
viewsUpdate data (Excel)
I’m having a problem related to external data in excel this is an example of what I have done: Index (Book) Painel (sheet) - I enter data in the panel that will be sent to another book (count) sheet…
excelasked 8 years, 11 months ago Mário Passos 41 -
4
votes0
answers217
viewsBetter logic for sheet handling
Good afternoon dear friends, I have a project in hand where I have four spreadsheets, one of each "computer station management program" in which, in all of them, I have a column with the number of…
-
4
votes1
answer5086
viewsHow to "Copy and Paste" a VBA form?
I have a form ready that I want to take advantage of everything I did for him but in another form, it would be the case to do something similar to "Copy and Paste", has how to do?
-
4
votes1
answer233
viewsRange.Paste Runtime error when pasting web data
Hello. I am extracting some data from an html table of an ERP that due to limitations lead me to it. Anyway, the problem consists of, when copying the table and trying to glue it with range.Paste or…
-
4
votes1
answer214
viewsCreate add-in that associates number to an image
I need to create a supplement (add-in) that associates a number to an image. Example: =getImageQualidade(1) 'e nessa célula ficava a imagem. I already know how to create/implement a basic…
-
4
votes1
answer2786
viewsHow to format a cell from the RGB code contained in the cell itself
It is possible to change the background color of a cell from a code RGB or hexadecimal written as text in the cell itself? Let’s say I write 255,0,0 in célula A1 and when I press enter cell…
-
4
votes2
answers516
viewsFunction IF Nested?
I wonder how to nest the Function SE as follows: Se G6 for >=20 e <=30 então 100, Se G6 >30 e <=40 então 200, Se G6 >40 e <=50 então 300, Se G6 >50 e <=60 então 400 How to…
excelasked 7 years, 10 months ago Carla Andrade 43 -
4
votes1
answer482
viewsHow to treat unusual closing of a Combobox list in VBA?
I am creating an important effect for the presentation of a Combobox in particular. This Combobox is originally produced centralized, and when opening your list I make the text left-aligned so that…
-
4
votes3
answers1167
viewsEpplus row and column last cell - C#
I want to select a range from the first to the last cell filled in the row or column. In VBA the code is as below using Range(Selection, Selection.End(xlDown)).Select Range(Selection,…
-
4
votes1
answer202
viewsAs per comments on user defined function in Excel/VB
I would like to know how to by that help in user-defined functions in Excel. Not how you create the user-defined function, and yes as it adds instructions as user must manipulate it.…
-
4
votes2
answers2259
viewsFormat output Excel - Python
I turn a list into a Dataframe and send it to an Excel, it’s working fine. Follow the code: Df = pd.DataFrame(Lista, columns = colunas_geradas) writer = pd.ExcelWriter('Exemplo.xlsx', engine =…
-
4
votes4
answers33862
viewsHow to search for values in column A that do not exist in column B?
For example, I have a spreadsheet: [ A ] [ B ] 1 valor1 valor1 2 valor2 valor2 3 valor3 valor3 4 valor4 valor4 5 valor5 valor6 You can see that in column B, there is no valor5, what I wanted is to…
excelasked 7 years, 2 months ago Lucas de Carvalho 6,427 -
4
votes1
answer1532
viewsCopy and paste cell when changed
I’m starting to use VBA with the office package, as I still know little I’m having difficulties to get this functionality. I was trying to do something simple and I needed help to understand how it…
-
4
votes1
answer592
viewsHow to take values according to another value?
I want to add the value (and show in any cell) of the Cx cell when Dx equals 1 and add the Cy values when Dy is 2. For example: In the photo, when the value of cell Dx is 1, I want the value of Cx…
-
4
votes2
answers1350
viewsAdd seconds to time - Excel
I have a column with the following values: 945 224 554 487 That would be the seconds I need to add to another column with time, minutes and seconds 12:09:37 23:54:45 10:40:44 11:20:10 I’m doing it…
excelasked 7 years, 5 months ago Gabriel Bernardone 563 -
4
votes1
answer229
viewsCheck the number of copies that have been printed
Hello, I have a table that when printed generates a record in a txt telling the user who printed, on which machine, on which printer, which document was and when. But I would also like to register…
-
4
votes1
answer81
viewsExcel tabs that were saved in html: how to take up
I made a spreadsheet in excel with several tabs and then saved in html because I want to use in my site. The spreadsheet tabs are at the bottom, the site user would have to scroll down to change the…
-
4
votes1
answer10576
viewsSplit text in excel
I have to divide the "Full Name" cells of my table into two. Therefore, I used two functions: "Left" to take the person’s Name and "Right" to take the last name. In which, everything up to the first…
-
4
votes1
answer127
viewsProblem for deletion of data from a spreadsheet
I have the following piece of code that connects to excel, where it will delete the data from a tab of a spreadsheet. private void AtualizarPerformanceEntrega() { try { string sFileXLSX =…
-
4
votes3
answers6016
viewsConvert JSON to EXCEL
I carry out a consultation ajax that returns me a Json with object array, how can I transform this json in excel? Example of my json: [ {idcancelamento: "383", idcliente: "2409", emailcancelamento:…
-
4
votes2
answers897
viewsIs there an Excel function that associates letters with numbers (A = 1, B = 2, C = 3 etc.)?
Is there any Excel function that associates letters to numbers according to alphabetical order (ie, f(A) = 1, f(B) = 2, f(C) = 3 and so on)?
-
4
votes3
answers125
viewsSum of intervals
I needed a formula to calculate values with intervals. I mean, I have several grades: Between 0 and 5 = EUR 0,58; Between 6 and 10 = 0,64; Between 11 and 15 = €1,05; Over 15 = 1,46€. If the number…
excelasked 5 years, 11 months ago Luis Silva 49 -
4
votes1
answer903
viewsC# Read Excel Spreadsheet
Hello, I have 1 problem reading an excel spreadsheet, ListaNomes.Add(new Entidades() { GrupoFornecParceiro = rd["Grupo do Fornec./Parceiro+"].ToString() }); when it goes to Add the value of the…
-
4
votes1
answer2800
viewsMacro to automatically search images and play in excel
Good afternoon, I have a spreadsheet, where I need to automatically include images. I wonder if there is any way to elaborate a macro, where you join the Reference and color (reference & color)…