Questions tagged as 'excel'

Tagged questions
1
answer

How to Compare More Than One Data Between Two Sheets and Add That Data Based on One Condition

I have two spreadsheets, they have basically the same data, but they are not 100% equal. I need to get the client's Id (column A) on worksheet1 and check on the line where it exists on worksheet2 (column A), if the Item (column k) of that cli...
asked by 05.05.2017 / 15:55
1
answer

Time 0 with negative sign

I have an excel spreadsheet which I changed the date system to 1904 to be able to display negative hours. The problem is that it often happens that -00: 00 values appear when I subtract timings. What I have analyzed is because the date is 0...
asked by 21.08.2018 / 22:16
2
answers

EXCEL FUNCTIONS TO COMPARE VALUES

I have a hidden macro with some values in several columns. In my main tab and visible to the user, I want to compare if the value of cell J2 of the Macro is greater than 4, if it is greater, in my main tab in cell J10 show "APPROVED", if smaller...
asked by 08.06.2016 / 13:35
1
answer

EXCEL. "Right" function how to set an automatic size for distinct cells that exceeds the number of defined characters

I used the right function in cell "L33" but when I clicked and drag the values defined in the first cell, cell "L34" displayed not only the word 'technologies' but rather the word 'software' and in followed by the word 'technologies'. How do...
asked by 10.10.2018 / 20:42
1
answer

report excel filter [closed]

I'm trying to make a report but I need a help for the worksheet to have to search by date and paste in another worksheet the data of that same date (example in the line that has today's date copy all of today and paste in the other worksheet). H...
asked by 25.07.2018 / 23:22
2
answers

Separate fixed headphones from furniture to add ninth digit

I have a spreadsheet with almost 60 thousand lines, with 3 columns: Contact Us | Phone 1 | Phone 2 In both handset columns I have fixed and mobile numbers and for me the logic is simple: Fixed handset is a number that is less than 8 digits. I...
asked by 11.12.2017 / 16:02
2
answers

Standardize worksheets in open office [closed]

I have an open office spreadsheet file with 27 spreadsheets inside. All spreadsheets are the same, 3 columns, title, nothing more. I need a way to format all spreadsheets one at a time. - line width - color of the headers - width of columns...
asked by 16.08.2017 / 17:20
1
answer

Best way to work with XLS and XLSX files

What is the best way to work with Excel spreadsheets, XLS and XLSX in C #? I need to perform cell reads according to the column name, which is specified in the first row. Here is an example below: Note: Inside the XLS or XLSX file...
asked by 26.11.2014 / 19:54
1
answer

Problems with .jar generated with jxl library [duplicate]

Hello! I am having problem in the generated .jar file of a project. In this project is included a library, called jxl responsible for reading and writing .xls files, but it is returning the following error when clicking a button that calls a t...
asked by 18.11.2018 / 17:27
1
answer

Excel VBA Advanced Filter Problem

I made a program in VBA to calculate the cost in my company. For this I used two connections to the Oracle database. What's strange is the fact that when I try to use the advanced filter manually, it works. However, when I try to use VBA (record...
asked by 27.02.2018 / 21:19