Questions tagged as 'excel'

Tagged questions
2
answers

Split a worksheet into several worksheets

I have a spreadsheet with 5000 rows that needs to be split into spreadsheets with 790 rows at the most. How can I do this ??     
asked by 26.05.2017 / 04:20
1
answer

Excel Formulas doubts [closed]

I have a question and I do not know if there is any function like this. I have this table 96.549 160.914 402.284 643.654 1.045.938 1.609.135 I have a place where a result will appear for example: 1.200.000,00 And I want that tabl...
asked by 15.07.2014 / 16:09
1
answer

Is it possible to edit data in the ListBox? [closed]

Double-clicking the row to be edited from the ListBox opens the UserForm with the data of the selected row. I can not make the changes to be modified in the ListBox and the Spreadsheet. Code when starting the UserForm: Private Sub UserForm_Ini...
asked by 12.07.2016 / 18:52
1
answer

How to extract data from excell to Generate graphs?

I have an excell table with 50 rows and 10 columns, containing data students enrolled in a contest. I have to create graphs from these data. Could anyone suggest a way to extract and work these data in html and javascrit?     
asked by 07.04.2016 / 14:42
1
answer

Error message after opening an Excel file generated by an application

I have an application that reads a xml file, takes the data and passes it to a file in xls format. But when I open the file that was gerardo the following message appears: Would anyone explain the cause of this error?    ...
asked by 24.07.2015 / 13:52
1
answer

What is the logic to calculate the percentage of victory, draw and defeat?

I'm wondering the logic, how to calculate the percentage of tables in a football game. For example, I put here a quick Excel desktop just for demonstration. In red is the actual percentage, and next to it is the percentage that I have a...
asked by 23.08.2017 / 23:39
2
answers

Excel, parse condition in data table

I need to change one column of values in excel according to the condition of another column. For example, review tax brackets and if they are "return sales" you need to change the amount to negative. How to make?     
asked by 30.04.2018 / 17:22
3
answers

Find first value greater than a certain number in Excel

Hello, good evening I would like friends here to help me with this questioning. I have an Excel spreadsheet for calculating steel armatures for concrete structures. By way of calculation, we find value of area of steel per m². From this value...
asked by 15.08.2018 / 01:13
1
answer

How to write a .csv file in Python including file definitions?

How can I create a csv file containing column width information and configured header and stuff like that, is it possible? or can we just write the data without any configuration?     
asked by 24.01.2018 / 14:15
2
answers

USERFORM: I can not remove items from my ListBox (Error 80004005)

I have a ListBox in a UserForm that "rebuilds" based on a TextBox that I use as a filter. The idea is to bring all the items to the list with RowSource and remove all items that do not contain text from the TextBox. However, when testing the sys...
asked by 11.04.2017 / 21:43