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
votes0
answers99
viewsHow to use the same supplement . xla on two machines on the same spreadsheet?
I created a file with functions in VBA . xla that can be configured as excel add-on, but after using the functions in a spreadsheet any on my machine and sending the spreadsheet to someone else she…
-
2
votes1
answer113
viewsSum seconds, minutes and/or hours in field date time
I have a field with date and time in Excel (column F) and I would like to sum seconds, minutes and/or hours, but the form used, as in the image example below, sums the value in days (column G): How…
-
2
votes1
answer129
viewsApache POI - How to put Hyperlink in an image in Excel?
This is the method I use to put images in Excel: public void insertIcons(String URL, Sheet sheet, int colBegin, int colEnd, int rowBegin, int rowEnd) { try { InputStream iconInput = new…
-
2
votes1
answer8581
viewsWhat are the differences between Power Query, Power Pivot, Power BI?
I want to make a contribution to the community by presenting these free tools for data analysis using Microsoft and, unfortunately, they are little known and exploited by many and can be very useful…
-
2
votes1
answer371
viewsSelect columns with no specific name
I am developing a C# application that consumes data from a spreadsheet and at some point I need a query string that will feed a variable. For example: strComando1 = "SELECT TOP 2 ColunaGenerica1,…
-
2
votes1
answer50
viewsDoubt in VBA Excel 2013
I have this bit of code: Range("F8").Select For Each m In Range(Range("C8"), Range("C" & rows.Count).End(xlUp)) If ActiveCell.Offset(0, 0) <> " " Then ActiveCell.Offset(0, 7) =…
-
2
votes0
answers57
viewsFormula Optimization
Could you help me find a way to optimize the formula below? The spreadsheet has more than 125 thousand lines with this formula in a 4 columns and is generating a lot of slowness to process the…
-
2
votes2
answers218
viewsHow to add only the highest values of a numerical sequence in Excel?
I want to add only the values greater than '600' of this numerical sequence, I tried to use =SOMASE(B51:B60;>600;B51:B60), but it didn’t work! right after inserting the (>)major symbol, it…
excelasked 5 years, 10 months ago Elienay Junior 527 -
2
votes1
answer974
viewsVBA code to insert images in excel cannot recognize images that have letters and special characters in the image name
I use the following VBA code to take images from a folder and insert them into a spreadsheet, but the VBA code cannot recognize images that have letters and special characters in the image name,…
-
2
votes1
answer129
viewsReturn in a Dataframe - Python
Good afternoon. I have a question about Python. I have an if where he has the conditional and Else, the Else he processes more than one file and I need to save all the information he reads inside a…
-
2
votes3
answers1380
viewsExcel (VBA) - Copy data from files
I’m trying to gather data from multiple files into a single spreadsheet. In some researches I did through the network, I found several suggestions, and below this the code I found and met the need.…
-
2
votes0
answers81
viewsHow to paste an excel list to android studio and get organized with break lines?
List in excel Relacionar o item Cidade Relacionar o item Afonso Bezerra Alexandria Alexandria Almino Afonso Alto do Rodrigues Angicos Angicos Apodi Apodi How to do this in xml? Because as a long…
-
2
votes1
answer13169
viewsMerge data from different tabs into one in Excel
I have 18 spreadsheets (tabs) with user data and I need to copy and paste the data into another spreadsheet (tab) of in the consolidated name. I need to copy the header only from the first sheet and…
-
2
votes1
answer1378
viewsFilter dynamic table by Listbox
Private Sub Preencher().. From this publication here Filter dynamic table by word in a cell ... It is very efficient in searching column A .... I would like to take the values that are in Listbox…
-
2
votes1
answer116
viewsHow to group data and list in another excel table
Hello. I have a shopping list with several records and wanted to create a list/table next to it that contained the place of purchase and ahead of the total amount spent in this store. follows below…
excelasked 6 years, 4 months ago Miguel Pinto 31 -
2
votes4
answers13312
viewsFind first value greater than a certain number in Excel
Hello, good night I wish my friends here could help me with this question. I have an Excel spreadsheet for calculation of steel reinforcements for concrete structures. By calculation, I find a value…
excelasked 6 years, 3 months ago allanglayd 41 -
2
votes1
answer573
viewsExport HTML table to Excel
I have this PHP page that lists all my records, I’m trying to export it to Excel, but all the records come out in just one column. <?php require_once $_SERVER['DOCUMENT_ROOT'] .…
-
2
votes1
answer48
viewsVBA Before Close
So what I want to do is have a message box that pops up when this Powerpoint file tries to close, saying "Did you send the data?" " Yes or no". If you click "Yes", Excel closes, if you click "No",…
-
2
votes2
answers62
viewsPerform a previous values calculation in column on R
I would like to assemble a column according to the result of 2 lines of another column, follows the formula below, I have no idea how to assemble this in R or Python and would like a collaboration…
-
2
votes1
answer29
viewsCompare two columns in excel and create the third
I need to compare the Column A item with all items in column B, if this item is not present in column B, it is generated in column C. What formula do I need to use to do this?…
-
2
votes4
answers931
viewsPython columns excel csv
I made this number generator that gets saved in a csv file that I open in excel, the combinations are generated in column A but n want it to appear in A. as I do for her to appear in column B and C?…
-
2
votes1
answer1393
viewsReturning value via VBA
I created a database in Excel that should accept only 1 CPF. So I created the following function that checks and prevents repeated entries from being entered. Function verifica_cpf(cpf As Integer)…
-
2
votes1
answer179
viewsHow to change not only the style but the cell format with C# using NPOI?
when I file in Excel using the library NPOI (https://github.com/tonyqus/npoi/tree/master/examples/xssf) I can change the style of the cell to moneyFormat with the following code, however, when the…
-
2
votes1
answer1307
viewsVBA, create a macro so that I can compare two lists of names?
I’m having trouble creating a macro that can check the equality between each cell of a list and, if both are different, leave a blank line above the cell. For example: TO THE B C C D D AND AND F G H…
-
2
votes2
answers361
viewsExport large amount of data to Excel
I have a DataGridView where in it there is an average of about 50 thousand lines where these should be exported to an Excel file. But because of the huge amount of data the application simply…
-
2
votes1
answer137
viewsHow can I decrease the running time in my application in VBA
Hello, I am developing an application in VBA that is responsible for searching in an excel spreadsheet 2 data in different columns: the serial number, and the beginning of manufacturing. Then, I…
-
2
votes1
answer178
viewsPython with excel (Openpyxl) - take the result of the formula instead of the formula itself
Hey, guys, what’s up? First time around. I have a spreadsheet in excel with several formulas, and I wanted my python code to take for me only the result of these formulas, and not the formula…
-
1
votes1
answer4482
viewsPersonalised registration form
I came across the need to create a page with a "simple" but complex form in its structure (I believe). What I need to do, is that when creating a wordpress post, where the created POST has a unique…
-
1
votes1
answer616
viewsOpen Excel file in BINARY_SAFE
I would like to open an existing XLS spreadsheet in PHP, insert data into columns, save and close the file. Is there any function or API for this type of treatment, which opens the file in…
-
1
votes1
answer135
viewsPerform UNPIVOT in Excel to import in Access
I have a table with the following format: As the first column and the first row are code fields, I need it to be in the following format, for import in MS Access: It is possible to do it manually,…
excelasked 10 years, 7 months ago Felipe Deguchi 181 -
1
votes1
answer1281
viewsCreate dynamic columns depending on a checkbox - excel 2007
I have a simple table with 4 values and a checkbox for each of them: Sellers: | John | Antonio | Paulo | Carlos On another excel sheet, I have a table where I can add rows, and where each row has…
-
1
votes1
answer21796
viewsExcel Make list and fetch values
I have a little doubt when making an excel file. In my excel I have a page (Leaf 1) with tables and various values. I wonder if it is possible to make a list in "Folha2" and when choosing an option…
excelasked 10 years, 4 months ago ChrisAdler 1 -
1
votes1
answer276
viewsConditional Excel formatting
I have a question and I’d like to know if it’s possible since I’m not getting it. I have a cell that shows me a result (D4 cell) And I want the result to underline two lines. Example: If cell D4…
excelasked 10 years, 4 months ago ChrisAdler 1 -
1
votes1
answer95
viewsExcel Formulas doubts
I’m in doubt and I don’t know if there’s any function like that. I have this table 96.549 160.914 402.284 643.654 1.045.938 1.609.135 and I have a place where I will see a result for example:…
excelasked 10 years, 4 months ago ChrisAdler 1 -
1
votes1
answer895
viewsRead more than one file tab
My code goes through all cells in my spreadsheet and returns all the values I need, and in this.xls file there is only one tab. Now I have a new file to go through and are 8 tabs. I know I need to…
-
1
votes1
answer1135
viewsCreate XML with Excel, date field formatting problem
I have an Excel spreadsheet, generated by SAP with a date field. I need to convert this spreadsheet to XML. I do the XML mapping by Excel, but I cannot make it export the date field as a date,…
-
1
votes1
answer706
viewsHow to pass data from a Dataset to an Excel spreadsheet C#?
I read sheet by sheet from a flat, and stored in a Dataset. I’m having trouble passing on to another flat this data from Dataset. Can someone help me ? I have the second code: conn.Open(); string…
-
1
votes0
answers56
viewsContact page Filled in via Excel
I’m creating a website and I’d like to know if what I want is possible. I have a page that contains contacts <tr> <td>Teste - 123456789</td> <td>Teste - 987456123</td>…
-
1
votes1
answer746
viewsInsert excel column in a table in Mysql
I have a mysql table(has 600 records): The column duvet is a column that will be extracted from an excel cell, (Mysql for Excel), doesn’t have the update option to just add and when I add the cell…
-
1
votes1
answer57
viewsConvert currency formats EUR->USA and USA->EUR in Excel
My problem: Convert a Range Excel with currency format (USD) to (EUR) and vice versa. Format USD 123,456,789.00 Format EUR 123 456 789,00 I tried to encode a replacement in VBA but I am a beginner…
-
1
votes0
answers92
viewsSave data in excel file through Outlook
I created a Rule, that every time an email arrives with a certain text on Subject executes a scrip, which has the function of going through the entire email and storing certain data in an Excel…
-
1
votes1
answer527
viewsManual filter via VBA with last available values
I need to filter, via VBA, the 30 last values available in a dynamic table but in the "manual filter" that is the line... It is possible to read, in VB, the values available in the "manual filter"?…
-
1
votes1
answer1824
viewsHow to change data from a chart dynamically (DESLOC + RANGE NAME)?
I’m trying to create a dynamic graph where a combo changes the chart type. I actually created a name where I added an offset formula that not only changes the range height but also varies the…
-
1
votes1
answer296
viewsHow to use Autofit in C#?
I am exporting data to an Excel spreadsheet and am unable to use Autofit, someone could help me? Code: public void exportarExcel(InformacaoDB info, string nomeArquivo) {…
-
1
votes1
answer398
viewsFormula Excel Custom List
Hello, I’m creating a spreadsheet and I have a problem. Imagine there’s a tournament going on. To control this tournament I have several tabs, January, February, March, etc.. Within each tab I have…
excelasked 9 years, 10 months ago Andy Schmitt 241 -
1
votes1
answer618
viewsHow to correctly export footer with Xtensions primefaces
Use JSF 2.2 and Primefaces 5.0 Using the Extensions primefaces to export, in a single excel file, three tables of a system, I’m having problems with the exported information: The table footer with…
-
1
votes2
answers1236
viewsVBA for directory search and concatenating filenames
I need to evolve the following code to do the concatenation of data in a certain way. I have a folder with photos of products, (several photos for each product) and I want Excel to do a search by…
-
1
votes2
answers1065
viewsVBA Control of hours/employees
I’ve been trying for days to learn the commands in VBA to automate a company’s employee hours control spreadsheet. I have a sheet with the names of the employees and a calendar as follows: horas…
-
1
votes3
answers11806
viewsCopy from a filtered sheet in excel vba
I’m having a problem, I need to extract a list of excel data that I Filtreed with over 200,000 lines, i have the option to make excel analyze each line and delete it but I wanted to do this without…
-
1
votes1
answer809
viewsError message after opening Excel file generated by an application
I have an application that reads a file xml, takes the data and passes to a file in the format xls. But when I open the file that was Erardo appears the following message: Would someone explain to…