Помогнете ми да споделя тази колекция
|Conditional formating - Nested IFs |
|IF(condition1, result1, IF(condition2, result2, IF(condition3, result3, result4)))|
|Conditional formating - If cell contains text then copy/paste text from a different cell |
|If there is any text in J5 then I want the text from J3 to appear in I5. And if there is numbers? Is it not just to check if the cell is empty? Why not =IF(J5="",J3,J5)|
|How to find the first weekday of the month in Excel |
|Source: https://www.intheblack.com/articles/2015/01/29/find-the-first-weekday-of-the-month In the previous post I covered how you can return the last weekday of the month. This post will focus on the formula that returns the first weekday of the mon ...|
|Add or remove items from a drop-down list |
|Working with Pivot Tables in Microsoft Excel |
|PivotTables are one of the most powerful features of Microsoft Excel. They allow large amounts of data to be analyzed and summarized in just a few mouse clicks. In this article, we explore PivotTables, understand what they are, and learn how to crea ...|
|Excel 2010: Dependent Drop-down Lists |
|This example describes how to create dependent drop-down lists in Excel.|
|Using VLOOKUP in Excel 2010 /функцията VLOOKUP в ексел 2010 |
|VLOOKUP is one of Excel’s most useful functions, and it’s also one of the least understood. In this article, we demystify VLOOKUP by way of a real-life example. We’ll create a usable Invoice Template for a fictitious company. So what is VLOOK ...|
Ето няколко средиземноморски ястия, от класиката до няколко нови ...
Ако вашата страст е да търсите злато или изгубени ценности - ...