Questions tagged as 'excel'

Tagged questions
2
answers

Add seconds per hour - Excel

I have a column with the following values: 945 224 554 487 This would be the seconds that I need to add to another column with hour, minutes, and seconds 12:09:37 23:54:45 10:40:44 11:20:10 I'm doing it as follows I get a value in s...
asked by 29.06.2017 / 14:52
2
answers

Handle worksheet with userform loaded (excel vba)?

When we have userform loaded, can you change / browse in spreadsheets of excel ?     
asked by 22.03.2017 / 23:47
2
answers

SE Function Nested?

I would like to know how to nest the function SE as follows:    Se G6 for >=20 e <=30 então 100, Se G6 >30 e <=40 então 200, Se G6 >40 e <=50 então 300, Se G6 >50 e <=60 então 400 How to mount this fu...
asked by 23.01.2017 / 15:09
1
answer

How to modify VBA function to write extensively a number greater than 1 trillion in EXCEL cell?

In 2013 a user submitted a question about how to spell out a number stored in an EXCEL cell. One of the answers contained a VBA function that had already been published by UOL for some time. I consider one of the best functions already developed...
asked by 19.10.2015 / 12:11
2
answers

Find equal ranges in a list

I am a beginner user and have tried almost everything but I have not been able to resolve the issue and would like to know if anyone could help me. In a column I have numerical values and would like to compare the ranges of four cells "A2: A5...
asked by 02.10.2016 / 20:31
1
answer

Values within a given range

I want to make the following formula but I can not. I do not know if it is with =SE() , but what I need to know is whether a value is within a range (1 to 2) or not. =SE(A1<=B1>=C1;1;0) If cell A1 is less than or equal to cell B...
asked by 18.08.2015 / 16:50
1
answer

Use sheet name extracted from a cell

I am creating a workbook in excel that will serve as a template for many others that will be generated through it. This template workbook has 5 spreadsheets, and one of them can be replicated several times with several different names such as...
asked by 17.10.2014 / 14:32
1
answer

macro to copy and paste

I have data in the "M" column, which are automatically entered in an average of 70 rows per month, only have empty cell ranges (the 12 months of the year are in column "M"). So I wanted to copy this data per month, to column "N", automaticall...
asked by 26.01.2016 / 12:26
1
answer

How to format a cell from the RGB code contained in the cell itself

Is it possible to change the background color of a cell from a code RGB or hexadecimal written as text in the cell itself? Let's say I write 255,0,0 in célula A1 and when I press enter the bottom of the cell ch...
asked by 02.11.2016 / 17:18
3
answers

Convert JSON to EXCEL

I have a ajax query that returns a Json with an array of objects, how can I turn this json into excel? My json example: [ {idcancelamento: "383", idcliente: "2409", emailcancelamento: "1", financeiro: "1", suporte: "1"}, {idcancela...
asked by 23.10.2017 / 19:19