Zehad Rian Jim

About author

Zehad Rian Jim is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He's good with Microsoft Office and has written more than 80 helpful articles for ExcelDemy in the last year. Now, he makes fun and easy-to-follow Excel tutorials for YouTube as part of the ExcelDemy Video project. Zehad loves figuring out Excel problems, and his passion for learning new things in Excel shines through in his work.

Designation

Video Content Creator at ExcelDemy in SOFTEKO.

Lives in

105/A Free School Street, Kathalbagan Bazar, Dhaka, Bangladesh.

Education

B.sc in DEPARTMENT OF NAVAL ARCHITECTURE AND MARINE ENGINEERING, BANGLADESH UNIVERSITY OF ENGINEERING & TECHNOLOGY

Expertise

Data Analysis, Content Writing, C, C++, AutoCAD, Microsoft Office.

Experience

  • Content Writing
  • Video Content Creating
  • Undergraduate Projects
    • Industrial Visit Planning Shipyard
    • Accident Prevention
    • Project on Ocean going Ship Details Analysis

Summary

  • Currently working as Video Content Creator of ExcelDemy YouTube Channel.
  • Started technical content writing of Excel & VBA in June 2022 later promoted as Video Content Creator.
  • I worked at Udvash as a Content Maker and Instructor from February 2017 to May 2022.
  • I am one of the founding members of an online education platform named “Utkorsho”.

Latest Posts From Zehad Rian Jim

0
How to Skip a Column When Selecting in Excel (4 Easy Methods)

This tutorial will demonstrate how to skip a column when selecting Excel. When dealing with lots of data sometimes we need to skip one or many columns to avoid ...

0
How to Skip Cells in Excel Formula (8 Easy Methods)

This tutorial will demonstrate how to skip cells in an Excel formula. When dealing with lots of data, sometimes we have to skip unnecessary cells for ease of ...

0
How to Calculate GST in Excel (With Easy Steps)

This tutorial will demonstrate how to calculate GST in Excel. GST plays an essential role in the economy of any country. It helps a vital role in simplifying ...

0
How to Do Sensitivity Analysis in Excel (3 Easy Methods)

This tutorial will demonstrate how to do sensitivity analysis in excel. When you are doing any business, it is very important to analyze different parameters. ...

0
How to Use Macro to Save Excel File with New Name (5 Ways)

This tutorial will demonstrate how to use a macro to save an Excel file with a new name. If you have a particular Excel file that you need to use repeatedly, ...

0
How to Flip Data in Excel Chart (5 Easy Methods)

This tutorial will demonstrate how to flip data in an Excel chart. While dealing with lots of data or showing Excel in any report, flipping data can be very ...

0
How to Convert Decimal to Time in Excel Using Formula

This tutorial will demonstrate how to convert decimal to time in Excel using formula. Excel by default stores time in decimal format. But we need to convert it ...

0
How to Name a Table Array in Excel (With Easy Steps)

This tutorial will demonstrate how to name a table array in Excel. It is a very important argument in the LOOKUP Function. In case, you want to find a certain ...

0
How to Make Cricket Scorecard in Excel (with Easy Steps)

This tutorial will demonstrate how to make a cricket scorecard in Excel. The cricket scorecard displays the total collection of runs for a team with how many ...

0
How to Make a Box Plot in Excel?

This tutorial will demonstrate how to make a box plot in Excel. The box plot is another way of presenting statistical data for better visualization. It helps ...

0
How to Convert XML to XLSX Without Opening File

This tutorial will demonstrate how to convert XML to XLSX without opening the file. XML is a markup language. It is mainly used for giving definitions of ...

0
How to Put a Negative Number in Excel Formula (4 Easy Methods)

This tutorial will demonstrate the methods on how to put a negative number in an Excel formula. Negative numbers are very important in case of temperatures ...

0
How to Edit XML File in Excel (With Easy Steps)

This tutorial will demonstrate how to edit an XML file in Excel. XML is a markup language. It is mainly used for giving definitions of markup languages. XML is ...

1
How to Create Monthly Attendance Sheet in Excel with Formula

This tutorial will demonstrate the steps monthly attendance sheet in Excel with a formula. In any company or educational institution, it is very important to ...

