Questions tagged [Excel] (940)

0
answer

How to convert a ODF spreadsheet with macros in Microsoft Excel file with XLSM extension?

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 ...
elton asked April 19th 20 at 12:49
1
answer

How to enter data into the table with sorting?

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...
deondre_Runolfsdottir36 asked April 19th 20 at 12:48
0
answer

How to make a formula in Excel?

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...
mabel30 asked April 19th 20 at 12:37
1
answer

Div as table to copy to Excel?

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...
davin.Jones70 asked April 19th 20 at 12:37
1
answer

How to understand formula in MS Excel?

Please help to understand this formula =AMPREISV(INTERMEDIATE.The RESULTS(3;offset(C5, LINE(6:24)-5;))*C6:C24*(C6:C24<50))
Savannah_Grady43 asked April 19th 20 at 12:21
2
answers

How to get data from the clipboard when copying cells in Excel?

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...
Claudi asked April 19th 20 at 12:16
1
answer

Download the data in EXCEL: PHP and PhpSpreadsheet — why does not work the first time?

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...
Darien_Ja asked April 19th 20 at 12:07
1
answer

With the help of which to distinguish people's names from the flow of the text?

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...
Daphney_Carroll asked April 19th 20 at 12:05
1
answer

Pull data from one of two related IMPORTRANGE Google sheets?

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...
Verla68 asked April 19th 20 at 12:01
1
answer

How to link database items with database suppliers in Woocommerce?

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...
Hector_Witti asked April 18th 20 at 13:39