Questions tagged as 'excel'

Tagged questions
2
answers

Logic with date in excel

People, I am developing a spreadsheet to better control the production of the factory in which I work, I do not understand much of excel and I am with a doubt that it might be simple to solve. Next, I have 35 machines available for production, a...
asked by 31.05.2015 / 23:33
1
answer

cont.se does not work in Excel

I have a column in Excel with 38 rows. Inside them are two words: Yellow and White , I want to count how many times these words have been entered. I used the following formula: =cont.se(A1:A38;"Branca") But it did not work, what's wrong?...
asked by 27.01.2015 / 02:53
1
answer

How to copy and paste as an image with VBA?

I need to copy a graphic and paste it as an image on the same worksheet. I'm trying to select the range that contemplates any special graphics and paste as a Bitmap or Enchanced file. Here is the code: Range("AM18:BE22").Select Selection...
asked by 03.11.2017 / 17:43
1
answer

Excel spreadsheet with unreadable cells while filtering

I'm creating a spreadsheet of Excel using phpExcel() . When placing filters, the result of cell C3 and C4 where subtotal SUBTOTAL() is found looks like this: No filter WithFIltro Does anyone know why...
asked by 22.02.2017 / 18:57
1
answer

Data Validation

I am creating a database file and have a data validation where the template matches the respective tag. I'vedoneadatatypevalidationlistfromthetable: Withthefollowingformula:  =SE(F6=$Q$5;$Q$6:$Q$8;SE(F6=$R$5;$R$6:$R$7;SE(F6=$S$5;$S$6:$S$7)))...
asked by 12.09.2018 / 11:05
0
answers

Increase the source of the list in Data Validation

Hello, I have a field in my spreadsheet that has a list of data validation, I would like to know how to increase this font, making it more visible. NOTE: Without the zoom scheme. Here is the list:     
asked by 27.06.2017 / 16:00
3
answers

what formula do I do for ranges of values in excel?

I need a formula in excel that identifies ranges, ex 0-30 = 20% 31-60 = 98,5% 61-90 = 100% 91-120 = 101,5% If f2<= 30 inform 20%; if f2>30 and <60 inform 98,5% , etc. How do I do it?     
asked by 07.02.2018 / 03:08
0
answers

Import Internet Table For Excel

Is it possible to import the following table into this site for excel using VBA? The path is as follows: link 1-) Click complete list 2-) Click on (one business day) I tried to use Excel's New Web Query tool but apparently for this...
asked by 23.03.2016 / 13:54
0
answers

Uploading excel (.xlsx) with jsp

I'm developing an application to submit Excel files to an application. However if I try to submit a file .txt , it works correctly, if I send a file .xlsx the copied file to the server directory appears empty. I'm using lib: co...
asked by 20.06.2016 / 16:26
0
answers

Better logic for manipulating spreadsheets

Good afternoon dear, I have a project in hand where I have four worksheets, one of each "computer station management program" in which, in all of them, I have a column with the patrimony number of the machine. p> The vast majority of machines...
asked by 16.07.2015 / 21:10