Shajratul Alam Towhid

About author

Md Shajratul Alam Towhid, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, holds a pivotal role as an Excel & VBA Content Developer at ExcelDemy. Fueled by a deep passion for research and innovation, he actively engages with Excel. In his capacity, Towhid not only adeptly tackles complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his unwavering commitment to consistently delivering exceptional, high-quality content that brings significant value to users.

Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

B.Sc. in Naval Architecture & Marine Engineering, BUET.

Expertise

Microsoft Office, AutoCAD, Maxsurf, Rhinoceros, C, C++

Experience

  • Technical Content Writing
  • Undergraduate Projects
    • Desalination of Sea Water & the Efficiency of Production of Electricity Using Ship’s Exhaust Gas Temperature.

Latest Posts From Shajratul Alam Towhid

0
How to Create an Order Form in Excel (with Useful Steps)

If you are looking for how to create an order form in Excel, then you are in the right place. For international or any domestic business we need to make an ...

0
[Solved:] Excel Double Click AutoFill Not Working

If you are looking for the solution to Excel double click AutoFill not working, then you are in the right place. One of the very basic features of Excel is ...

0
How to Paste Excel Table into Word Fit to Page

If you are looking for how to paste an Excel table into Word to fit onto a page, then you are in the right place. Using Excel and Word simultaneously is a ...

0
How to Open Embedded File in Excel (with Useful Steps)

If you are looking for how to open an embedded file in Excel, then you are in the right place. We need to use an embedded file for different purposes while ...

0
How to Attach Email in Excel (with Useful Steps)

If you are looking for how to attach Email in Excel, then you are in the right place. Email is a basic thing in corporate life or any kind of communication. By ...

0
Man Hours Calculation in Excel (6 Useful Methods)

Method 1 - Using Subtraction If we know the starting time and the finishing time, we can calculate hours by using subtraction. Case 1.1. Time Value ...

0
How to Create GST Interest Calculator in Excel (with Useful Steps)

If you are looking for how to create a GST interest calculator in Excel, then you are in the right place. In Excel, while doing business calculations, we often ...

0
How to Create a Payment Advice Template in Excel With Easy Steps

A payment advice is a document buyers send to seller to confirm an invoice has been paid. Steps: Add the name and address of the supplier and ...

0
How to Prepare a Meeting Attendance Sheet in Excel

If you are looking for how to create a meeting attendance sheet in Excel, then you are in the right place. In our daily corporate life or in the case of any ...

0
How to Add Time to Date in Excel (4 Useful Methods)

If you are looking for how to add time to date in Excel, then you are in the right place. In Excel, while working with time and date we often need to get an ...

0
How to Change a 1000 Separator to a 100 Separator in Excel – 3 Methods

  What Is a Thousand Separator Format? Thousand separator is a symbol (either comma or dot or space etc.) that is used at the 3rd digit of any number. ...

0
How to Convert USD to Euro in Excel (3 Useful Methods)

If you are looking for how to convert USD to EURO in Excel, then you are in the right place. In international trade or any kind of business, we often need to ...

0
How to Vlookup Partial Match for First 5 Characters in Excel

If you are looking for how to vlookup partial match for the first 5 characters, then you are in the right place. We generally use the VLOOKUP function for ...

0
[Solved] SUMPRODUCT with Multiple Criteria Not Working in Excel (3 Solutions)

If you are using the SUMPRODUCT function in Excel and facing problems while using it, this article is for you. The SUMPRODUCT function is handy to use but ...

0
How to Add Option Button in Excel (With Easy Steps)

If you are looking for how to add an option button in Excel, then you are in the right place. In our practical life, we often need to use the option button to ...

Browsing All Comments By: Shajratul Alam Towhid
  1. Dear Nelly,
    Actually, percentage change mostly fits between two numbers. There is no specific formula to calculate percentage change among multiple numbers. Rather, when we face percentage change calculation, it means we are simply asked for the percentage change between the first number and the last number. In this case, the formula is.
    =((Final Value – Initial Value)/Initial Value)*100
    As your teacher has given you 10 different columns of values, you can calculate percentage change for each 2 individual columns and finally find a mean value of percentage change.
    This is like.
    =((2nd Value – First Value)/First Value)*100
    Then,
    =((3rd Value – 2nd Value)/2nd Value)*100
    Similarly, following the same formula find all the individual percentage change. For 10 columns you will find 9 individual percentage change.
    Finally, to find the mean.
    =(Percentage Change of (Step 1 + Step 2 + …….+ Step 9))/ 9

    Similarly, this statement is true for calculating count.

    Regards,
    Towhid
    Excel & VBA Content Developer
    ExcelDemy

  2. Dear Gen,
    You can use the formula.
    =TEXTJOIN(delimiter,TRUE,cell_range)
    Here, for E5 cell you can write.
    =TEXTJOIN(“-“,TRUE,B5:D5)
    Here, the character “-” is used to separate the combined text.
    This TEXTJOIN function is available only in Office 2019 and Microsoft 365.
    The Excel TEXTJOIN function joins multiple values from a row, column or range of cells with specific delimiter.

    For other versions of Excel, you can write the formula in the E5 cell based on B5,C5 and D5 cells like.
    =B5&IF(C5<>“”,”-“&C5,””)&IF(D5<>“”,”-“&D5,””)
    Finally, you need to set your column width to place the output in the cell perfectly and also need to wrap text.

    By using either of these two formulas you can ignore empty cells to combine cells into one.

    Regards,
    Towhid
    Excel & VBA Content Developer
    ExcelDemy

  3. Dear William Moloney,
    As far as I understand, you are able to use “Format Cell” but can’t get the procedure of using “Control Panel” to fix negative number format, right?
    You are using Windows 10 and you can do it easily in Windows 10.
    Firstly, go to “Control Panel”.
    Secondly, click on “Change date, time and number format” in the option “Clock and Region”.
    Thirdly, a window named “Region” will appear. Go to “Formats” option of that window. Click on “Additional settings” at the right-bottom side of the window.
    You will see a “Customize Format” window. Go to “Numbers” of this window. You’ll see many options available in this “Numbers” option.
    Fourthly, in the “Negative Number Format” option, click on the value and you will see different options such as 1.1, -1.1, 1.1- etc. You need to select 1.1 here and then click OK. This is the most important step here to select 1.1. Windows 10 has default selection 0f -1.1, you need to just change it to 1.1.
    Hope, your problem will be solved now. Thank you.

    Regards,
    Towhid
    Excel & VBA Content Expert
    ExcelDemy

  4. Hello RAY,
    Can you please elaborate what problems you are facing? And the problems in getting the output using these methods? I mean, the output scenario needs to be known and analyze properly to make a solution of your problem.

    Thanks with Regards,
    Towhid
    Excel and VBA Content Developer

  5. Hello NK,
    It’s awesome that you have found another solution which is applicable by adding a simple symbol in the formula you have mentioned. Yes obviously it is possible to remove blank from lists using the combination of UNIQUE and FILTER functions. The formula should be for the dataset of this article.
    =UNIQUE(FILTER(B5:B14,B5:B14<>“”))
    You need to add the symbol <> extra.
    Here, the FILTER function is used to remove any blank values from the data.
    The <> symbol is a logical operator that means does not equal.
    The filtered data is returned directly to the UNIQUE function as the array argument. The UNIQUE function then removes duplicates and return the final array.

    Thanks with Regards,
    Towhid
    Excel & VBA Content Developer

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo