Questions tagged as 'excel'

Tagged questions
1
answer

Formatting to change Color and Status depending on Conditional of another cell [closed]

VALOR= A/B 0 1 PERIGOSO 2 3 POBRE IA= A (400)/ 3 4 QUESTIONÁVEL 70 5 6 CONFIÁVEL 5,71 7 8 BOM > 9 EXCELENTE I want to automate a worksheet to get the re...
asked by 31.10.2017 / 19:40
1
answer

IF Condition - Display or Hide TextBox

Expensive, I have 4 optionButton (2 different groups), where 2 represent "Yes" and "No" for two different questions. What I want to do: When the user chooses the NO option in group1 and then chooses the YES option in group2, a textbox i...
asked by 06.11.2017 / 11:01
3
answers

How to add character after the last word written on the line

Dear Community, I have a doubt that I have tried everything, but I can not solve it. I have a list of ex names; José Mario da Silva Mariana Cristina William Caio Jorge Luiz Campos de Silva Andrade In case there are more than 2,000 nam...
asked by 29.09.2017 / 18:05
1
answer

How to write data from an excel to an xml file

I would like to develop a program that has to read excel files and write to an xml file but I'm not sure how to write the data to the xml file. I'm reading the excel file like this: var fileName = @"C:\Users\HP8200\Desktop\test.xlsx"; var c...
asked by 27.09.2017 / 17:07
1
answer

How to format data extracted from datagridview to excel

private void button1_Click_1(object sender, EventArgs e) { Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel._Workbook workbook = app.Workboo...
asked by 26.10.2017 / 20:07
1
answer

PROCV Excel - Connection Usage

Is it possible to use connections with other worksheets in a PROCV? Ex: I added a connection to another worksheet that I use. There are columns in it. Can I apply a PROCV or some other formula to consume data?     
asked by 25.09.2017 / 22:12
1
answer

Fill in the formula horizontally but increment the cell references vertically

I need to fill a table with horizontally referring to values that are vertical of another table In the horizontal table I'm doing the following ='Tab 3x3'!G10 But when I drag to the side it increments the column, not the cell. It would n...
asked by 29.08.2017 / 16:01
1
answer

Problem with drop-down list in cascade

Contextualization I am trying to create a drop-down list for cells in the Model column, which depends on the value of the corresponding cell in the Manufacturer column. TheabovetableisonthePlan2tabInthefilethereisatabwiththerelationofmanufac...
asked by 27.08.2017 / 02:01
1
answer

Does Excel include columns alone from a range?

Hello, I'm new here, but I have a problem with excel. I need to make a table that includes columns with a number from the name. In the base table the user will fill in the name of the person and his / her punctuation, and it is necessary that in...
asked by 21.07.2017 / 15:12
1
answer

Count values if values in two columns of the same row are specified

I have two tables in excel, Suppliers and History: I need to count how many times provider A has committed error A, provider A has committed error B ... and so on, I thought about putting something together with CONT.SES, but the value...
asked by 20.06.2017 / 19:20