Questions tagged [Excel] (940)

Hello! I use Linux and I have a table in the format ODF, which has the support of my LibreOffice Basic macros and previously working in XLSX AND XLSX(a macro in table format XSLM LibreOffice Calc does not want to work). I encounter compatibility issues with ODF in MS Excel macros and Excel Online to work files with working ...

Good day! Would like to know how to implement the following functionality. There is a calculator that after clicking the button is formed, the number is displayed in the table. Roughly speaking there is a table in which there are numbers from 1 to 20 and creates a new number, say 12, and it should appear in the table on 12...

Need a calculation formula of investment: start-up capital is 25 000 per month, for example, added 10% + I add 5000 every month. The entire amount I reinvestiruet. How to make a table for Exel? So calculated the monthly amount. There is a line of Start : 25 000, Yield: 10% DOP.invest: 5000, Balance: is considered the from t...

Hi, Before sberovskaya table for payment of the mortgage in LK was apparently laid out the table tags, and I just took and copied the table and pasted into Excel, do I need manipulation. Now apparently there they have a new coder/web designer (I do not know who), and all tables are now in div. When you paste this table in...

Please help to understand this formula =AMPREISV(INTERMEDIATE.The RESULTS(3;offset(C5, LINE(6:24)-5;))*C6:C24*(C6:C24<50))

Here's the situation. Let's say, copy the 2 selected cells in Excel (one name, different number). If in Excel, click insert, then he realizes that it's 2 different cells and inserts them into 2 cells. Is it possible to implement a button on the page, where the 2 input's and the data will be inserted separately (1 input the...

The bottom line is there is a file exportmezved.php which displays a list of active requests users of the system. <button id="mezved_to_excel" class="btn btn-primary float-right" onclick="location.href='../lib/exporttoexcel/mezvedtoexcel.php'" Clicking on this button in the file mezvedtoexcel.php the formation of the E...

There is a line of text, most of which allegedly contain the names of the people. Is there a tool that can highlight a name from each row? The web terminal application or the macro for Google Sheets / Excel. Example: Anna Kalashnikova → Anna Kovalchuk Julia/Julia Kovalchuk → Julia Maria Bathan ENGLISH TEACHER → Maria SHEI...

There are two related function IMPORTRANGE Google table table 1 and table 2. In table 2 the calculator with data entry In table 1 performs all internal calculations, the results of which are shown in table 2. For example, table 2 I have the access editor, how to get data from all sheets from table 1 ? Which is configured t...

Good evening! Imported all my products using WP All Import. How to combine goods of its base on the supplier's article with its xml? And is there any plugins that show for admin Analytics how many products with photos and without, to hoteltravel only photo that you can hide from the customer all goods which have no descri...