Priti

About author

Priti Halder holds a BSc degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. She has been a part of the ExcelDemy project for 6 months and during this time, she has written over 30 articles and 5 comments for the platform. Priti is currently employed as an Excel and VBA content developer and provides effective solutions to various Excel-related issues. She is passionate about expanding her knowledge of data analysis and Microsoft Office Suite.

Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

B.sc in Naval Architecture & Marine Engineering, Bangladesh University of Engineering & Technology.

Expertise

Data Analysis, Content Writing, Visual Basic for Applications (VBA), Charts and Dashboards, Microsoft Office, AutoCAD, Adobe Illustrator.

Experience

  • Technical Content Writing
  • Undergraduate Projects
    • Design of an Inland Oil Tanker
  • Industrial Training at Chittagong Dry Dock Limited
    • Project on Estimating and Planning for Docking a Ship in Dry Dock

Summary

  • Currently working as Excel & VBA Content Developer of ExcelDemy
  • Started technical content writing of Excel & VBA in November 2022 and later joined Exceldemy Team in February 2023.

Research & Publication

Latest Posts From Priti

0
Excel Mileage Calculator (Best, Worst, and Average Mileage)

In this Excel tutorial, you will learn in detail about the mileage calculator in Excel, which includes calculating mileage for vehicles and between cities. ...

0
Excel If Time Between Range (4 Quick Ways)

In this Excel tutorial, I will show you 4 different ways to check in Excel if time is between range. Nested IF, IFS, VLOOKUP, and XLOOKUP are some functions ...

0
How to Sort a Pivot Table (6 Easy Ways)

PivotTable summarizes and generates reports from a large data range. It helps to analyze data and find trends and relations between different data. Sorting is ...

0
How to Copy Chart in Excel (5 Easy Ways)

In this article, we will show you how to copy a chart in Excel in 5 easy ways. Excel charts are an excellent tool for visualizing or comparing different data. ...

0
How to Create Alerts in Excel – 4  Examples

Creating alerts is important for effectively managing data, tasks, and deadlines. To create alerts, you can use conditional ...

0
How to Import HTML into Excel (3 Easy Ways)

In this article, we will learn to import HTML into Excel. Excel is an excellent tool for managing data, and data comes in various formats. One of them is HTML ...

0
Excel Formula Errors (Find and Solve)

Excel is frequently used in finance, accounting, data analysis, and project management. However, if there is any error in formulas, that can hamper your work. ...

0
Top Financial Functions in Excel (15+ Functions)

Excel contains different financial functions designed to perform different financial calculations and analyses easily. Financial functions can calculate ...

0
Excel Named Range (A Complete Guideline)

Excel named range allows users to assign names to specific cells or ranges. This feature increases clarity and efficiency while working with large datasets. ...

0
How to Wrap Text in Excel (Wrap, Unwrap, Fix Issues)

Method 1 - Using Wrap Text Option from Home Tab Select range D6:D13. Go to the Home tab. Click on Wrap Text in the Alignment group. ...

0
The Excel Date Filter Is Not Grouping by Month – 3 Solutions

This is an overview. The dataset showcases product code, selling date, and the company's sales amount.   Solution 1 - If Dates Are Not ...

