Questions tagged as 'excel'

Tagged questions
1
answer

How to dynamically create events in VBA?

The code below creates Labels dynamically and now I need to control the mouse action (Click event) on each Label. For example, move the text font (Caption) to bold if you are regular (not blacked out). How to create the "Click" even...
asked by 24.05.2016 / 18:04
3
answers

Count elements between two quantities

I am creating a dashboard demographic for a religious organization, which will include the age group of its members among other data. The enrollment and promotion ages among your religious education classes will be used as criteria. Then...
asked by 13.11.2016 / 20:11
1
answer

Export R data to Excel formatted

Assume a data.frame like this: tabela <- structure(list(vendedor = structure(1:4, .Label = c("A", "B", "C", "D"), class = "factor"), Total = c(3300, 440, 1020, 200)), .Names = c("vendedor", "Total"), row.names = c(NA, -4L), class =...
asked by 23.04.2014 / 02:08
2
answers

HTML table export to excel

I'm trying to export a table in html to file in Excel. This jquery plugin works almost perfectly for me. My problem is with accentuation, which comes to excel with strange characters. Any tips on how to solve?     
asked by 11.03.2014 / 14:32
1
answer

Join data for Mail Merge | Parent and child table

I have a spreadsheet with student data. For each subject of the same student there is a specific line. I would like to do a mail merge with just one email per student, but I would import the data from all the articles. Table: First column has...
asked by 28.04.2015 / 19:47
2
answers

Redeem the largest number of an array with criteria

I need some formula or logic to retrieve the largest number of an array, but with certain criteria. Just like the CONT.SES and SOMASES formulas that counts and adds the numbers of an array when the criteria are met. Something that would wo...
asked by 28.07.2015 / 15:33
1
answer

Difference between hours greater than 24 hours excel

How to calculate difference between hours in Excel when it exceeds 24h? Example: A1 = 05/01/2016 11:40:53 B2 = 06/01/2016 12:29:53 B2-A1 = 24h:49min However, it returns 00:49     
asked by 19.04.2016 / 22:50
1
answer

Import multiple excel tables at the same time

I want to import 27 Excel tables into R without typing the import command 27 times, since table names range from tab101 to tab127 . I tried this way, but got wrong: library(readxl) n = c() for (i in 1:27){ # fazendo um vetor com o...
asked by 13.05.2018 / 03:06
3
answers

How 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 with transcription of numbers, in the txt file I have data in this format: 8,000000 This value should be regarded as 8 (number) by the...
asked by 03.06.2016 / 19:56
1
answer

Make tab name equal to the contents of a cell in Excel

How do I get the tab name equal to the contents of a cell? For example, if cell content A1 is 01 , the tab name is 01 too.     
asked by 15.10.2015 / 00:39