0
How to Show Print Area in Excel (4 Easy Methods)

This tutorial will demonstrate the steps to how to show the print area in Excel. When you are submitting the Excel file or data table in your report, it is ...

Browsing All Comments By: Zehad Rian Jim
  1. Hello DESTINY,
    First, thanks for your curious question. It was amusing to solve the problem. Let me guide you to fulfill your query.

    Step 1. Assume you have a Dataset where you have the Names of the employees in one column and the types of the employees in another.
    1

    Step 2. Then insert the following code in the VBA window.

    Sub Copy_Rows_3()
    Dim r1 As Range, Row_Last As Long, sht As Worksheet
    Dim Row_Last1 As Long
    Dim src As Worksheet
    ‘Change this to the sheet with the data on
    Set src = Sheets(“Dynamic”)
    Row_Last = src.Cells(Cells.Rows.Count, “C”).End(xlUp).Row
    For Each r1 In src.Range(“C5:C13” & Row_Last)
    On Error Resume Next
    Set sht = Sheets(CStr(r1.Value))
    On Error GoTo 0
    If sht Is Nothing Then
    Worksheets.Add(After:=Worksheets(Worksheets.Count)).Name = CStr(r1.Value)
    ‘Sheets(CStr(r.Value)).Cells(1, 1) = “Total”
    Row_Last1 = Sheets(CStr(r1.Value)).Cells(Cells.Rows.Count, “B”).End(xlUp).Row
    src.Rows(r1.Row).Copy Sheets(CStr(r1.Value)).Cells(Row_Last1 + 1, 1)
    Sheets(CStr(r1.Value)).Cells(1, 2) = WorksheetFunction.Sum(Sheets(CStr(r1.Value)).Columns(3))
    Set sht = Nothing
    Else
    ‘Sheets(CStr(r.Value)).Cells(1, 1) = “Total”
    Row_Last1 = Sheets(CStr(r1.Value)).Cells(Cells.Rows.Count, “B”).End(xlUp).Row
    src.Rows(r1.Row).Copy Sheets(CStr(r1.Value)).Cells(Row_Last1 + 1, 1)
    Sheets(CStr(r1.Value)).Cells(1, 2) = WorksheetFunction.Sum(Sheets(CStr(r1.Value)).Columns(3))
    Set sht = Nothing
    End If
    Next r1
    End Sub

    N.B. if you are following our article, use the VBA code under the method “Copy Rows in Excel to Another Sheet Dynamically” and change the marked portions.

    2

    Step 3. After pressing Run, you will get the result in individual desired cells.

    3

    4

    Thanks


  2. At first, Create a dataset having Age in Column B, Fixed Amount in Column C and Principle At the Start of the period in Column D.
    Then, insert the following formula in cell D5 and use the Fill Handle option to apply it to all cells of column D.
    =B5*C5

    Finally, insert the following formula in cell E6 and use the Fill Handle option to apply it to all cells of column E to get the desired result.
    =E5*(1+0.02)+D6

    The excel file is added here according to your wish.
    Compound Interest Statement.xlsx
    Thanks and happy helping.

  3. Hello CALEY FORBES,
    Thanks for the amazing question. Let me guide you in solving this problem.

    First, I want to solve your first query. I think to solve your problem it is better to use our first method ‘Automatically Copy Rows in Excel to Another Sheet Using Filters’ method than using VBA code. The reason behind this is I think the first method will do your desired work without hesitation.

    For the second query, you have to insert the following formula in the VBA windows.

    Sub Cut_Range_To_Clipboard()
    Range(“B4:B10”).Cut ‘This will cut the source range and copy the Range “B4:B10” data into Clipboard
    ‘Now you can select any range and paste there
    Range(“J2”).Select
    ActiveSheet.Paste
    End Sub

    Note: in the Range section you can change the desired option to paste accordingly.

    I hope, your problem will be solved in this way. You can share more problems in an email at [email protected]
    Happy Excelling!!!

  4. Thanks Deep for your excellent and thoughtful question. Let me guide you to fulfill your query.
    We can easily extract multiple texts in cells by using different methods of this article but with slight changes.

    Suppose you have a dataset where the texts are separated only with hyphens. In this scenario, you should follow the first method in our article. The steps are:
    First, arrange the dataset where texts are separated with hyphens.
    Dataset if The Texts are Separated Only with Hyphens
    Second, insert the following formula.
    =MID(B5,FIND("-",B5)+1,LEN(B5))
    Insert the Following Formula

    Third, after pressing Enter button, you will get the result for this cell.
    Last, use the Fill Handle to apply it to all Cells.
    Final Result

    But in case, you have emails separated with @ or any other texts separated with special characters then you can use RIGHT, SEARCH & SUBSTITUTE Functions or LEFT, FIND & SUBSTITUTE Functions or RIGHT, REPT & SUBSTITUTE Functions from our article.
    Any of these methods will do the work for you. Let me guide you in detail with the steps.
    Firstly, you must arrange a dataset where multiple texts are separated with special characters.
    Dataset IF the texts are separated with special characters
    Next, use any of the following formulas in the D5 cell(described in our article)
    =RIGHT(B5,LEN(B5)-SEARCH("#",SUBSTITUTE(B5,C5,"#",LEN(B5)-LEN(SUBSTITUTE(B5,C5,"")))))
    or
    =SUBSTITUTE(B5,LEFT(B5,FIND(C5,B5)),"")
    or,
    =TRIM(RIGHT(SUBSTITUTE(B5,C5,REPT(" ",LEN(B5))),LEN(B5)))

    (Note: Please take a glimpse at our main article to understand the insertion of the formula)

    Afterward, after pressing Enter button, you will get the result for this cell. You will get the same result for any of the formulas so you can choose any of them.
    Last, use the Fill Handle to apply it to all Cells.
    Final Result

  5. Thanks, RICARDO SERRÃO for your two amazing queries. Let me help you out in solving your problems.
    First, we are going to discuss your first question. The problem you faced is about custom sorting.
    At the very beginning, we arranged a dataset of change in percentage.
    Dataset
    Then, as you wished we have used the COUNTIF function in this dataset.
    Formula Use
    As a result, we have found the values.
    Result
    Now, select Dataset> go to Data>Sort options.
    Sort Option
    After that, in the Sort window, select Change% in Sort By option, Cell Values in Sort On option, and Custom List in the Order option. Press OK to execute it.
    Sorting Window
    Furthermore, click on the NEW LIST option and write the condition manually in the List Entries area and press Add option.
    New List Add
    Because of that, you will get the desired condition in the Custom Lists section and press OK.
    New option in Custom
    Afterward, if you can see the desired condition in the Order box then press OK.
    Order
    Lastly, you will get the result accordingly. As in the condition, you have entered less than zero at first then zero to ten and at last greater than zero that’s why in the Excel section you will get the same order accordingly.
    Result
    So, that’s the solution to your first query. Now, Let’s go through your second problem.
    First, by reading your example, at first by using a formula, we created a Uniques Names list.
    Dataset
    Second, you have to write down the same unique names list in another column. The behind this is, in the array, you can’t use sorting.
    Write down unique names
    Third, then enter the Observations you made next to the new column.
    Observations
    Forth, as we want to sort, so we mark each name with a unique Id number in a new column.
    Id column
    Fifth, go to select the table>Data>Sort options.
    Sort Option
    Sixth, select the Id option in the Sort by option, and Cell Values in the Sort On option, click on the Largest to Smallest option in the Order section, and press OK.
    Sort Window
    Finally, you will get the desired result.
    Result
    So, this is the solution to your second query.
    Therefore, our journey comes to an end. The problems were very fun to solve and I really feel amazed by helping you. Thank you once again. Best of luck.

  6. Thanks, RON for your amazing question. Let me help you out in solving your problem. Please follow the below steps with us.
    First, we arranged a dataset and add an extra column(in this case Sales) in the same table as the below image.
    Dataset
    Then, insert the following formula in cell E5.
    =PRODUCT(C5,D5)
    Insert Formula
    After that, if you press the Enter button, then you will get the result for that cell, and afterward, use the Fill Handle option to apply the formula to all cells.
    Fill Handle
    Finally, you will get the desired result.
    Final Result
    So, I have tried to solve the problem to multiply the cells in the same table. If you face any other confusion, then we request you to provide the Excel file and give us the opportunity to help you out. All the best.

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo