Questions tagged [Excel] (940)

2
answers

As the table to bring the red?

Hello guys, well who knows excel? As the table to bring the red? There is a table of the goods there are prices in the plus and minus - that we must all minus withdraw on a separate sheet. Well what if sheet 1 and row 5 was cut out and transferred on a separate sheet, and if 100 sheets 200 lines - will not do every line cut...
donato_Waelc asked April 7th 20 at 16:27
2
answers

As in EXEL to keep only duplicates?

Dear men! Tell me, please, lady, how in EXCEL to find the duplicates and leave only them? And everything else to remove? And ka to be prepared for such magic to the table if the right table cell includes two cells from the table on the left.
zaria_Nitzsche asked April 7th 20 at 15:39
1
answer

How to do that with conditional formatting, wideslash date when there are less than 2 months from the current date?

Welcome! Help to understand!How to apply condition formatting to change the cell color if the current date until the specified cell is less than 2 months(applies less than 60 days). Found usually where the formatting is applied if there are less than Mecca(date - next month )
Lilyan_Jaco asked April 7th 20 at 15:33
1
answer

How to combine several excel files into one on Mac OS?

How you can quickly merge excel files from one folder into a single file (or open the video in a single table)? In windows versions this was done in a couple of clicks, and there is no such)) PS. The values of the columns in the tables are the same, but with different contents, that's all you need in a pile for further pr...
Torey.OKon asked April 7th 20 at 11:43
1
answer

How to calculate the coefficient of thermal expansion in % in Excel?

There is an example, trying to make a formula out of it, I can not understand the solution process. 1. A steel is 40 cm long at 20 oC. The coefficient of linear expansion for steel is 12 x 10-6 (Co)-1. The increase in length and the final length when it is at 70 oC will be... Known : The change in temperature (ΔT) = 70oC ...
zakary.Windler asked April 7th 20 at 11:31
1
answer

How to send hyperlink in PowerPoint on certain tabs in Excel?

How to send hyperlink in PowerPoint on certain tabs in Excel?
hans.Parker asked April 7th 20 at 11:11
2
answers

How to write data in Excel file in PHP?

There are 3 variables: $id = $names_new[$j][0]; $old = $names_new[$j][1]; $new = $names_old[$i][1]; You need to record them in an Excel file line by line: A B C $id $old $new I tried this: $id = $names_new[$j][0]; $old = $names_new[$j][1]; $new = $names_old[$i][1]; $tofile = $id . ';' . $old . ';' . $new . "\n"; $bom = "\...
sherwood asked April 7th 20 at 10:07
1
answer

How to download data in excel from the parser by columns?

Wrote a simple parser that takes data about plugins with Wordpress. Everything works stable, but when you export this data into a csv file, each entry of the plugin is written in one cell separated by a comma, when it should all sign strings. That is the name in one cell, the url to the right of it, the number to the right ...
Coty.Leusch asked April 7th 20 at 10:05
0
answer

How to konverterat vCard file (vcf) into Excel format (xls)?

There is a need to export contacts from a Yandex Mail (vCard, extension. vcf) and to convert the file to Excel format. Not one of the available online converters did not give acceptable result (within some kind of meat i.e. the lack of columns and rows as such, lack of Cyrillic, etc.). Using csv as intermediate format gave ...
Lew asked April 7th 20 at 10:03
1
answer

Is there something better than Excel for plotting?

Sometimes there is a need to build charts on the samples from the database. There is something more sharpened by these tasks with less cluttered interface than Excel? Interested in not just having beautiful graphics, but minimal analytical\aggregate functions
Kenya_Reichert asked April 7th 20 at 10:02