excel

There is a source table, there are columns id | приз | место | статус пользователя In this source table, the id can be dup ... льзователя 1000 | без статуса From which we can conclude that LOOKUP returns an invalid value. But I can't figure out why.

If you do not go into details, you come across files .xlsx which are named as .xls and vice versa, .xls that are named as .xl ... s and rename them correctly, but I did not find how to determine the file format without relying on the extension in its name

Let's say I have a table with the columns 'car brand', 'car model', 'quantity'. I build two charts from this data. One shows ... wo duplicates of 'Nisan'. How do I make it so that there are three sectors in this diagram and they correspond to the brands?

Hello everyone The question is: how can I save it in PDF format via Excel? Or maybe another way to somehow convert? Here is t ... s://docs.microsoft.com/en-us/office/vba/api/ex ... SaveAsFixedFormat fails. How is it correct to write a save to PDF? Thanks!

I'm trying to read the file .xls obtained from the internet using requests to later turn it into an array or list of dictiona ... still save the file. In general, now the question is how to feed the xld type bytes to the library so that it sees it .xls?

An array of full names is set. You need to determine the gender of each person by the last vowel letter. Here is the code, it ... If gls = g Then Cells(a, 3) = "жен" Else Cells(a, 3) = "муж" End If Next a End Sub How to fix it?

The task is: after the script written in Python generates an xlsx file, send it to print. How can I do this using Python or u ... it is only for Unix-like systems. I am interested in the features for Windows and Linux (you can do it separately for each).

There is a table obtained from the program, a huge array, where the date and hour are specified (several rows are issued in o ... w do I explain to vlookup that you only need to view the range for a specific date and hour? https://yadi.sk/i/8_-xzdX0h6Pzgg

There was a need to automatically convert CSV files to Excel files, but so that the appropriate column width is automatically ... ers", the column width adapted to the data width or the width of the column name, and freezing the row with the column names?

Please tell me how for Excel VBA should look like a regular expression to select from the text of the form 12345.12345TEXT123 ... (text) But it seems that I do not understand anything in regular expressions at all : (because it finds only the full string

There are several large libraries for working with Python 3.9.0 Excel files, which at first glance have similar functionality ... and adding data to the table. In the future, we plan to work with formulas in tables, as well as work with the .csv format.

I'm new to the forum, don't know if I can ask a question on Excel here? In general, I have a large list of surnames and numb ... 5 in the third. And also change the font of the numbers at these intervals. How do I do this? Please help me. P.S. Excel 2003

Good afternoon! In delphi 7, there were good components for working with Excel and Word. Where did these components disappear in the new versions of delphi of the XE line? Where to get them, how to install them to work with them?

Until recently, I worked with the FastReport version 2015.4.0.0. I used just the \n character for line wrapping. In the new p ... .4.16.0 and this method does not work with it. Instead of hyphenation, the ASCII sequence _x000A_ is inserted. How to fix it?

How can I collect several criteria in one condition? =ПОИСК("слово1"; $A1) So that there are also words here: word2, word3, etc. So as not to break several rules. I would like to see something like =ПОИСК("слово1","слово2"...; $A1)

Please tell me how to make a formula for fulfilling the condition: if the cell value is greater than 10 of the cell value above and below the original one, then the result is A, otherwise-D

There is a macro that gets values from a closed book (formally, it opens it using Workbooks.open(), disables events/alerts Ap ... open the second instance of this book, read the necessary data and close it, so as not to touch the instances opened before?

There is the following task: Column A contains several thousand numbers. It is necessary to enter the sum of ten cells of co ... 1:A20) B3 = СУММ(A21:A30) , etc. Can you tell me if this can be done by a formula in the table itself, and not by a macro?

Importing data from sql to excel. The sql cell contains text with a tab. When you import data into excel, the data is not in ... that data is inserted into a single cell, regardless of the number of line breaks and the amount of text in the source cell.

1st column - a list with duplicate values (text). 2nd column - values (numbers). 3rd column - desired values. Is it possib ... di.sk/i/7ksyS2FjrER75A ААА 0 1 ААА 4 1 ААА 0 1 БББ 0 0 БББ 0 0 ССС 0 3 ССС 1 3 ССС 3 3 ССС 0 3 ССС 1 3