Browsing All Comments By: Priti
  1. Hello ZHENG,
    Thank you for taking the time to read our article. If you have cells of different colors (such as green, blue, and red) and want to sum them up, the easiest way is to use the SUBTOTAL function with the Filter command. For example, let’s say you have sales values in the range C5:C11, where cells C5, C7, and C10 are green, C6 and C8 are blue, and C9 and C11 are red. Illustrating Colored Cells
    1. To get the sum of a definite colored cell, insert the formula in a cell:=SUBTOTAL(9,C5:C11)
    Here, the SUBTOTAL function inserted in cell C12 uses 9 as the “function_name” argument (which refers to the SUM function) and C5:C11 as “ref1”. Inserting SUBTOTAL Formula
    2. Select the column header and go to the Data tab > Sort & Filter > Filter. Selecting Filter Command
    3. Click on the Filter icon of the column and select “Filter by Color.” You will see three different colors to choose from.
    4. Select the color you want to sum up, and you will get the sum of all the cells with that color. Choosing a color to filter by color
    You can see the blue-colored cells filtered and summed up.
    Cells Summed and Filtered by Color

    We hope this helps! Let us know if you have any further questions.

    Regards,
    Exceldemy Team

  2. Hello DILIP,
    Thank you for taking the time to read our article.

    In order to automatically copy rows from specific cell ranges without manually selecting them, you will need to include a few lines of code. Here is an example of the code that can be used. Just make sure to adjust the “wsDestination” variable to match the sheet name of your dataset and update the cell ranges in “sourceRange” variable.

    Sub CopyRows()
    Dim wsSource As Worksheet
    Dim wsDestination As Worksheet
    Dim cell As Range
    Dim sourceRange As Range

    Set wsSource = ActiveSheet
    Set wsDestination = Worksheets(“TargetSheet“)
    Set sourceRange = wsSource.Range(“A3:C10“)

    For Each cell In sourceRange.Columns(3).Cells
    If cell.Value = “New York” Then
    cell.EntireRow.Copy wsDestination.Range(“A” & wsDestination.Rows.Count).End(xlUp).Offset(1, 0)
    cell.EntireRow.Delete
    End If
    Next cell
    End Sub

    We hope this helps! Let us know if you have any further questions.

    Regards,
    Exceldemy Team

  3. Hello BRANISLAV,

    Thank you for reading our article and for your comment.
    You can easily create an add-in with the same code mentioned in this article. Kindly follow the steps mentioned below.
    1. Copy and paste the code in the article in a Module.
    2. Save the Excel file as a Macro Enabled Add-in (.xlam) file. For that, go to the File tab and select Save As.

    Selecting Save As Option

    Select Excel Add-in (*.xlam) from the drop-down under the file name and press Save.

    Choose Excel Add-in Option

    3. Now go back to your Excel file. From the Developer tab, select Excel Add-ins from Add-ins group.

    Selecting Add-in Option from ribbon

    4. Next, Add-ins dialog box will pop up. Browse for the name of your .xlam file, select the checkbox beside it, and press OK. We have chosen Udf_Tooltip as it was the name of our .xlam file.

    Choose the file name from option

    Now, you can access this UDF in any Excel file on your PC.
    Hope this solves your problem.
    Regards,
    Exceldemy Team

  4. Hello Stefano,
    I’m glad you found the information helpful, but I understand you’re still encountering issues with adding the FNC-1 character to your SSCC Code using a Code 128 font.

    I apologize for any confusion. The downloaded font here can not directly convert codes into Barcodes. You need to apply the VBA code to create the function “=Code128” to transform the SSCC code into symbols. After that, using the downloaded font will work.

    For your second problem, there isn’t a built-in Excel function called “=Code128b” for adding the FNC-1 character. Excel has no native function for generating Code 128 barcodes with special characters.
    That is why we built a function named “=Code128” using the VBA code for your convenience. Follow step 2 which is Using VBA to Create User Defined Function to create the function.
    I hope the confusion is cleared and this process willwork for you now.
    Regards
    Exceldemy Team

  5. Hello ALEQ,
    Thank you for your query. If you want to sum one specific product of two or three brands you just have to use an OR logic for brands.
    Let us assume we want to find the sum of notebook sales of Lenovo and Asus brands. For that insert the following formula:
    =SUMPRODUCT(((B5:B21=G12)+(B5:B21=G13))*(C5:C21=G14)*(D5:D21))

    Applying SUMPRODUCT Function

    Here, (B5:B21=G12)+(B5:B21=G13), this part applies the OR logic for brands. It matches the range B5:B21 with G12 and G13 cell values and returns TRUE or FALSE. So, it returns TRUE for Lenovo and Asus brands and Excel counts them as 1.
    Similarly, C5:C21=G14 returns TRUE or 1 for if any match is found and D5:D21 simply returns the sales values.
    So, the function sums up the prices of notebooks of two different brands.
    If you want to sum up prices for more brands, then just add another logic that matches brands in this part “(B5:B21=G12)+(B5:B21=G13)” of the formula.
    Regards,
    Priti
    Exceldemy Team

  6. Hello WU,
    Thank you for bringing that to my attention. You are correct that the proper formula for calculating the approximate yield to maturity (YTM) of a bond is:

    YTM = (C + (FV - PV) / n) / ((FV + PV) / 2)

    I appreciate your attention to detail, and I will ensure to update my article accordingly. Thank you for being a part of our community. If you have any further questions or require assistance, please don’t hesitate to post on our Forum.

    Regards,
    Priti
    Exceldemy Team

  7. Greetings Michal,

    Thanks for your comment! I understand the dissatisfaction with the limitations that you’ve faced. I agree that Microsoft could do more to enhance the functionality of their checkboxes.

    Regarding your first issue, it is true that the COUNTIF function is unable to directly count the number of checked boxes.
    Your second point—that Microsoft does not support Format Control Linking in an array—is also true. This implies that each checkbox needs to be linked separately. This process can take a while, especially if there are a lot of checkboxes.

    However, we can do Format Control Linking using VBA code which we already mentioned in this article. Besides, we are adding another code that works as a function and dynamically does format control linking without any helper column and counts the checked boxes.

    To work with this code, go to the Developer tab, and select Visual Basic. Now, from the Insert tab >> you have to select Module. Write down the following Code in the Module.

    Public Function CheckBoxCount()

    Dim checkBox As Shape
    Dim count As Long

    count = 0

    With ThisWorkbook.ActiveSheet
    For Each checkBox In .Shapes
    If InStr(1, checkBox.Name, “Check Box”) Then
    If .Shapes(checkBox.Name).OLEFormat.Object.Value = 1 Then
    count = count + 1
    End If
    End If
    Next checkBox
    End With

    CheckBoxCount = count

    End Function

    Now, Save the code and go back to Excel File. Insert the following formula in the cell that you want the count of checked boxes.
    =CheckBoxCount()
    And you will have the count of checked boxes.

    Hope this solution helps address your specific requirements in a more efficient manner.

    If you have any further queries, kindly post them on our Exceldemy Forum.
    Have a nice day!

    Regards,
    Priti

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo