Questions tagged [Excel] (940)

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...

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.

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 )

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...

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 ...

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

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 = "\...

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 ...

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 ...

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