Faysal Easy Excel

To combine similar Data Tables from different worksheets within the same workbook or different worksheets from different workbooks (but same table header), you can take help of Consolidate option from Data menu in Excel . This option allows you to combine all similar data into one single table where you apply the Consolidate command. It will be more clear if I tell you an example through others function.   Assume that, You have Sheet1 , Sheet2 and Sheet3 . Sheet1 has " District vs Month " wise rainfall measurement record in Bangladesh in 2015 . Similarly Sheet2 has the same data table with same header but 2016 years. Now in Sheet3 you need to AVERAGE the " District vs Month " wise rainfall measurement record. So, what will you do?   Generally You will go to the Sheet3 and Click the cell where you want to get the AVERAGE of a District and type the formula:   =SUM(Sheet1!B3+Sheet2!B3)/2   Yes this is correct. But problem is, if you use this ...

Sometimes we need to calculate the Loan Amount in Excel to borrow loan from Bank or some others company. There are many Banks and Financial Companies offered many kinds of Schemes. But before choosing anyone of them, you can simply calculate these scheme through Excel with few built-in functions, which will give you the real scenario. But before starting calculation you need to understand few Financial Terms. Some Financial Terms: PV (Present Value): This amount is basic. No interest or Tax included here. It is also known as Principal Value. FV (Future value): Based on Time Value of Money (TVM), it calculated for a specific period of time. It can be greater than PV or less than PV. Rate (Interest Rate %): It is the interest the set by the Bank. The Bank will take this interest as additional amount from your principal amount. Bank will mention it in contract as Annually. Make it sure from the Bank first. Assume that, Bank said Interest Rate is 12% Annually. Now you can con...

Assume that, you have below Student's Score Board Table, and you need to calculate the Maximum Scored number of an individual student in a single cell without creating any helper column.   Image 1: Students Data Table Now In any cell (I've used D16 ), used the below any one formula: =SUMPRODUCT(MAX(C2:C12+D2:D12+E2:E12+F2:F12+G2:G12+H2:H12+I2:I12)) =SUM(MAX(C2:C12+D2:D12+E2:E12+F2:F12+G2:G12+H2:H12+I2:I12)) =MAX(C2:C12+D2:D12+E2:E12+F2:F12+G2:G12+H2:H12+I2:I12) =PRODUCT(MAX(C2:C12+D2:D12+E2:E12+F2:F12+G2:G12+H2:H12+I2:I12)) =INT(MAX(C2:C12+D2:D12+E2:E12+F2:F12+G2:G12+H2:H12+I2:I12)) All of these results formulas will get a result 71 .   Image 2: Students Data Table with answer |||| Please SUBSCRIBE our YouTube Channel |||| https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw

Microsoft Excel often stops working and shut down the program. In a day it becomes very common problem. I would like to explain here why and how we can fix it. From my personal experience I'm telling that, there are few reasons are involved to make this happen. These are: (1) Unknown Reason: For any unknown reason, are you facing any problem running Excel? Then simply Microsoft Office Configuration Analyzer Tool may help you to find the correct reason. You can download it from site. At present it is running 2.2 version. To download it you can try below link: https://www.microsoft.com/en-us/download/details.aspx?id=36852 (2) COM Add-Ins: While you use COM Add-Ins, there is a common chance to get an error while loading the Add-Ins. Some file may not load correctly, that is why this problem arises. Your Excel stopped working and shutting down. To overcome from this problem you may try by uninstalling all COM Add-Ins. If all works nicely and you need to use a COM Add...

We use VLookup() in most of the case due to it is very easy to compare or populate your data table from a reference data table. But each time we apply a Vlookup() for generating next column data, then we have to change manually column number 2 to 3 or 4 or 5 etc. It is not time consuming. As a professional user you need to consume your time. So you need to apply it fast and submit the report. But the question is, what is the way to get automatically column number which will increase automatically and return data from reference source data table? It's nothing but a COLUMN(). Column(): This function generally return the Column() where your Column() is present. For example If you type in D115 cell below function and press enter: =COLUMN() Then it will return, D = 4 and nothing else. You can also use this function in the same cell D115 by this way: =COLUMN($G205) This function collected data from G205 and as G = 7 (A = 1, B = 2, C = 3, D = 4, E = 5, F = 6, G = 7) it retur...

Text to Column converting is an important thing to in Excel due to almost all types of raw data need to collect from others software or Web Applications which was mostly unstructured to make a report on it. In this article you will learn how can you convert a cell into Columns that contains Text with "Enter" and ";" character. Step by Step: Assume that you have below data: Image 1: Sample Data Now you want to convert the data like below: Image 2: Converted data (1) To do this, first of all make sure that, your B1 and C1 cell has set to Wrap Text. If not then Click on Home | Wrap Text to activate it. (2) In B1 cell use the below formula to collect data before ";" character: =LEFT(A1,FIND(";",A1)-1) This formula, took the LEFT mentioned numbers of characters found with FIND and matched character. (3) Now to collect the value after ";" use the below formula in C1 cell: =RIGHT(A1,LEN(A1)-FIND(";",A1...

Without VBA you can highlight the whole row with a specific color. Through VBA code it is very easier. But many people do not like VBA or cannot use VBA code due to security purpose. Today I'm going to show you how can you highlight whole row based on your Active Cell. Step by Step: (1) Select entire workbook by pressing Ctrl+A. (2) Click on Home | Conditional Formatting | New Rules | Use a formula to determine which cells to format. (3) Use the formula =CELL("row")=ROW() (4) Click on Format button and Select a Fill color (5) Click Ok. Now show the Cursor blinking by pressing F2 or Double Clicking a into a Cell. Then Click any Cell, that you want to highlight the entire row of that Cell. Image 1: Setting of Conditional Formatting |||| Please SUBSCRIBE our YouTube Channel |||| https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw