Maruf Niaz

About author

Md. Maruf Niaz, BSc, Textile Engineering, Bangladesh University of Textiles, has worked with the ExcelDemy project for 11 months. He works as an Excel and VBA Content Developer who provides easy solutions to Excel-related problems and regularly writes fantastic content articles. He has published almost 20 articles in ExcelDemy. As an Excel & VBA Content Developer for ExcelDemy, he offers solutions to complex issues. He demonstrates an enthusiastic mindset and adeptness in managing critical situations with finesse, showcasing his commitment to excellence.

Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

B.sc in Textile (Apparel) Engineering, BUTex.

Expertise

C, C++, Lycra-Modaris (Pattern Making Software), MS Word, MS Excel, MS PowerPoint, Adobe Photoshop

Experience

  • Intern at Northern Tosrifa Group
  • Trainee Officer at Bank Asia Ltd.
  • Undergraduate Project: Textile engineers perspective on eco-friendly apparel

Summary

  • He works as an Excel & VBA content Developer at ExcelDemy in SOFTEKO.
  • He started technical content writing for OfficeWheel in SOFTEKO in November 2022.

Latest Posts From Maruf Niaz

0
How to Sort in Excel (All You Should Know)

In this article, we will demonstrate some easy methods to sort data in Excel. Sometimes it’s difficult to find data of interest in a random dataset. Sorting ...

0
How to Perform Regression Analysis in Excel? (3 Methods)

Regression Analysis helps to predict values depending on two or more variables. In this article, we will show you how to perform regression analysis in Excel ...

0
How to Use Geocoding in Excel? (2 Practical Examples)

Geocoding is the process of converting addresses or place names into geographic coordinates. Geographic coordinates are typically latitude and longitude. In ...

0
Clear Contents in Excel (All Things You Should Know)

In this article, we will show you how you can clear contents in Excel easily. Working with large datasets may require you to clear the contents of datasets ...

0
How to Insert Excel Tooltip on Hover (3 Examples)

This Excel article will discuss how to insert an Excel tooltip when you hover over a cell. Tooltips can become very important as they provide additional ...

0
Excel VBA Range Function (with 13 Examples)

In this article, we will discuss how you can use this function in VBA in Excel with different examples. The Range function is one of the most important and ...

0
How to Use SUMIF Function to Sum Not Blank Cells in Excel

Summing is one of the most performed operations in Excel. In Excel, there are multiple functions that you can use to sum values. Among these, the SUMIF ...

Browsing All Comments By: Maruf Niaz
  1. Hello HENRY,
    I hope you are doing well and thank you for your query. You can use the following formula to see which group these names are from.
    =INDEX($B$4:$D$4,MOD(ROW(B5)-5,COLUMNS($B$4:$D$4))+1)
    The formula uses INDEX, MOD, ROW and COLUMNS functions to look up the values in cells within column F and returns the corresponding group names in column G.
    Here is an image displaying the result in an Excel sheet:

    Reply-of-transpose-multiple-column-into-one-column

    Regards
    Maruf Niaz || ExcelDemy

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo