Questions tagged as 'excel'

Tagged questions
0
answers

For Each In .Shapes GROUP control for excel [closed]

wave I would like to make a For Each In. Shapes "those shapes" but they grouped I managed to assemble with them ungrouped but grouped it looks like the procedures are different What I got so far, is a little incomplete because it messed up the...
asked by 17.08.2017 / 04:41
0
answers

Line break in Excel (2013) via formula

How to make formula break in Excel 2013 (above)? I used to do this: ="linha1"&CARACT(13)&CARACT(10)&"linha2" Current result: linha1linha2 Expected result: linha1 linha2 Theoretically only CARACT(10) already r...
asked by 10.07.2017 / 17:23
0
answers

Replace values in STATA with a list already defined? [closed]

I would like to replace values using a list of values defined in another column. Something similar to Excel procv. I think I can do this using a loop, but I can not mount it. Anyone have any directions?     
asked by 07.07.2017 / 06:41
1
answer

Excel Automation

I need some way to automate a recurring job in my company: I automatically want to get tables generated in Excel, extracting information from it is writing to a new table. Since new tables will always be generated to do these calculations, then...
asked by 18.07.2017 / 16:38
0
answers

Wrong value when using SOMAR.SE using a cell as criterion

I'm having trouble applying the SOMAR.SE.S formula. In the image the sums in column N use the following formula (N4): =SOMA.SE($E$2:$E$4465;">=5,48";$C$2:$C$4465)-SOMA.SE($E$2:$E$4465;">5,52";$C$2:$C$4465) These formulas the criteria...
asked by 29.06.2017 / 12:07
2
answers

Automatically fill cells in excel using VBA

Good afternoon community, I am trying to work with VBA in Excel to try to apply this knowledge in my master's thesis, but I have some questions. I'm trying to create a function in VBA that populates cells by a given value. In the next imag...
asked by 13.07.2017 / 19:41
2
answers

Values Table Search in excel

Hello! I'm doing a cost table for my company and I'm having to do a search on a table of values, but the only way I currently know how to do it is through multiple threaded SEs, which will give a lot of work, time and it will generate an incr...
asked by 23.06.2017 / 22:58
2
answers

Apply conditional formatting individually to each row in the worksheet

I have a worksheet with dates and cities. I need to highlight (paint some color) cities that are repeated on the same date I can apply conditional formatting to this, but doing one line at a time takes a lot of time. Any tips?     
asked by 08.06.2017 / 21:29
0
answers

Function to export table in html and php to Excel

The function really works in Chrome, but I'm having a problem making it work in IE and Firefox and I need to export in Excel to those two browsers for a project. What changes would you require? I already tried using ExecCommand for IE and...
asked by 21.06.2017 / 15:23
1
answer

Excel validation list - runtime error 1004 - Application definition or object definition error

The deal is like this: I have a vector that contains the items for a dropdown list in excel. The code just below creates hanging lists in cells d5 through d108 in 12 tabs of the month vector. The expense vector contains the items for this drop-d...
asked by 18.04.2017 / 18:54