Questions tagged as 'excel-2013'

1
answer

Problem subtracting dates in excel

I have a problem wanting to make a difference between two dates to know the days between them. These on the one hand 3/15/17 17:58 3/15/17 17:57 3/15/17 17:55 and on the other 2017-03-29 00:05:49 UTC 2017-06-15 00:40:49 UTC 2017-03-15 01:...
asked by 10.01.2018 / 05:55
1
answer

Run a macro from a .bat

I wanted to know if it is possible to run a macro in Excel from a .bat file since I can not find a way to do it. The macro that I own works correctly but I need it to run when I run the .bat I would appreciate it if you know something,...
asked by 18.12.2018 / 17:43
1
answer

Filters with Excel Macro

I hope you can help me with the following. I have a sheet in Excel, in which I need to make certain types of filters. Criterion 1: Column A; It contains dates and I need to filter the most recent date. The date is in this form "Month and D...
asked by 18.09.2018 / 21:56
1
answer

Bring data that depends on two columns

I have the following information: _____A___ _|______B_______|_______C_____ 1 | CODIGO | CONCEPTO | VALOR 2 | 111222 | con1 | 12000 3 | 111222 | con2 | 11000 4 | 111222 | con3 | 5000 5...
asked by 26.04.2018 / 01:14
0
answers

Data validation (Lists) in VBA

I put them a bit in context. As an example: I have a table with data and in column A there are a number of countries but in some cells those countries can come empty (and the entry of data must be filled with a list validation) and in column...
asked by 28.03.2018 / 17:44
0
answers

How to activate the paragraph marks in Excel 2013 to visualize the end of the CRLF line in a * .csv file?

I need to activate the paragraph marks in Excel 2013, in word I already identify how to do it, adding this functionality to the ribbon. But in Excel I did not show the option Display (Display) to be able to activate the visualization. Could some...
asked by 04.10.2017 / 23:26