Shamima Sultana

About author

Shamima Sultana, BSc, Computer Science and Engineering, East West University, Bangladesh, has been working with the ExcelDemy project for 2 years. She has written over 75+ articles and reviewed 1000+ articles for ExcelDemy. She has also led several teams with Excel VBA and Content Development works. Currently, she is working as the Project Manager and oversees the day-to-day work, leads the services team, allocates resources to the right area, etc. Her work and learning interests vary from Microsoft Office Suites, and Excel to Data Analysis, Data Science, VBA, Python, and developing Excel Applications.

Designation

Project Manager at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

B.sc in Computer Science and Engineering (CSE), East West University.

Expertise

Data Analysis, Content Writing, C, C++, Python, JavaScript (Basic), HTML, SQL, MySQL, PostgreSQL, Microsoft Office.

Experience

  • Project Management
  • Technical Content Writing
  • Team Management
  • Software Engineer
    • Data Architecture [Analysis and Diagram]
    • Data Governance [Using Excel and Postgre SQL]
    • 3D Object Visualization [Using Python]
  • Undergraduate Projects
    • Industrial Visit Planning Website
    • Database Management System
    • Factoid Question Answering System (over Bangla Comprehension)

Summary

  • Currently working as Project Manager of ExcelDemy
  • Started technical content writing of Excel & VBA in October 2021 later prompted as Team Leader for Content Management.
  • I worked at Adipster Tech Limited as a Software Engineer from November 2020 – May 2021. I’ve Done several real-life projects and documented several projects with analytical reports.

Research & Publication

Latest Posts From Shamima Sultana

0
Excel Interest Rate Calculator

Excel Interest Rate Calculator: Knowledge Hub Effective Interest Method of Amortization Excel Interest Rate Swap Calculation Excel Interest Rate ...

0
How to Convert Currency to a Number in Excel (6 Easy Ways)

In Microsoft Excel, it is easy to convert the currency to a number. For different types of purposes, you may need to convert your stored currencies to numbers. ...

0
How to Set Excel Column Width to cm Unit (with Easy Steps)

To demonstrate how to change the column width into cm (centimeters) in Excel, we'll use a dataset of order details with multiple columns. We've used ...

0
How to Create Proforma Invoice for Advance Payment in Excel

A Proforma invoice is used to request payments from the dedicated buyer for any items, goods, services and etc before supply. It includes details of the items ...

3
How to Format Phone Number with Extension in Excel (3 Easy Ways)

In Excel, storing phone numbers can be a bit tricky. Excel doesn't always recognize them automatically, especially when there are extensions involved. This ...

1
The Hyperlink in Excel is Not Working  -3 Solutions

The sample dataset contains Hyperlinks. Solution 1 - The Pound (#) Sign is Not Accepted in Hyperlinks If the link contains the Pound (#) sign, it ...

4
How to Sort Numbers in Excel (8 Quick Ways)

To do analysis or to keep numbers in order, Sorting is important. In Excel, there are a couple of ways to Sort numbers. There are two possible ways to Sort ...

2
How to Remove Percentage in Excel (5 Quick Ways)

In an Excel sheet, you can use different kinds of formats based on your need. Percentage is one of the number formats which is used to show a relative value ...

0
How to Remove Filter in Excel (5 Easy & Quick Ways)

For the purpose of demonstrating how to remove Filter in Excel, we'll use a sample dataset of a particular salesperson’s sales information, containing 4 ...

0
How to Use VBA Mod Operator (9 Examples)

The VBA Mod is not a function whereas MOD is a function in an Excel worksheet. VBA Mod is an operator which divides two numbers and returns the remainder. The ...

0
How to Trim Spaces in Excel (8 Easy Methods)

Let's use a sample dataset that represents the personal information of a particular person. The dataset has 3 columns these are Name, City, and Zip Code. ...

0
How to Use Calculated Field in Excel Pivot Table (8 Ways)

In Excel you can create a Pivot Table from any dataset, Pivot Table is useful when you need a new data point that can be obtained by using existing data points ...

0
How to Split First And Last Name in Excel (6 Easy Ways)

In Excel, you can split your full name into separate columns. There are a couple of ways to split first name and last name. You can use Excel inbuilt features ...

0
How to Use Less Than Or Equal to Operator in Excel (8 Examples)

Microsoft Excel has 6 logical operators which are also known as comparison operators. And Less Than or Equal to (<=) is one of them. The Less Than or Equal ...

0
How to Lookup a Table in Excel (8 Methods)

Understanding Lookup Tables in Excel When working with large datasets, you often need to retrieve specific values. Excel provides a powerful feature called ...

Browsing All Comments By: Shamima Sultana
  1. Hi Arda
    Hope you are doing well.

    I checked the code you mentioned above and it works. To make it more clear I’m attaching some images with the code.

    Here, I tried the exact code in the same dataset.
    MsgBox Range("E5").End(xlToRight).Offset(0, 1).Address

    You can see the result $G$5.

    Again I changed the dataset slightly.

    Here, the result is also based on the location.

    NB. If it doesn’t help you then please send your dataset to [email protected] or [email protected]

    Thanks
    Shamima Sultana
    ExcelDemy

  2. Hello Laura,

    Sorry to hear your issue. Here, I am suggesting some troubleshooting steps to resolve the problem. But I will encourage you to submit your Excel file in our ExcelDemy Forum so that we can inspect it thoroughly.

    1. Remove Non-Printable Characters:

    Use =CLEAN(C2) to clean the data.

    2. Check for Merged Cells:

    Ensure there are no merged cells in your dataset.
    Data Consistency:

    3. Make sure all data in Column C are of the same type (text).

    4. Sort by Multiple Columns:

    Use Data > Sort,
    and add levels to sort by Column C first and then Column E.

    5. Manual Inspection:

    Check the middle section where the sort restarts for any anomalies.

    6. New Worksheet:

    Copy and paste the data into a new worksheet and try sorting again.

    Regards
    ExcelDemy

  3. Hello Selva,

    You are most welcome.

    Regards
    ExcelDemy

  4. Hello Kitonski,

    Here, I made some fixes. Please try this updated code:
    Used the shell.Run command which is synchronous (True as the last parameter), ensuring the Python script completes before the VBA code proceeds.
    Using the Now function to calculate the start and end times accurately.
    To be safe used the Shell execution uses the correct quotation marks to avoid syntax errors.

    Sub RunPythonScript()
    
        Dim exe As String, pth As String
        Dim fileToOpen As Variant
        Dim wsMaster As Worksheet
        Dim wbTextImport As Workbook
        Dim myDir As String
        Dim startTime As Doubleks:
        Dim endTime As Double
        Dim totalTime As Double
        Dim shell As Object
        Dim command As String
    
        myDir = "C:\Users\uie34719\OneDrive – Continental AG\Documents\CONTINENTAL FILES\PERSONAL FILES\REVIEWER-1\DEVNET\OTHERS\PROJECT\SHOWOFF"
    
        exe = "C:\Users\uie34719\AppData\Local\Programs\Python\Python39\python.exe"
        pth = "C:\Users\uie34719\OneDrive – Continental AG\Documents\CONTINENTAL FILES\PERSONAL FILES\REVIEWER-1\DEVNET\OTHERS\PROJECT\SHOWOFF\Main_Network_Script-WithCSV.py"
    
        startTime = Now
    
        Set shell = CreateObject("WScript.Shell")
        command = """" & exe & """ """ & pth & """"
        shell.Run command, 1, True ' The last parameter True makes the execution synchronous
    
        endTime = Now
        totalTime = (endTime - startTime) * 24 * 60 * 60 ' Convert time difference to seconds
    
        MsgBox totalTime & " seconds"
    
        ' Schedule OkGo to run after the total time
        Application.OnTime Now + TimeValue("0:00:" & Round(totalTime)), "OkGo", schedule:=True
    
    End Sub
    
    Sub OkGo()
    
        Dim fileToOpen As String
        Dim wsMaster As Worksheet
        Dim wbTextImport As Workbook
    
        Range("E2:H1048576").ClearContents
    
        fileToOpen = "C:\Users\uie34719\OneDrive – Continental AG\Documents\CONTINENTAL FILES\PERSONAL FILES\REVIEWER-1\DEVNET\OTHERS\PROJECT\SHOWOFF\1CSV_OUTPUT.csv"
    
        Workbooks.OpenText fileToOpen
    
        Set wbTextImport = ActiveWorkbook
    
        Set wsMaster = ThisWorkbook.Worksheets("Main_Template")
    
        wbTextImport.Worksheets(1).Range("A1").CurrentRegion.Copy wsMaster.Range("E2")
    
        wbTextImport.Close False
    
    End Sub
    

    Regards
    ExcelDemy

  5. Hello Hassan Ibrahim Mohammed,

    Hope you are doing well. I will suggest you to go through the article again. You can download the dataset to try the calculations.

    1: Likert Scale Range and Its Effect on Final Results

    Here, each Likert scale response (ranging from 1 to 5) is assigned a numerical value. These values are added up for each respondent to get a total score. For example, if a respondent’s answers to five questions are 4, 3, 5, 2, and 1, the total score is 15. This summed score helps in analyzing the overall sentiment or opinion of the respondents. Higher scores indicate more positive responses, while lower scores indicate more negative responses.

    2: Adding Non-Parametric Tests to Excel
    To add non-parametric tests like the Mann-Whitney U test or the Kruskal-Wallis test to your Excel sheet, you can use the dataset from the article. But Excel does not have built-in non-parametric test functions, you need to manually calculate them using formulas and the Data Analysis ToolPak (If not available in Ribbon, get it from Excel options). For example, you can rank your Likert scale data using the RANK function and then apply the necessary formulas to perform the tests. It may require detailed setup and understanding of the test procedures, but it can be done effectively in Excel.

    Regards
    ExcelDemy

  6. Hello Patricia,

    To solve this issue:
    First, add columns for monthly interest and new balance.
    Then, for each debt, include columns for monthly interest and new balance.

    Use the following formula to calculate monthly interest:

    Monthly Interest = Previous Balance * (Annual Interest Rate / 12)

    Example:
    Debt 1 (D2): =C2*0.17/12
    Debt 2 (H2): =G2*0.19/12
    Debt 3 (L2): =K2*0.20/12

    Use the following formula to calculate new balance:

    New Balance = Previous Balance + Monthly Interest – Payment

    Example:
    Debt 1 (E2): =C2+D2-B2
    Debt 2 (I2): =G2+H2-F2
    Debt 3 (M2): =K2+L2-J2

    Regards
    ExcelDemy

  7. Hello Sandy,

    You can use this formula:
    =OR(WEEKDAY([@DATE], 2) = 6, WEEKDAY([@DATE], 2) = 7)
    This checks if the [@DATE] column value is a Saturday (6) or Sunday (7).

    Regards
    ExcelDemy

  8. Hello Poppy Lukhele,

    Could you be more specific? If possible share any sample data.

    Regards
    ExcelDemy

  9. Hello Mary Grace,

    Please use this updated code to get your desired result:
    Here I added an input box to select the column with the names of the recipients (XRcptsName ). Then, updated the email body to include the recipient’s actual name and removed the word “text.”

    Public Sub SendReminderMail()
    'Declare the variables
        Dim XDueDate As Range
        Dim XRcptsEmail As Range
        Dim XRcptsName As Range
        Dim xMailContent As Range
        Dim xRngDn As Range
        Dim xCrtOut As Object
        Dim xValDateRng As String
        Dim xValSendRng As String
        Dim k As Long
        Dim xMailSections As Object
        Dim xFinalRw As Long
        Dim CrVbLf As String
        Dim xMsg As String
        Dim xSubEmail As String
        On Error Resume Next
        'To select the date column insert a input box
        Set XDueDate = Application.InputBox("Select the column for Deadline/Due Date date column:", "ExcelDemy", , , , , , 8)
        If XDueDate Is Nothing Then Exit Sub
        'Insert a input box for selecting the recipients
        Set XRcptsEmail = Application.InputBox("Choose the column for the email addresses of the recipients:", "ExcelDemy", , , , , , 8)
        If XRcptsEmail Is Nothing Then Exit Sub
        Set XRcptsName = Application.InputBox("Choose the column for the name of the recipients:", "ExcelDemy", , , , , , 8)
        If XRcptsName Is Nothing Then Exit Sub
        'To enter the text mail, insert a input box
        Set xMailContent = Application.InputBox("In your email, choose the column with the reminded text:", "ExcelDemy", , , , , , 8)
        If xMailContent Is Nothing Then Exit Sub
        'Count rows for the due dates
        xFinalRw = XDueDate.Rows.Count
        Set XDueDate = XDueDate(1)
        Set XRcptsEmail = XRcptsEmail(1)
        Set xMailContent = xMailContent(1)
        Set XRcptsName = XRcptsName(1)
        'Set command to open MS Outlook Application
        Set xCrtOut = CreateObject("Outlook.Application")
        
        'Apply For loop to conduct the operation in each row one by one
        For k = 1 To xFinalRw
            xValDateRng = ""
            xValDateRng = XDueDate.Offset(k - 1).Value
            'Apply If condition for the Due Date values
            If xValDateRng <> "" Then
            'Condition set to send mail if the difference between due dates and current date is greater than 1 and less than 7 days
            'Means 1 < X< 7, X = Due Date - Current Date
            If CDate(xValDateRng) - Date <= 7 And CDate(xValDateRng) - Date > 0 Then
                xValSendRng = XRcptsEmail.Offset(k - 1).Value
                'Create the subject, body and text contents with the required variables
                xSubEmail = xMailContent.Offset(k - 1).Value & " on " & xValDateRng
                CrVbLf = "<br><br>"
                xMsg = "<HTML><BODY>"
                xMsg = xMsg & "Dear " & XRcptsName.Offset(k - 1).Value & CrVbLf
                xMsg = xMsg & xMailContent.Offset(k - 1).Value & CrVbLf
                xMsg = xMsg & "</BODY></HTML>"
                'Create the email
                Set xMailSections = xCrtOut.CreateItem(0)
                'Define the position to place the Subject, Body and Recipients Address
                With xMailSections
                    .Subject = xSubEmail
                    .To = xValSendRng
                    .HTMLBody = xMsg
                    .Display
                    
                    '.Send
                
                End With
                Set xMailSections = Nothing
            End If
        End If
        Next
        Set xCrtOut = Nothing
    End Sub
    

    Regards
    ExcelDemy

  10. Hello Paul Tupper,

    Yes, we can use this formula too. Thanks for your suggestions, we really appreciate it.

    Regards
    ExcelDemy

  11. Hello Paul Tupper,

    Of course, you can use this formula too. Both are doing the same calculations. Our formula is simpler nothing else. Thanks for your suggestions, we really appreciate it.

    Regards
    ExcelDemy

  12. Hello George Jululian,

    You are most welcome.

    Regards
    ExcelDemy

  13. Hello Hen,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  14. Dear,

    You are most welcome.

    Regards
    ExcelDemy

  15. Hello Jeromy Adofo,

    You are most welcome. please stay connected with us.

    Regards
    ExcelDemy

  16. Hello Myron,

    You are most welcome.

    Regards
    ExcelDemy

  17. Hello Aleksandar,

    You can concatenate the cell values into a single string to get one QR code from different cell values.

    You can use the following code:

    Sub GenerateQRCode()
        Dim ws As Worksheet
        Set ws = ThisWorkbook.Sheets("Sheet1") ' Change the sheet name as necessary
        
        Dim cell As Range
        Dim qrString As String
        qrString = ""
        
        ' Loop through the cells you want to include in the QR code
        For Each cell In ws.Range("A1:A10") ' Specify your range
            qrString = qrString & cell.Value & " " ' Concatenate values with a separator if needed
        Next cell
        
        ' Generate QR Code
        Dim qrCode As Object
        Set qrCode = ws.Pictures.Insert("https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=" & qrString)
        
        With qrCode
            .ShapeRange.LockAspectRatio = msoFalse
            .Width = 150
            .Height = 150
            .Left = ws.Cells(1, 3).Left
            .Top = ws.Cells(1, 3).Top
        End With
    End Sub

    Regards
    ExcelDemy

  18. Hello Muhammad Afzaal Jutt,

    You need to use a combination of functions like SUBSTITUTE, TEXTJOIN, FILTERXML, and SUM. Currently, Excel does not directly provide a simple formula for this without VBA.

    You can use the following formula:
    =SUM(FILTERXML("<t><s>" & SUBSTITUTE(SUBSTITUTE(A1, " ", "</s><s>"), "$", "") & "</s></t>", "//s[number(.)=.]"))

    Regards
    ExcelDemy

  19. Hello Ckwong,

    To get the result as State Name. You need to use the state name column as an array of INDEX function. Just replace the cell range from C5:C12 to B5:B12.
    You can use the following formula:
    =INDEX(B5:B12, MATCH(TRUE, INDEX(C5:C12>700000, 0), 0))

    Regards
    ExcelDemy

  20. Hello Esraa Yaseen,

    You are most welcome. We are glad to help you.

    Regards
    ExcelDemy

  21. Hello Prabhakar Srinivasagam,

    You are most welcome. Your kind words means a lot to us. We are always here to help you.

    Regards
    ExcelDemy

  22. Hello Abinsh,

    You are most welcome.

    Regards
    ExcelDemy

  23. Hello Jen,

    Thanks for coming back, hopefully it will work this time. If it doesn’t work, you can let us know your problem in the comment section below.

    Regards
    ExcelDemy

  24. Hello Usama Jamil,

    You are most welcome.

    Regards
    ExcelDemy

  25. Hello Atif Hassan,

    Thanks for your appreciation. You can use the following formula to use XLOOKUP with tolerance level:
    =XLOOKUP(TRUE, IF(ABS($C$2:$C$4 – $A$2) <= $B$2, TRUE, FALSE), $D$2:$D$4, "Not Found")

    https://www.exceldemy.com/wp-content/uploads/2024/05/XLOOKUP-Based-on-Customized-Criteria.gif

    Please download the Excel file for better understanding:
    XLOOKUP with Tolerance Level.xlsx

    Regards
    ExcelDemy

  26. Hello Danielle Davies,

    You are most welcome. Your appreciation means a lot to us.

    Regards
    ExcelDemy

  27. Hello Vito,

    Don’t be sorry Vito. Let us know your feedback, hopefully it will work.

    Regards
    ExcelDemy

  28. Hello Jose,

    You are most welcome. Your appreciation means a lot to us.

    Regards
    ExcelDemy

  29. Hell MM,

    You are most welcome.

    Regards
    ExcelDemy

  30. Hello Michael,

    You are most welcome.

    Regards
    ExcelDemy

  31. Hello T Althoff,

    Our updated article indeed includes three templates of different cases, each addressing different scenarios. You can modify these templates to recalculate interest and principal based on irregular payment dates, they offer versatile solutions for various other scenarios.

    Regards
    ExcelDemy

  32. Hello Reza Fadlilah,

    Here are some articles from where you can download dataset of different types to practice your skills.
    Excel Sample Data (Free Download 13 Sample Datasets)
    Excel Data for Analysis (Free Download 11 Suitable Datasets)
    Excel Data for Practice Free Download

    Regards
    ExcelDemy

  33. Dear Ayebusiwa Oyesanmi Emmanuel,

    Answers are given in the Solution sheet of Excel File which is in Download Practice Workbook section.
    Answer sheet

    Soluation-of-Advanced-MCQs-for-Exam

    Regards
    ExcelDemy

  34. Hello Emon,

    You can download the Cheat Sheet free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email to get the download links.

    Best Regards
    ExcelDemy

  35. Hello Abdul,

    It’s glad to hear and you are most welcome.

    Regards
    ExcelDemy

  36. Hello Rhonda Rodriguez,

    Thanks for your appreciation. You are most welcome.

    Regards
    ExcelDemy

  37. Hello Michailmqo,

    You can mail to [email protected].

    Regards
    ExcelDemy

  38. Hello Rajkapoor,

    Thanks for your appreciation and you are most welcome.

    Regards
    ExcelDemy

  39. Hello Deborah Yassen,

    You are most welcome.

    Regards
    ExcelDemy

  40. Hello Kukuh Romansyah,

    You are most welcome (Sama-sama). It’s glad to hear that you found it useful.

    Regards
    ExcelDemy

  41. Hello Lukas Cenjar,

    This VBA code won’t work on MAC but here we are giving you a sample code that might work on MAC. We updated our existing code based on MAC requirements.
    1. We used AppleScript to interact with the Mail application on macOS to create and send the email.
    2. Then, used MacScript to run AppleScript commands from VBA to handle Mac-specific scenarios.

    Public Sub SendReminderMail()
        'Declare the variables
        Dim XDueDate As Range
        Dim XRcptsEmail As Range
        Dim xMailContent As Range
        Dim xFinalRw As Long
        Dim xValDateRng As String
        Dim xValSendRng As String
        Dim k As Long
        Dim xSubEmail As String
        Dim xMsg As String
        Dim AppleScript As String
    
        'Input box for the deadline/due date column
        Set XDueDate = Application.InputBox("Select the column for Deadline/Due Date date column:", "ExcelDemy", Type:=8)
        If XDueDate Is Nothing Then Exit Sub
        
        'Input box for email addresses
        Set XRcptsEmail = Application.InputBox("Choose the column for the email addresses of the recipients:", "ExcelDemy", Type:=8)
        If XRcptsEmail Is Nothing Then Exit Sub
        
        'Input box for email content
        Set xMailContent = Application.InputBox("In your email, choose the column with the reminded text:", "ExcelDemy", Type:=8)
        If xMailContent Is Nothing Then Exit Sub
        
        'Count rows for due dates
        xFinalRw = XDueDate.Rows.Count
    
        'Loop through each row
        For k = 1 To xFinalRw
            xValDateRng = XDueDate.Cells(k).Value
            
            'Check if the due date is within the next week
            If xValDateRng <> "" And CDate(xValDateRng) - Date <= 7 And CDate(xValDateRng) - Date > 0 Then
                xValSendRng = XRcptsEmail.Cells(k).Value
                xSubEmail = xMailContent.Cells(k).Value & " on " & xValDateRng
                xMsg = "Dear " & xValSendRng & vbCrLf & "Text : " & xMailContent.Cells(k).Value
    
                'AppleScript to send email
                AppleScript = "tell application ""Mail""" & vbCrLf
                AppleScript = AppleScript & "set newMessage to make new outgoing message with properties {subject:""" & xSubEmail & """, content:""" & xMsg & """, visible:true}" & vbCrLf
                AppleScript = AppleScript & "tell newMessage" & vbCrLf
                AppleScript = AppleScript & "make new to recipient at end of to recipients with properties {address:""" & xValSendRng & """}" & vbCrLf
                AppleScript = AppleScript & "send" & vbCrLf
                AppleScript = AppleScript & "end tell" & vbCrLf
                AppleScript = AppleScript & "end tell"
    
                'Run AppleScript from VBA
                MacScript (AppleScript)
            End If
        Next
    End Sub
    

    Regards
    ExcelDemy

  42. Hello ER,

    We are glad to hear that our article was helpful to you. Thanks for your appreciation. Keep learning Excel.

    Regards
    ExcelDemy

  43. Hello Jan,

    You need to scale the image to show the borders.
    You can use the following updated code to do so.
    Here, I used 0.9,to scale 90% of the cell’s width and height.
    Next, used LockAspectRatio to maintain the aspect ratio of the pictures.
    Then, Adjusted the alignment using Left and Top, it will center the picture within the cell after resizing.

    Sub InsertMultiplePictures()
        Dim Pictures() As Variant
        Dim PictureFormat As String
        Dim PicRng As Range
        Dim PicShape As Shape
        Dim ScaleWidth As Single
        Dim ScaleHeight As Single
    
        ' Define scale factors (90% of the cell size)
        ScaleWidth = 0.9
        ScaleHeight = 0.9
    
        On Error Resume Next
        Pictures = Application.GetOpenFilename(PictureFormat, MultiSelect:=True)
        PicColIndex = Application.ActiveCell.Column
    
        If IsArray(Pictures) Then
            PicRowIndex = Application.ActiveCell.Row
            For lLoop = LBound(Pictures) To UBound(Pictures)
                Set PicRng = Cells(PicRowIndex, PicColIndex)
                Set PicShape = ActiveSheet.Shapes.AddPicture(Pictures(lLoop), msoFalse, msoCTrue, PicRng.Left, PicRng.Top, PicRng.Width, PicRng.Height)
                ' Scale the picture size
                With PicShape
                    .LockAspectRatio = msoTrue
                    .Width = PicRng.Width * ScaleWidth
                    .Height = PicRng.Height * ScaleHeight
                    ' Center the picture in the cell
                    .Left = PicRng.Left + (PicRng.Width - .Width) / 2
                    .Top = PicRng.Top + (PicRng.Height - .Height) / 2
                End With
                PicRowIndex = PicRowIndex + 1
            Next
        End If
    End Sub
    

    Regards
    ExcelDemy

  44. Hello Alami,

    Yes. you need to select the cell in the InputBox every time you want to clear the cells.
    But if you want to avoid using InputBox, I’m giving you two different code to do so.

    Mentioned the range then clear cells:

    Sub Clear_Range()
        Sheets("Sheet1").Range("A1:B10").Clear
    End Sub
    

    Select the cells then run the VBA code:

    Sub Clear_from_Selection()
        Selection.ClearContents
    End Sub
    

    Regards
    ExcelDemy

  45. Hello A.Nirmala Rani,

    You can the following formula for the volume of a cylindrical segment:
    Mesaurements
    Where:
    V is the volume in liters,
    L is the length of the cylinder in meters,
    R is the radius of the cylinder in meters,
    h is the height of the liquid level in meters.

    Given the specific dimensions:
    L=5.0 meters (500 cm),
    R=1.0 meter (100 cm),
    h varies from 0.01 meters (1 cm) to 2.0 meters (200 cm)

    This formula calculates the volume of the liquid based on the height from the base up to the liquid level within a horizontal cylindrical tank. To use this formula, ensure to convert all measurements (radius, length, and height) to meters before applying them in the calculation.

    At 1 cm height: Approximately 9.41 liters
    At 2 cm height: Approximately 26.59 liters
    At 3 cm height: Approximately 48.77 liters
    At 4 cm height: Approximately 74.97 liters
    At 5 cm height: Approximately 104.62 liters
    At 10 cm height: Approximately 293.63 liters
    ———————————————————
    To see the full list of calculated volumes for each centimeter increment from 1 cm to 100 cm for the horizontal cylindrical tank, Download the Excel File.
    List of Calculated Volumes.xlsx

    Regards
    ExcelDemy

  46. Dear Curt,

    It’s glad to hear that our article solved your issue. You are most welcome.

    Regards
    ExcelDemy

  47. Hello Kevin,

    Here the needle is pointing at 45 but as we kept the number inside the pie chart may seem 55 but actual point is 45. For your better understanding I am attaching another article for the clear view. Sorry for the confusion.
    Please read this article from step 6: How to Create a Gauge Chart in Excel (With Easy Steps)
    You can watch these two images to clear the confusion.

    Speedometer Speedometer

    Regards
    ExcelDemy

  48. Hello Harry Ingram,

    You can use this formula to extract only the numbers, including the decimal point.
    =TEXTJOIN(“”, TRUE, IFERROR(IF(ISNUMBER(SEARCH(MID(B5, ROW(INDIRECT(“1:” & LEN(B5))), 1), {“0″,”1″,”2″,”3″,”4″,”5″,”6″,”7″,”8″,”9″,”.”})), MID(B5, ROW(INDIRECT(“1:” & LEN(B5))), 1), “”), “”))

    Feel free to download the Excel file from the link below, you’ll find examples of the formula.
    Excel file: Extract Decimal Point Numbers

    Regards,
    ExcelDemy

  49. Hello Paresh Kanti Paul,

    This article includes two dynamic ways for currency conversion.
    Real Time Currency Converter in Excel

    Regards
    ExcelDemy

  50. Hello Martin,

    We are glad to hear that you found this article useful! Including a real-life example in tutorials can indeed make the steps more relatable and easier to understand. Applying these models to specific scenarios like maximizing profit by determining the production units for products A and B is a great way to leverage linear programming. We will include this in our next update.

    Regards
    ExcelDemy

  51. Hello Karunesh Pandey,

    As calibration details varies with lab type we can provide you the criteria. You can fill out your information and edit the list.

    Calibration details

    Equipment Name Serial Number Manufacturer Model Calibration Frequency Last Calibration Date Next Due Date Technician Initials Comments
    pH Meter 12345 ABC Inc. Model X Monthly 3/15/2024 4/15/2024 AB
    Balance 67890 XYZ Corp. Model Y Monthly 3/20/2024 4/20/2024 CD
    Spectrophotometer 13579 DEF Ltd. Model Z Monthly 3/10/2024 4/10/2024 EF
    Pipettes (10-100µl) 24680 GHI Co. Model A Monthly 3/25/2024 4/25/2024 GH

    Regards
    ExcelDemy

  52. Hello Gary Ward,

    Thanks for your valuable suggestion we will include this in our article.

    Regards
    ExcelDemy

  53. Hello Liz,

    You can avoid the absolute reference ($ sign). Here absolute reference is used so that it can avoid error if anyone copy the formula in another cell.

    Regards
    ExcelDemy

  54. Hello Alphonse,

    We are glad to hear from you again! Don’t worry about missed message, technical glitches happen to the best of us. We are glad to hear that the code for counting Mondays worked well for you. Thank you so much for expressing your gratitude—it’s always means a lot to us to know when something was helpful. You are most welcome and cheers to you too.

    Regards
    ExcelDemy

  55. Hello Cynthia Satterwhite,

    Neither any problem nor any solution are given. These dataset are given to practice by yourself.

    Regards
    ExcelDemy

  56. Hello Nilanjan,

    Excel for Mac doesn’t support the WorksheetFunction.WebService method due to differences in how Excel for Mac interacts with web services compared to Excel for Windows. In Mac, you need to directly access Google Translate’s API using HTTP requests or using a different method provided by Google Translate.

    Function TranslateText(text_str As String, src_lang As String, trgt_lang As String) As String
        Dim url As String
        Dim xmlhttp As Object
        Dim response As String
        Dim json As Object
        
        ' Construct the URL for Google Translate API
        url = "https://translation.googleapis.com/language/translate/v2?key=YOUR_API_KEY&q=" & _
                VBA.URLEncode(text_str) & "&source=" & src_lang & "&target=" & trgt_lang
    
        ' Send HTTP request to Google Translate API
        Set xmlhttp = CreateObject("MSXML2.XMLHTTP")
        xmlhttp.Open "GET", url, False
        xmlhttp.send
        
        ' Parse the JSON response
        response = xmlhttp.responseText
        Set json = JsonConverter.ParseJson(response)
        
        ' Extract and return the translated text
        TranslateText = json("data")("translations")(1)("translatedText")
    End Function
    

    Replace “YOUR_API_KEY” with your actual Google Cloud Platform API key.
    Remember to enable the “Microsoft XML, v6.0” reference in the VBA editor (under Tools > References) to use CreateObject(“MSXML2.XMLHTTP”) for making HTTP requests.

    Regards
    ExcelDemy

  57. Hello Umang,

    Here are some articles from where you can download dataset of different types to practice your skills.
    Excel Sample Data (Free Download 13 Sample Datasets)
    Excel Data for Analysis (Free Download 11 Suitable Datasets)
    Excel Data for Practice Free Download

    Regards
    ExcelDemy

  58. Hello Sameul Smith,

    You can follow any of the methods of your choice to make your list. If you face any problem regarding it you can share your list with us. If you want to upload any image or Excel file you can post it on our ExcelDemy Forum.

    Regards
    ExcelDemy

  59. Hello Fredrick Aringo,

    You must use the last line to do AutoFilter based on criteria.

    ActiveSheet.Range(“A1:E14”).AutoFilter field:=2, Criteria1:=CatSites
    

    Please avoid the first line. We updated our code.

    Regards
    ExcelDemy

  60. Dear Bharath L,

    You are most welcome. We are glad that our solution worked for you.

    Regards
    ExcelDemy

  61. Hello,

    These datasets are given to use it for practice purpose. Currently we don’t have any solution of the task. But if you want you can send your completed task, we will review it for you.

    Regards
    ExcelDemy

  62. Hello NadineB,

    You are most welcome. Thanks a lot for your appreciation.

    Regards
    ExcelDemy

  63. Hello Valen,

    Can you mention the URL, please? In our site all URL’s of this article are working perfectly.

    Regards
    ExcelDemy

  64. Hello Dianne Waginauru,

    You are most welcome and thanks for your appreciation. All the very best for you project management journey.

    Regards
    ExcelDemy

  65. Hello Gwenn,

    Thanks for your suggestion. We deeply appreciate the solution provided in the comments. Thank you for your helpful contribution!

    Regards
    ExcelDemy

  66. Hello Ameer Ahmed,

    We don’t have any dataset you asked for and your question is not clear enough. Our datasets are given in the article.

    Regards
    ExcelDemy

  67. Hello Gaurav,

    You are most welcome.

    Regards
    ExcelDemy

  68. Hello Joellah,

    Thanks for your appreciation, it means a lot to us. We are trying our best to provide Excellent articles. Keep reading to boost your knowledge.

    Regards
    ExcelDemy

  69. Hello Leonardo Lagos,

    You can use the HYPERLINK function in Excel 360 online version.
    Insert the following formula in your formula bar: =HYPERLINK(“#’SheetName’!A1”, “Link Text”)

    But unfortunately, you can’t directly use the context menu to add a hyperlink to another sheet in Excel Online. You’ll need to use the formula approach described above.

    Regards
    ExcelDemy

  70. Hello Shaul Bel,

    Thanks for your appreciation. You’re welcome and I’m really glad to hear that the SUBTOTAL formula worked well for you in achieving the desired results. If you have any more questions or need further assistance with formulas or anything else, feel free to ask!

    Regards
    ExcelDemy

  71. Hello Michelle G,

    Thank you for reaching out to us. We request your attention to the above article to get your desired template on bonds purchased at a discount using the effective interest rate method.

    Your requested update is incorporated into our template. Please refer to the sheet named ‘Effective Interest (Discount)’ for the template on bonds purchased at a discount using the effective interest rate method. Click on the three dots (…) if you don’t find the template in your downloaded file.

    bond purchase sheet

    Regards
    ExcelDemy

  72. Hello Martin,

    Excel for Mac does not offer right-clicking option like Excel for Windows.
    You can double click on the macro button or you can try the control click.
    A common workaround is to delete the existing button and create a new one, typing the correct text when you first insert it. While this might seem inefficient but you can “edit” the button text.

    Regards
    ExcelDemy

  73. Hello ScubaCamper,

    Thanks for your appreciation. You are getting the error with asterisk because your formula attempts to multiply by 1 (*1) directly within the MID function’s parameters, that is not correct. You need to apply the multiplication outside of the MID function but within the array operation.

    Please try this formula:
    =TEXTJOIN(“”, TRUE, IFERROR(MID(B5, ROW(INDIRECT(“1:” & LEN(B5))), 1)* 1, “”))

    In your formula style the formula would be: textjoin(“”,true,iferror((mid([cellref],row(indirect(“1:”&LEN([cellref]))),1)*1),””))

    The purpose of multiplying by 1 (*1) in Excel formulas often is to convert text numbers to actual numeric values.

    Regards
    ExcelDemy

  74. Hello Dan,

    You can use this VBA code to delete sheet named “BETA”, from multiple Excel files which are in same folder.

    Sub DeleteSheetFromMultipleWorkbooks()
        Dim wsPath As String
        Dim wsName As String
        Dim wb As Workbook
        Dim filename As String
        Dim sheetFound As Boolean
        
        ' Folder path containing the Excel files (end with a backslash)
        wsPath = "C:\YourFolderPathHere\"
        
        ' Name of the worksheet you want to delete
        wsName = "BETA"
        
        ' File extension to look for (xlsx for modern Excel files, xls for older ones)
        filename = Dir(wsPath & "*.xlsx")
        
        Application.ScreenUpdating = False
        Application.DisplayAlerts = False
        
        While filename <> ""
            Set wb = Workbooks.Open(wsPath & filename)
            sheetFound = False
            
            On Error Resume Next
            sheetFound = Not wb.Sheets(wsName) Is Nothing
            On Error GoTo 0
            
            If sheetFound Then
                Application.DisplayAlerts = False
                wb.Sheets(wsName).Delete
                Application.DisplayAlerts = True
                wb.Save
            End If
       
            wb.Close SaveChanges:=False
            filename = Dir() ' Get next file
        Wend
        
        Application.ScreenUpdating = True
        Application.DisplayAlerts = True
        
        MsgBox "BETA Sheet is Removed"
    End Sub
    

    Regards
    ExcelDemy

  75. Hello Michelle,

    You are most welcome. Your appreciation means a lot to us.

    Regards
    ExcelDemy

  76. Hello Terry Wayne Sutfin,

    Thanks for your appreciation, it means a lot to us.

    Regards
    ExcelDemy

  77. Hello Margit,

    You are most welcome.

    Regards
    ExcelDemy

  78. Hello Jitendra Sahu,

    Thanks for your kind words. Our goal is to make Excel easy for everyone.

    Regards
    ExcelDemy

  79. Hello Melissa,

    We are glad that our article solved your problem. You are most welcome. Thanks for your appreciation.

    Regards
    ExcelDemy

  80. Hello Robert,

    You are most welcome. Thanks for your appreciation.

    Regards
    ExcelDemy

  81. Hello Ayokanmi,

    Thanks for your appreciation. You are most welcome. Our paid courses are in Udemy not in WordPress. But we have 7500++ free tutorials and 340+ YouTube videos. You can explore these learning materials for free.

    Regards
    ExcelDemy

  82. Hello Feven,

    You are most welcome.

    Regards
    ExcelDemy

  83. Hello Brent Hamilton,

    Thank you for your feedback. We used Microsoft 365 at work. We apologize for any confusion caused. The reason the “Show Changes” feature only becomes available after saving the file on OneDrive for real-time collaboration and tracking of changes. If you save it on OneDrive, it allows Excel to track changes made by different users and enables the “Show Changes” feature to display those revisions. This integration with OneDrive enhances collaboration and ensures that users can effectively manage changes made to shared documents.

    Regards
    ExcelDemy

  84. Hello David Rascati,

    You are most welcome. If you want you can share your code here so that we can debug it to find out the reason.

    Regards
    ExcelDemy

  85. Hello Mervyn,

    Thanks for visiting our blog and sharing your questions. You wanted to clarify the difference between a Table and a Dynamic Table.

    Table and Dynamic table may look similar but they are not same.
    In the context of the article,
    Regular Table – is created manually by the user within Excel’s interface.
    Dynamic Table – is generated automatically using VBA code.

    When data is turned into a table, Excel automatically adds functions like sorting, filtering, and structured referencing. These tables are dynamic and adjust automatically when the data changes.

    But a Dynamic Table in the article’s context likely refers to a table created dynamically using VBA code from a range. It is able to automatically manage specific criteria or changes.

    Regards
    ExcelDemy

  86. Hello Phil Hall,

    If you want the Excel Workbook of this article you will get it from Download Practice Workbook section.

    If you want the get the advanced exercises from “Get FREE Advanced Excel Exercises with Solutions!” button please fill your information correctly in the form. Next, you will get the exercise list in your given email. For your concern I tried it again it’s working perfectly.

    Exercise mail

    Regards
    ExcelDemy

  87. Hello Vijay,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  88. Dear RB,

    You are most welcome.

    Regards
    ExcelDemy

  89. Dear SKM,

    You are most welcome.

    Regards
    ExcelDemy

  90. Dear Sudarshan Dhuru,

    You are most welcome. Thanks for your appreciation it means a lot to us.

    Regards
    ExcelDemy

  91. Dear Xyand,

    You are most welcome. Thanks for appreciation. We updated the image of Method 6.

    Regards
    ExcelDemy

  92. Hello Saeed Anwar,

    You can download the Cheat Sheet free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.

    Best Regards
    ExcelDemy

  93. Hello Minzameera,

    Hope you are doing well. Here we calculated the overtime based on your criteria. We assumed that this time spans are for one person. If these are for different person you can modify the formula.

    Formula ta calculate working hours: =(IF(B2

    Formula

    Formula to calculate the total working hours: =C2+C3

    formula 2

    Formula to calculate the overtime, here we assumed the working hours are 8: =IF(D2>B6,D2-B6,”No Overtime”)

    overtime

    Regards
    ExcelDemy

  94. Hi Paulinus Friday,

    You are most welcome. Data Files are available in the Excel Practice file section.

    Regards
    ExcelDemy

  95. Hello ابو معاذ,

    You are most welcome.

    Regards
    ExcelDemy

  96. Hello Dwbi,

    You are most welcome.

    Regards
    ExcelDemy

  97. Hello Rao,

    We will try to upload it in our up coming videos.

    Regards
    ExcelDemy

  98. Hello Jessica H,

    You are most welcome.

    Regards
    ExcelDemy

  99. Hello Jennifer,

    You are most welcome.

    Regards
    ExcelDemy

  100. Hello Federico Cofederi,

    To send Email without pressing “Send” you can use .Send property in your code instead of .Display.

    Option Explicit
    Sub Send_Email_Condition()
        Dim xSheet As Worksheet
        Dim mAddress As String, mSubject As String, eName As String
        Dim eRow As Long, x As Long
        Set xSheet = ThisWorkbook.Sheets("Conditions")
        With xSheet
            eRow = .Cells(.Rows.Count, 5).End(xlUp).Row
            For x = 5 To eRow
                If .Cells(x, 4) >= 1 And .Cells(x, 5) = "Obama" Then
                    mAddress = .Cells(x, 3)
                    mSubject = "Request For Payment"
                    eName = .Cells(x, 2)
                    Call Send_Email_With_Multiple_Condition(mAddress, mSubject, eName)
                End If
            Next x
        End With
    End Sub
    Sub Send_Email_With_Multiple_Condition(mAddress As String, mSubject As String, eName As String)
        Dim pApp As Object
        Dim pMail As Object
        Set pApp = CreateObject("Outlook.Application")
        Set pMail = pApp.CreateItem(0)
        With pMail
            .To = mAddress
            .CC = ""
            .BCC = ""
            .Subject = mSubject
            .Body = "Mr./Mrs. " & eName & ", Please pay the due amount within the next week." _
            & vbNewLine & "The exact amount is attached with this email."
            .Attachments.Add ActiveWorkbook.FullName 'Send The File via Email
            .Send 
        End With
        Set pMail = Nothing
        Set pApp = Nothing
    End Sub
    

    Regards
    ExcelDemy

  101. Hello Obinna,

    You are most welcome.

    Regards
    ExcelDemy

  102. Hello Prakash,

    You are most welcome.

    Regards
    ExcelDemy

  103. Hello Salomé Magerstein,

    You are most welcome.

    Regards
    ExcelDemy

  104. Hello Kristi,

    You are most welcome.

    Regards
    ExcelDemy

  105. Hello Muhammad Ismail Jumarang,

    You are most welcome.

    Regards
    ExcelDemy

  106. Hello Lory,

    You can use the following formula: =IFERROR(INDEX(‘Round 1′!$B$3:$AJ$25,MATCH(A5,’Round 1’!$B$3:$B$25, 0),34),””)
    It will leave a cell blank if no matches are found.

    Regards
    ExcelDemy

  107. Hello Kndn,

    The Measuring unit of the result is “Mile”.

  108. Hello,

    You are most welcome.

    Regards
    ExcelDemy

  109. Hello,

    You are welcome.

    Regards
    ExcelDemy

  110. Dear Icarus Builders,

    You are most welcome.

    Regards
    ExcelDemy

  111. Hello Vini,

    Updated the code spilt data into multiple Excel file.

    Sub Split_Data_Multiple_Files()
        Dim L As Long
        Dim DS As Worksheet
        Dim VCL As Integer
        Dim XCL As Long
        Dim MARY As Variant
        Dim title As String
        Dim titlerow As Integer
        Dim newWorkbook As Workbook
        Dim newSheet As Worksheet
        Dim filePath As String
        
        Application.ScreenUpdating = False
        
        VCL = Application.InputBox(prompt:="Which column would you like to filter by?", title:="Filter column", Type:=1)
        Set DS = ActiveSheet
        L = DS.Cells(DS.Rows.Count, VCL).End(xlUp).Row
        title = "A1"
        titlerow = DS.Range(title).Cells(1).Row
        XCL = DS.Columns.Count
        DS.Cells(3, XCL) = "Unique"
        
        For X = 2 To L
            On Error Resume Next
            If DS.Cells(X, VCL) <> "" And Application.WorksheetFunction.Match(DS.Cells(X, VCL), DS.Columns(XCL), 0) = 0 Then
                DS.Cells(DS.Rows.Count, XCL).End(xlUp).Offset(1) = DS.Cells(X, VCL)
            End If
        Next
        
        MARY = Application.WorksheetFunction.Transpose(DS.Columns(XCL).SpecialCells(xlCellTypeConstants))
        DS.Columns(XCL).Clear
        
        For X = 2 To UBound(MARY)
            DS.Range(title).AutoFilter field:=VCL, Criteria1:=MARY(X) & ""
            Set New_Workbook = Workbooks.Add
            Set New_Sheet = newWorkbook.Sheets(1)
            DS.Range("A" & titlerow & ":A" & L).EntireRow.Copy New_Sheet.Range("A4")
            DS.AutoFilterMode = False
            New_Sheet.Columns.AutoFit
            filePath = ThisWorkbook.Path & "\" & MARY(X) & ".xlsx"
            New_Workbook.SaveAs filePath
            New_Workbook.Close False
        Next
        
        DS.Activate
        Application.ScreenUpdating = True
    End Sub
    

    Regards
    ExcelDemy

  112. Hello Syed Mohisn Ahmed,

    Updated the code in the marked section. Where I replaced “Rupees” text from condition.

    Updated Code

    You can use the following code.

    Function word(SNum As String)
    'Declare the Variables
    Dim zDPInt As Integer
    Dim zArrPlace As Variant
    Dim zRStr_Paisas As String
    Dim zNumStr As String
    Dim zP As Integer
    Dim zTemp As String
    Dim zStrTemp As String
    Dim zRStr As String
    Dim zBp As Integer
    zArrPlace = Array("", "", " Thousand ", " Lacs ", " Crores ", " Trillion ", "", "", "", "")
    On Error Resume Next
    If SNum = "" Then
      word = ""
      Exit Function
    End If
    zNumStr = Trim(Str(SNum))
    If zNumStr = "" Then
      word = ""
      Exit Function
    End If
     
    zRStr = ""
    zBp = 0
    If (zNumStr > 999999999.99) Then
        word = "Digit excced Maximum limit"
        Exit Function
    End If
    zDPInt = InStr(zNumStr, ".")
    If zDPInt > 0 Then
        If (Len(zNumStr) - zDPInt) = 1 Then
           zRStr_Paisas = word_GetT(Left(Mid(zNumStr, zDPInt + 1) & "0", 2))
        ElseIf (Len(xNumStr) - xDPInt) > 1 Then
           zRStr_Paisas = word_GetT(Left(Mid(zNumStr, zDPInt + 1), 2))
        End If
            zNumStr = Trim(Left(zNumStr, zDPInt - 1))
        End If
        zP = 1
        Do While zNumStr <> ""
            If (zP >= 2) Then
                zTemp = Right(zNumStr, 2)
            Else
                If (Len(zNumStr) = 2) Then
                    zTemp = Right(zNumStr, 2)
                ElseIf (Len(zNumStr) = 1) Then
                    zTemp = Right(zNumStr, 1)
                Else
                    zTemp = Right(zNumStr, 3)
                End If
            End If
            zStrTemp = ""
            If Val(zTemp) > 99 Then
                zStrTemp = word_GetH(Right(zTemp, 3), zBp)
                If Right(Trim(xStrTemp), 3) <> "Lac" Then
                zBp = zBp + 1
                End If
            ElseIf Val(zTemp) <= 99 And Val(zTemp) > 9 Then
                zStrTemp = word_GetT(Right(zTemp, 2))
            ElseIf Val(zTemp) < 10 Then
                zStrTemp = word_GetD(Right(zTemp, 2))
            End If
            If zStrTemp <> "" Then
                zRStr = zStrTemp & zArrPlace(zP) & zRStr
            End If
            If zP = 2 Then
                If Len(zNumStr) = 1 Then
                    zNumStr = ""
                Else
                    zNumStr = Left(zNumStr, Len(zNumStr) - 2)
                End If
           ElseIf zP = 3 Then
                If Len(zNumStr) >= 3 Then
                     zNumStr = Left(zNumStr, Len(zNumStr) - 2)
                Else
                    zNumStr = ""
                End If
            ElseIf zP = 4 Then
              zNumStr = ""
        Else
            If Len(zNumStr) <= 2 Then
            zNumStr = ""
        Else
            zNumStr = Left(zNumStr, Len(zNumStr) - 3)
            End If
        End If
            zP = zP + 1
    Loop
        If zRStr = "" Then
           zRStr = "No Rupees"
        Else
           zRStr = " Rupees " & zRStr
        End If
        If zRStr_Paisas <> "" Then
           zRStr_Paisas = " and " & zRStr_Paisas & " Paisas"
        End If
        word = zRStr & zRStr_Paisas & " Only"
        End Function
    Function word_GetH(zStrH As String, zBp As Integer)
    Dim zRStr As String
    If Val(zStrH) < 1 Then
        word_GetH = ""
        Exit Function
        'Converts a Number from 100 to 999 into Word
    Else
       zStrH = Right("000" & zStrH, 3)
       If Mid(zStrH, 1, 1) <> "0" Then
            If (zBp > 0) Then
             zRStr = word_GetD(Mid(zStrH, 1, 1)) & " Lac "
            Else
             zRStr = word_GetD(Mid(zStrH, 1, 1)) & " Hundred "
            End If
        End If
        If Mid(zStrH, 2, 1) <> "0" Then
            zRStr = zRStr & word_GetT(Mid(zStrH, 2))
        Else
            zRStr = zRStr & word_GetD(Mid(zStrH, 3))
        End If
    End If
        word_GetH = zRStr
    End Function
    Function word_GetT(zTStr As String)
        Dim zTArr1 As Variant
        Dim zTArr2 As Variant
        Dim zRStr As String
        'Converts a Number from 10 to 19 into Word
        
        zTArr1 = Array("Ten", "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eighteen", "Nineteen")
        'Converts a Number from 20 to 99 into Word
        
        zTArr2 = Array("", "Twenty", "Thirty", "Forty", "Fifty", "Sixty", "Seventy", "Eighty", "Ninety")
        Result = ""
        If Val(Left(zTStr, 1)) = 1 Then
            zRStr = zTArr1(Val(Mid(zTStr, 2, 1)))
        Else
            If Val(Left(zTStr, 1)) > 0 Then
                zRStr = zTArr2(Val(Left(zTStr, 1)) - 1)
            End If
            zRStr = zRStr & word_GetD(Right(zTStr, 1))
        End If
          word_GetT = zRStr
    End Function
    Function word_GetD(zDStr As String)
    Dim zArr_1() As Variant
    'Converts a Number from 1 to 9 into Word
    
        zArr_1 = Array(" One", " Two", " Three", " Four", " Five", " Six", " Seven", " Eight", " Nine", "")
        If Val(zDStr) > 0 Then
            word_GetD = zArr_1(Val(zDStr) - 1)
        Else
            word_GetD = ""
        End If
    End Function
    

    Regards
    ExcelDemy

  113. Hello,

    Thanks for reaching out to us.

    First, remember that rules and instructions for interest calculation after garnishment order vary among countries and states. Next, post-judgment interest accrues only on the unpaid balance of the judgment.

    However, to calculate interest if the judgment was turned into a garnishment, you can follow the steps below.
    1. Take your judgment amount and deduct the amount of garnishment.
    2. Multiply it by your post-judgment rate (%).
    3. Take the total and divide it by 365 (the number of days in a year).
    4. With the amount of post-judgment interest per day (in step 3), multiply it by the number of days from your date of judgment to the date you file your execution.

    Simply, use the following formula to calculate interest if the judgment was turned into a garnishment:
    Interest after Garnishment = (Judgment Amount – Garnished Amount) ( Interest Rate / 365) Interim Days

    Thanks again for your thoughtful comments, especially the points you made about garnishment. It adds valuable perspective to our discussion.

    Regards,
    Abdullah Al Masud,
    ExcelDemy Team

  114. Hello Muhammad Asif,

    You are most welcome.

    Regards
    ExcelDemy

  115. Hello Joseph Jabatie,

    You are welcome. You can get the notes or Excel workbook from the Download section.

    Regards
    ExcelDemy

  116. Hello Mohammed.

    Thanks for your appreciation. Our content is completely free for our users learning but don’t use it for your business purpose without proper agreement.

    Regards
    ExcelDemy

  117. Hello Mohamed Sufi,

    You are most welcome.

    Regards
    ExcelDemy

  118. Hello Jude Ranby,

    Here, the first methods Linking Existing Table on Another Sheet in Excel is duplicating the source table.

    Here, I’m attaching a video for understanding.

    Regards
    ExcelDemy

  119. Hello Smn,

    Formula of Exercise -5: =AND(G102=”Astro”,OR(C102=”Laptop”,C102=”Mobile Phone”)) is used to check multiple conditions using the AND and OR logical functions.

    Here,

    G102=”Astro”: It checks the value of G102 is equal to “Astro” or not.

    OR(C102=”Laptop”,C102=”Mobile Phone”): It checks the value of cell C102 is equal to either “Laptop” or “Mobile Phone”. Here, the OR function will return TRUE if any of the conditions are TRUE.

    AND(G102=”Astro”, OR(C102=”Laptop”, C102=”Mobile Phone”)): Here, the AND function combines the two conditions. It will return TRUE only if both/two conditions are TRUE.

    Exercise-5 solution

    Regards
    ExcelDemy

  120. Hello M-curious,

    To do a conditional formatting follow the steps of method 1. Instead of using custom option from format cells, you can use the Alignment options.
    Go to Format cells dialog box then from Alignment select any select any Alignments of your choice.

    Alignments

    Regards
    ExcelDemy

  121. Hello Dear,

    You can download the Cheat Sheet free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.

    Best Regards
    ExcelDemy

  122. Dear Anthonia Aniekule,

    You are most welcome.

    Regards
    ExcelDemy

  123. Hello Bob Leslie,

    You will get Break Even Analysis Template template in this article.

    Regards
    ExcelDemy

  124. Hello Oscar,

    Glad to hear that our blogs are helping professionals.

    Regards
    ExcelDemy

  125. Hello IDD,

    If you want real-time synchronization between the Excel file on your computer and Google Sheets, you can use the Google Drive desktop app.
    1. Download and install the Google Drive app on your computer.
    2. Sign in with the same Google account used to upload the Excel file.
    3. Copy or move the Excel file to the Google Drive folder on your computer.
    Open the Excel file from the Desktop App of Drive. Then, any changes made to the file on your computer will be automatically synced with Google Drive, and subsequently, with Google Sheets.

    Finally, open the google sheets from the Drive. You will get the updated Excel file.

    Regards
    ExcelDemy

  126. Dear Tony

    You are most welcome.

    Regards
    ExcelDemy

  127. Dear Yasin,

    You are most welcome.

    Regards
    ExcelDemy

  128. Dear OppaPanda,

    You are most welcome.

    Regards
    ExcelDemy

  129. Hello Thomas,

    Thanks for your appreciation. We are working on it.

    Regards
    ExcelDemy

  130. Dear AKhtar Khilji,

    I hope this message finds you well too. Thank you very much for your kind words and your interest in using the training material from my blog for your nonprofit Excel training program. I’m thrilled to hear that you found the content helpful and that it will be used to empower the youth of marginalized communities in Pakistan.

    I’m more than happy to grant you permission to utilize the exercises from the blog for your educational initiative. Please feel free to mention “ExcelDemy” along with the web address to provide proper attribution. It’s wonderful to know that the material will be shared with the trainees to enhance their learning experience.

    If you have any specific requests or need further assistance with anything related to the training material, please don’t hesitate to reach out. I’m here to support your efforts in any way I can.

    Wishing you great success with your Excel training program and the empowerment of the youth in marginalized communities.

    Best regards,
    ExcelDemy

  131. Hello Rahul,

    You are most welcome.

    Regards
    ExcelDemy

  132. Hello AJ,

    You are most welcome.

    Regards
    ExcelDemy

  133. Hello Ankur Vaish,

    Thanks for your suggestions.

  134. Hello Sam Arthur,

    You are most welcome.

    Regards
    ExcelDemy

  135. Dear John Summers,

    You are most welcome. Your appreciation means a lot to us to write such technical and informative article in future.

    Regards
    ExcelDemy

  136. Hello Tiffany A Snyder,

    You are most welcome.

    Regards
    ExcelDemy

  137. Hello Earlington Etienne,

    You are most welcome.

    Regards
    ExcelDemy

  138. Hello Loni,

    You are most welcome.

    Regards
    ExcelDemy

  139. Hello,

    You are most welcome.

    Regards
    ExcelDemy

  140. Hello Jane Wanjiku,

    You are most welcome.

    Regards
    ExcelDemy

  141. Hello Sandra Merlo,

    You are most welcome.

    Regards
    ExcelDemy

  142. Hello Gallienus,

    You are most welcome.

    Regards
    ExcelDemy

  143. Hello John,

    You are most welcome.

    Regards
    ExcelDemy

  144. Dear Margaret,

    You are welcome.

    Regards
    ExcelDemy

  145. Hello Akram Siddique,
    Here, in the formula : =WEEKDAY(B5,11)
    11 means – Numbers 1 (Monday) through 7 (Sunday). Here the weeks starts from Monday. So it will count the days of week from Monday and the integer value will be 1, Tuesday (2) and so on.

    day of weeks

    Regards
    ExcelDemy

  146. Hello Noelle,

    To highlight the entire row, insert the following formula: =$C5 < TODAY()

    Formula

    In applies to select the rows
    Applies to

    Regards
    ExcelDemy

  147. Dear Daniela Vognar,

    You are most welcome.

    Regards
    ExcelDemy

  148. Dear Radu Pescaru,

    Sunteți foarte bineveniți.

    Regards
    ExcelDemy

  149. Hello Patricia Pearson,

    You are most welcome.

    Regards
    ExcelDemy

  150. Hello Ehia,

    You are most welcome.

    Regards
    ExcelDemy

  151. Hello

    You are most welcome.

    Regards
    ExcelDemy

  152. Hello Chris,

    You are most welcome.

    Regards
    ExcelDemy

  153. Hello Sirajudeen,

    You are most welcome.

    Regards
    ExcelDemy

  154. Hello Patrick Opiola,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  155. Hello Mardell Daubney,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  156. Hello Dr.M. Veerendra Kumar,

    You are most welcome.

    Regards
    ExcelDemy

  157. Hello Hamed,

    You are most welcome.

    Regards
    ExcelDemy

  158. Hello AJ,

    You are most welcome.

    Regards
    ExcelDemy

  159. Hello Joedel,

    You are most welcome.

    Regards
    ExcelDemy

  160. Hello Abdul Kader Osman,

    You are most welcome.

    Regards
    ExcelDemy

  161. Dear Saiful Amin,

    You are most welcome.

    Regards
    ExcelDemy

  162. Hello Abdrman,

    You are most welcome.

    Regards
    ExcelDemy

  163. Hello Nick,

    You are most welcome.

    Regards
    ExcelDemy

  164. Hello Gianluigi,

    You are most welcome.

    Regards
    ExcelDemy

  165. Hello JC,

    You are most welcome.

    Regards
    ExcelDemy

  166. Hello JC,

    You are most welcome.

    Regards
    ExcelDemy

  167. Hello Andrii,

    You are welcome.

    Regards
    ExcelDemy

  168. Hello Syed Minhaj,

    You are most welcome.

    Regards
    ExcelDemy

  169. Hello Peter,

    So kind of you.

    Regards
    ExcelDemy

  170. Hello Nurit,

    You are most welcome.

    Regards
    ExcelDemy

  171. Hello Ava,

    Thanks

  172. Hello Tamiko,

    You are most welcome.

    Regards
    ExcelDemy

  173. Hello Huongpt,

    You are welcome.

    Regards
    ExcelDemy

  174. Hello Brenda Gale Austin-Sanders,

    You are most welcome.

    Regards
    ExcelDemy

  175. Dear Mario,

    You are most welcome.

    Regards
    ExcelDemy

  176. Hello Amanz,

    We shared our ideas with you in your ExcelDemy Forum post.

  177. Hello Adam Ingleton,

    You are most welcome.

    Regards
    ExcelDemy

  178. Hello Ani,

    You are most welcome.

    Regards
    ExcelDemy

  179. Hello Vijiaselvam Nayagam,

    You are most welcome.

    Regards
    ExcelDemy

  180. Hello Mohammad,

    You are welcome.

    Regards
    ExcelDemy

  181. Hello Suzie,

    Glad to hear that our solution helped you.

    Regards
    ExcelDemy

  182. Hello Romeo Nyi,

    You are most welcome.

    Regards
    ExcelDemy

  183. Dear Minzitia Lawrence,

    You are welcome.

    Regards
    ExcelDemy

  184. Hello Juan,

    You are most welcome.

    Regards
    ExcelDemy

  185. Dear Kagiso,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  186. Hello Azreim,

    You are most welcome.

    Regards
    ExcelDemy

  187. Thanks for your appreciation.

    Regards
    ExcelDemy

  188. Hello Lee G,

    You are most welcome.

    Regards
    ExcelDemy

  189. Hello Tanveer,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  190. Hello Mian Muhammad Saleem,

    You are most welcome.

    Regards
    ExcelDemy

  191. Hello JD,

    You are most welcome.

    Regards
    ExcelDemy

  192. Hello Eduardo,

    You are welcome.

    Regards
    ExcelDemy

  193. Dear Sam,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  194. Hello Mongwongprue Marma,

    You are welcome.

    Regards
    ExcelDemy

  195. Hello Calin,

    You are most welcome.

    Regards
    ExcelDemy

  196. Hello Adam,

    Thanks for your appreciation. You are most welcome.

    Regards
    ExcelDemy

  197. Hello Ali,

    Thanks for your appreciation. You are most welcome.

    Regards
    ExcelDemy

  198. Hello Dawood,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  199. Hello Eduardo,

    Kindly share your Excel File and images in ExcelDemy Forum.

    Regards
    ExcelDemy

  200. Hello Daniel Woods,

    To make problem sharing easier we launched ExcelDemy Forum, so that you can upload Excel Files and images of your problem. You can share your workbook in ExcelDemy Forum our expert team will reach out to you.

    Regards
    ExcelDemy

  201. Hello Daniel Woods,

    To make problem sharing easier we launched ExcelDemy Forum, so that you can upload Excel Files and images of your problem. You can share your workbook in ExcelDemy Forum our expert team will reach out to you.

    Regards
    ExcelDemy

  202. Hello Abishek,

    You are most welcome.

    Regards
    ExcelDemy

  203. Hello David,

    Thanks for your valuable suggestions.

    Regards
    ExcelDemy

  204. Hello Mike Longoria,

    You are most welcome.

    Regards
    ExcelDemy

  205. Hello Z Thomas,

    You are most welcome.

    Regards
    ExcelDemy

  206. Dear Andrija,

    You are most welcome.

    Regards
    ExcelDemy

  207. Hello Mohammed,

    Kindly share the issues you are facing while using the Excel file in the comment box. In case you need to share images, Excel file, you also can post your problem in ExcelDemy Forum.

    Regards
    ExcelDemy

  208. Hello Syifaa’ Mustafa,

    To get the Developer tab follow the steps mentioned in the article Display the Developer tab in Excel. Then you can use it to create Tooltip.

    Regards
    ExcelDemy

  209. Hello Selam,

    You are most welcome.

    Regards
    ExcelDemy

  210. Hello DanJ,

    You are most welcome.

    Regards
    ExcelDemy

  211. Hello Matt S,

    You are most welcome.

    Regards
    ExcelDemy

  212. Hello Odedele Olufemi,

    You are welcome.

    Regards
    ExcelDemy

  213. Hello Joel,

    You are most welcome.

    Regards
    ExcelDemy

  214. Hello Chanyalew,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  215. Hello Lynn,

    You are most welcome.

    Regards
    ExcelDemy

  216. Hello Nasir Ahmed,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  217. Dear Anon,

    You are most welcome.

    Regards
    ExcelDemy

  218. Hello Vickie Addo,

    We have given the answers of 100 questions in our Excel File, which is given in the Download Practice Workbook Section. As these questions are given to test your skills it won’t be helpful to check the answer immediately. A gif is given how you can test your skills at the end. Please download the Excel File and test you skills then see the answers.

    Regards
    ExcelDemy

  219. Hello Venkatesh,

    You are most welcome.

    Regards
    ExcelDemy

  220. Dear Alexandar P,

    You are most welcome.

    Regards
    ExcelDemy

  221. Hello Naziom,

    You are most welcome.

    Regards
    ExcelDemy

  222. Hello Viraltecho,

    You are most welcome.

    Regards
    ExcelDemy

  223. Hello Joel,

    You are most welcome.

    Regards
    ExcelDemy

  224. Hello,

    You are most welcome.

    Regards
    ExcelDemy

  225. Hello Suhaili,

    You don’t need to worry about payment. If you want any read-to-use template kindly send your requirements using [email protected] email.

    Regards
    ExcelDemy

  226. Dear Dave,

    You are most welcome.

    Regards
    ExcelDemy

  227. Dear Komal Thakur,

    You are most welcome.

    Regards
    ExcelDemy

  228. Hello Samia,

    In the Download Practice Workbook section, you will get the dataset used in the article.

    Regards
    ExcelDemy

  229. Hello Nafez,

    You are most welcome and thanks for you invitation to visit Qatar.

    Regards
    ExcelDemy

  230. Hello May,

    The “Developer Tab” option is missing in default Excel versions. You can enable it from Excel Options. By following this article Display the Developer Tab you can enable it easily.

    Regards
    ExcelDemy

  231. Dear Laurie,

    You are most welcome.

    Regards
    ExcelDemy

  232. Dear Sovereign,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  233. Hello Sagar,

    You will get the solutions in the Excel file, which is given in the Download Practice workbook Section.

    Regards
    ExcelDemy

  234. Dear Anusha Uppuganti,

    You are most welcome. We are so glad that our article explanation helped you.

    Regards
    ExcelDemy

  235. Dear PK,

    Thanks for your appreciation. You are most welcome.

    Regards
    ExcelDemy

  236. Hello Tsegay Gebreselasie,

    Our aim is giving you the best Excel-related content like this.

    Regards
    ExcelDemy

  237. Dear Mark,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  238. Hello Rolan,

    Thanks for your suggestion. Article is updated.

  239. Hello Damien,

    From our Download Practice Workbook section, you will get the Excel file.

    If you face any difficulties after downloading the above file, follow this article to Enable Macros but Not Working

    Regards
    ExcelDemy

  240. Hello Taiwo,

    All the solution are available in the Excel Practice file section.

    We used this formula to get discount amount: =F5*IF(D5<1,0.03,0.05)

    Comment reply

    Regards
    ExcelDemy

  241. Hi viralTecho

    Thanks for your appreciation.

    Regards
    ExcelDemy

  242. Hello James Ward,

    To run the code from Excel you can follow these steps:
    Developer tab >> Macros >> Select any Sub Procedure from the list

    Comment reply

    Regards
    ExcelDemy

  243. Hello Hugh Richards,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  244. Dear Noe Albarran,

    You are most welcome.

    Regards
    ExcelDEmy

  245. Dear Yuan,

    Thanks for the suggestions. The code is updated you can check it now.

    Regards
    ExcelDemy

  246. Dear Amir

    You have to use either the combined formula or the vba code. Because converting number to words maintaing the place vaule is not possible by simple formula.

    Regards
    ExcelDemy

  247. Dear Ian Fisher,

    You are most welcome.

    Regards
    ExcelDemy

  248. Hello Viraltecho,

    You are most welcome.

    Regards
    ExcelDemy

  249. Hello Viraltecho,

    You are most welcome.

    Regards
    ExcelDemy

  250. Dear Roberto,

    You are most welcome.

    Regards
    ExcelDemy

  251. Dear Aubrey

    You are most welcome. Your appreciation means a lot to us.

    Regards
    ExcelDemy

  252. Dear Dilip Paunikar

    You are most welcome.

    Regards
    ExcelDemy

  253. Dear Soumendra

    You are most welcome.

    Regards
    ExcelDemy

  254. Hello Manwesh,

    You can state your problem in the comment section or in our ExcelDemy Forum.

    Regards
    ExcelDemy

  255. Dear Ashab,

    We do have a YouTube channel named ExcelDemy

    Regards
    ExcelDemy

  256. Dear Evangeline,

    Thanks for your appreciation. Our experienced writers write these questions after doing a complete research about the topic.

    Regards
    ExcelDemy

  257. Dear Jason,

    You are most welcome.

    Regards
    ExcelDemy

  258. Dear Ryan,

    Glad to hear that our article helped you.

    Regards
    ExcelDemy

  259. Dear Endashaw Balcha,

    To know more about excel formula you can explore our Excel Formulas category. From here you will get practical use of different formulas in different fields.

    Regards
    ExcelDemy

  260. Dear Raf,

    You are most welcome.

    Regards
    ExcelDemy

  261. Hello Muhammad Amin,

    Good to hear that. To get more helpful contents explore our site.

    Regards
    ExcelDemy

  262. Dear Jess,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  263. Dear Jimmy,

    You are most welcome.

    Regards
    ExcelDemy

  264. Hello y2mate,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  265. Dear ytMp3,

    Thank you so much.

    Regards
    ExcelDemy

  266. Dear Martin Carrion,

    You are most welcome.

    Regards
    ExcelDemy

  267. Dear Dina,

    Thank you so much for your appreciation.

    Regards
    ExcelDemy

  268. Dear Navini,

    You are most welcome.

    Regards
    ExcelDemy

  269. Dear Gopi Sahu,

    Thanks for reaching out to us. You will get various types of WFM related articles here Excel Solver

    If you need solution of any specific topic kindly comment down below.

    Regards
    ExcelDemy

  270. Dear Justice,

    You are most welcome.

    Regards
    ExcelDemy

  271. Dear Merry,

    You are most welcome.

    Regards
    ExcelDemy

  272. Dear Karen,

    You are most welcome.

    Regards
    ExcelDemy

  273. Hi Putul ch. Borah,

    Yes, you can do it by following the mentioned steps.

  274. Dear Tiago,

    You are most welcome.

    Regards
    ExcelDemy

  275. Dera Ashok,

    You are most welcome.

    Regards
    ExcelDemy

  276. Dear Foysal,

    You are most welcome.

    Regards
    ExcelDemy

  277. Dear kinyapreen,

    To get virtual lessons you can follow our youtube channel Youtube Channel

    Regards
    ExcelDemy

  278. Hello BART,

    It is possible to add a VB line of code to run the selection change code only when you click the tab of the worksheet called “index.” To achieve this, you can use the Worksheet_Activate event in the code module of the “index” worksheet. Here’s the code.

    Private Sub Worksheet_Activate()
        Dim mVCount As Integer
        Dim mHCount As Integer
        Dim mVBreak As VPageBreak
        Dim mHBreak As HPageBreak
        Dim mNumPage As Integer
        
        mHCount = 1
        mVCount = 1
        
        If ActiveSheet.PageSetup.Order = xlDownThenOver Then
            mHCount = ActiveSheet.HPageBreaks.Count + 1
        Else
            mVCount = ActiveSheet.VPageBreaks.Count + 1
        End If
        
        mNumPage = 1
        
        For Each mVBreak In ActiveSheet.VPageBreaks
            If mVBreak.Location.Column > ActiveCell.Column Then Exit For
            mNumPage = mNumPage + mHCount
        Next
        
        For Each mHBreak In ActiveSheet.HPageBreaks
            If mHBreak.Location.Row > ActiveCell.Row Then Exit For
            mNumPage = mNumPage + mVCount
        Next
        
        ThisWorkbook.Worksheets("Worksheet 1").Range("I2").Value = "Page " & mNumPage & " of " & Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
        ThisWorkbook.Worksheets("Worksheet 3").Range("C5").Value = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
    End Sub
    

    Regards
    Alif Bin Hussain

  279. Dear,

    You are most welcome.

    Regards
    ExcelDemy

  280. Dear Bart,

    You are most welcome. Sure, you can inform us.

    Regards
    ExcelDemy

  281. Dear Najeeburk,

    You are most welcome.

    Regards
    ExcelDemy

  282. Dear Danny Van Straten,

    If you need any types of customized templates you may contact us through [email protected]
    We have a expert team to create any types of professional templates.

    Regards
    ExcelDemy

  283. Hello Yaojm,

    Thanks for your suggestions. Here we focused on the comparison/difference of VLOOKUP and XLOOKUPp that’s why we didn’t improvised the use of VLOOKUP.

    Regards
    ExcelDemy

  284. Hello Pankaj,

    You are welcome.

    Regards
    ExcelDemy

  285. Dear Charlotte,

    You are most welcome.

    Regards
    ExcelDemy

  286. Dear Mustafa,

    You are most welcome.

    Regards
    ExcelDemy

  287. Hello Abubakar,

    You are most welcome. We hope so you will be able to create an interim certificate template following these steps.

    Regards
    ExcelDemy

  288. Dear B,

    You are welcome.

    Regards
    ExcelDemy

  289. Dear Akash,

    You are most welcome.

    Regards
    ExcelDemy

  290. Dear Carl,

    You are most welcome.

    Regards
    ExcelDemy

  291. Hello Dear,

    You can download the Cheat Sheet free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.

    Best Regards
    ExcelDemy

  292. Dear Macel Williams,

    To customize any templates you can contact with us via this mail problem @exceldemy.com

    Regards
    ExcelDemy

  293. Dear Macel Williams,

    To customize any templates you can contact with us via this mail problem @exceldemy.com

    Regards
    ExcelDemy

  294. Dear Qasim,

    Thanks for your suggestions we have updated our Exercise 3 you can check it now.

    Regards
    ExcelDemy

  295. Dear Kenny H,

    This Email address is valid but if you face any problem you can post your problem in our ExcelDemy Forum.

    Regards
    ExcelDemy

  296. Dear Nikhil Pandey,

    You will get all the solutions in the workbook’s Solution sheet. Here I’m giving you the query answer for your understanding.

    The Formula is : =WEEKDAY(B5,11)

    Get-Weekday

    Regards
    ExcelDemy

  297. Dear Nikhil Pandey,

    You will get the solution sheet in the Download Practice Files section. Download the workbook there in Solution sheet you will get all the solutions. You you can get the workbook from this link Solution Sheet

    Regards
    ExcelDemy

  298. Dear Aiden,

    Yes you can do that.

    Regards
    ExcelDemy

  299. Dear Macel,

    You are welcome.

    Regards
    ExcelDemy

  300. Dear Marc,

    You are welcome.

    Regards
    ExcelDemy

  301. Dear Kim,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  302. Dear Prakash Tulsiani,

    You are most welcome.

    Regards
    ExcelDemy

  303. Dear Kay,

    To get a customized templates you can contact with us through this Email: [email protected]

    Regards
    ExcelDemy

  304. Hello Dear,

    You can download the Excel and PDF files free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.

    Best Regards
    ExcelDemy

  305. Dear Nadew w/yesus,

    You are most welcome.

    Regards
    ExcelDemy

  306. Dear Dr,

    You are most welcome.

    Regards
    ExcelDemy

  307. Dear Adil Ahmed,

    You are most welcome.

    Regards
    ExcelDemy

  308. Dear Macel Williams,

    You are most welcome.

    Regards
    ExcelDemy

  309. Hello Dear,

    You can download the Cheat Sheet free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.

    Best Regards
    ExcelDemy

  310. Dear Isaac,

    You are most welcome.

    Regards
    ExcelDemy

  311. Dear MADI,
    Thank you for following our article.
    To split into sheets based on certain row conditions, we have to enter an IF condition that checks if the row is of a certain colour. Here, I have added the code to do this.

    Sub SplitSheetByGreenColor()
        Dim Rng As Range
        Dim xRow As Range
        Dim SplitRow As Integer
        Dim xSheet As Worksheet
        Dim i As Integer
        Dim resizeCount As Integer
        
        On Error Resume Next
        xTitleId = "ExcelSplit"
        Set Rng = Application.Selection
        Set Rng = Application.InputBox("Range", xTitleId, Rng.Address, Type:=8)
        SplitRow = Application.InputBox("Row Number Split", xTitleId, 5, Type:=1)
        Set xSheet = Rng.Parent
        Set xRow = Rng.Rows(1)
        Application.ScreenUpdating = False
        
        For i = 1 To Rng.Rows.Count Step SplitRow
            resizeCount = SplitRow
            If (Rng.Rows.Count - xRow.Row + 1) < SplitRow Then resizeCount = Rng.Rows.Count - xRow.Row + 1
            
            If xRow.Cells(1).Interior.Color = RGB(0, 255, 0) Then
                xRow.Resize(resizeCount).Copy
                Application.Worksheets.Add after:=Application.Worksheets(Application.Worksheets.Count)
                Application.ActiveSheet.Range("A1").PasteSpecial
            End If
            
            For j = 2 To Worksheets.Count
            Worksheets(j).Name = "Green" & j - 1
            Next j
    
            Set xRow = xRow.Offset(SplitRow)
        Next
        
        Application.CutCopyMode = False
        Application.ScreenUpdating = True
    End Sub

    This code checks if the interior colour of the first cell in each row of the selected range is Green(RGB(0,255,0)). The entire row is copied and pasted into a new sheet if rows meet the condition. You can alter this colour condition according to your need.

    Regards
    Priti

  312. Dear Sara,

    You will find the solutions in the Excel file which is given in Download Practice Workbook section.

    Regards
    ExcelDemy

  313. Dear Sakshi,

    You are most welcome.

    Regards
    ExcelDemy

  314. Dear Md. Morshed Alam,

    You are most welcome.

    Regards
    ExcelDemy

  315. Dear Alex,

    Thanks for your feedback.

    Regards
    Exceldemy

  316. Dear Paresh Kanti Paul,

    We are glad to hear that.

    Regards
    ExcelDemy

  317. Hello Dear,

    You can download the Excel and PDF files free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.

    Best Regards
    ExcelDemy

  318. Dear Sushil,

    You are most welcome.

    Regards
    ExcelDemy

  319. Dear Duncan R Walk,

    You are most welcome.

    Regards
    ExcelDemy

  320. Dear Bolajoko Olufemi,

    You will get all resources related to Data Analysis here All About Data Analysis. We are planning to launch courses as soon as possible.

    Regards
    ExcelDemy

  321. Dear Ronald,

    You are most welcome.

    Regards
    ExcelDemy

  322. Dear Ronhat Minmin,

    If you want to get the Excel File, you can download it from Download Practice Workbook

    Regards
    ExcelDemy

  323. Dear Ebrahim Ahmadi,

    You are welcome.

    Regards
    ExcelDemy

  324. Hello Dear,

    You can download the Excel and PDF files free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.

    Best Regards
    ExcelDemy

  325. Dear Lin Giralt,

    You are most welcome.

    Regards
    ExcelDemy

  326. Dear Khin Soe,

    You are most welcome.

    Regards
    ExcelDemy

  327. Dear Tha’ir,

    You are most welcome.

    Regards
    ExcelDemy

  328. Dear Mohamad,

    Thanks for your appreciation

    Regards
    ExcelDemy

  329. Dear Minhajul,

    You are most welcome.

    Regards
    ExcelDemy

  330. Dear Sandeep Bhattacharjee,

    You are most welcome and thanks for your appreciation.

    Regards
    ExcelDemy

  331. Hello Sujay Jain,

    You can download the Excel and PDF files free of cost just by providing your valid email address. To get the files go to the Top 100 MCQ of Excel section of this post and enter your email address. Then check your email immediately after to get the download links.

    Best Regards
    ExcelDemy

  332. Dear S Roy,

    You are most welcome.

    Regards
    ExcelDemy

  333. Hi Kazem,

    You are welcome.

    Regards
    ExcelDemy

  334. Dear Lana,

    You are most welcome.

    Regards
    ExcelDemy

  335. Dear Seamus Madden,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  336. Hi Ndonwi,

    Thanks

  337. Dera Merc,

    You are most welcome.

    Regards
    ExcelDemy

  338. Dear Joanna,

    You are most welcome.

    Regards
    ExcelDemy

  339. Dear Richard,

    You are most welcome.

    Regards
    ExcelDemy

  340. Dear Andrei,

    These functions are available in WPS office.

    Regards
    ExcelDemy

  341. Dear Kapil,

    You are most welcome.

    Regards
    ExcelDemy

  342. Dear Tommy Fuifui,

    You are most welcome.

    Regards
    ExcelDemy

  343. Dear Excel Nob,

    You are most welcome.

    Regards
    ExcelDemy

  344. Dear Car,

    You are most welcome.

    Regards
    ExcelDemy

  345. Dear Jamie,

    You are most welcome.

    Regards
    ExcelDemy

  346. Dear Anitelleth,

    You are most welcome.

    Regards
    ExcelDemy

  347. Dear Anitelleth,

    You are most welcome.

    Regards
    ExcelDemy

  348. Dear Kay,

    You are welcome.

    Regards
    ExcelDemy

  349. Dear Pirooz Rahimi,

    You are most welcome and thanks for your appreciation.

    Regards
    ExcelDemy

  350. Dear Abel,

    Thanks for your appreciation. You are most welcome.

    Regards
    ExcelDemy

  351. Dear Kh Paydar,

    You are most welcome.

    Regards
    ExcelDemy

  352. Dear Joris,

    You are most welcome. We are glad to hear that.

    Regards
    ExcelDemy

  353. Dear Raja,

    You are most welcome.

    Regards
    ExcelDemy

  354. Dear Kapil,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  355. Dear Polepeddi Sasidhar,

    We are glad to hear that.

    Regards
    ExcelDemy

  356. Hello Silpa,

    You can download the Excel and PDF files free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.

    Best Regards
    ExcelDemy

  357. Dear Jidith Savidge,

    You are most welcome.

    Regards
    ExcelDemy

  358. Dear Ajij Nadaf,

    We will love to give you suggestions. kindly share your problem.

    Regards
    ExcelDemy

  359. Good day, Daniel,

    The issue you’re having might be because your workbook’s data range differs from the data range specified in our code.

    Change the data range according to your worksheet.

    This might be the solution to your issue. I’d appreciate it if you could send me the worksheet you’re working on so that I can better understand your issue and give you an exact solution.

    Regards
    Sakibul Hasan Nahid | ExcelDemy Team

  360. Hey Philip,

    Thanks for your response. You can use the SORT and FILTER functions along with the LARGE function to solve your problem.
    Here’s the practice sheet we used. You can check it out for a better understanding.
    SORT-FILTER.xlsx
    You can also check out this article for more detailed explanations.
    https://www.exceldemy.com/excel-top-10-list-with-duplicates/

    Regards
    Hassan Shuvo| ExcelDemy Team

  361. Hello Chandan,

    Thanks for commenting. If I’m not wrong, you want to match the dataset like the one below.

    Select the entire dataset without the heading then go to conditional formatting >> New Rule

    Then select “Use a formula to determine which cells to format.”
    In the formula bar, enter the following formula:
    =AND(A3<>B3,C3<>B3)
    Press OK

    Here, “A3” represents the cell containing the customer name, “B3” represents the cell containing the ID name, and “C3” represents the cell containing the real name. You can adjust the cell references based on your data.
    Choose the formatting option that you want to use for the highlighted rows. For example, we took light green color here for highlighting.
    The final outcome will look like the image below.

    I hope this answer will help you to identify matched names. Please let us know if you have any other queries. Also, you can post your Excel-related problem in ExcelDemy Forum with images or Excel workbooks.

    Regards
    Mizbahul Abedin | ExcelDemy Team

  362. Dear MD. KAMAL HOSSAIN,

    To obtain your required format please follow the following simple steps:
    From your Excel Workbook, press ALT + F11 to open Visual Basic Editor.
    Insert a module.
    Paste the following code:

    Function NumberToWords(ByVal Number As Long) As String
        Dim Ones() As String
        Dim Tens() As String
        Dim Group() As String
        Dim Result As String
        
        Ones = Split("One,Two,Three,Four,Five,Six,Seven,Eight,Nine", ",")
        Tens = Split("Ten,Eleven,Twelve,Thirteen,Fourteen,Fifteen,Sixteen,Seventeen,Eighteen,Nineteen", ",")
        Group = Split("Twenty,Thirty,Forty,Fifty,Sixty,Seventy,Eighty,Ninety", ",")
        
        If Number = 0 Then ' Handle zero
            Result = ""
        ElseIf Number < 10 Then
            Result = Ones(Number - 1)
        ElseIf Number < 20 Then
            Result = Tens(Number - 10)
        ElseIf Number < 100 Then
            If Number Mod 10 = 0 Then ' Handle multiples of 10
                Result = Group(Int(Number / 10) - 2)
            Else
                Result = Group(Int(Number / 10) - 2) & " " & Ones(Number Mod 10 - 1)
            End If
        ElseIf Number < 1000 Then
            Result = Ones(Int(Number / 100) - 1) & " Hundred " & NumberToWords(Number Mod 100)
        ElseIf Number < 1000000 Then
            Result = NumberToWords(Int(Number / 1000)) & " Thousand " & NumberToWords(Number Mod 1000)
        ElseIf Number < 1000000000 Then
            Result = NumberToWords(Int(Number / 1000000)) & " Million " & NumberToWords(Number Mod 1000000)
        Else
            Result = "Number is too large."
        End If
        
        NumberToWords = Trim(Result)
    End Function

    Now, return to your worksheet. Type in the following formula in the cell where you require the output and press Enter key.
    =NumberToWords(B5) & ” Taka Only”
    Here, B5 indicates the reference of the cell where you have the input number.

    converting numbers to words

    I hope this solution will be sufficient for your requirements. Let us know your feedback.

    Regards,
    ExcelDemy

  363. Dear Rich Saunders,

    Query 1: The method 7 works just fine. If you write March in F4, you will get the values for that month as well.

    Query 2: The formula is universal for any Excel version. If you write the formula in any cell the formula will get you the entire row value for the name you will write in the F4 cell. For example, if you write “Nathan” in F4 cell and paste the formula in the A1 cell then the formula will write the values of the entire row( B8:D8) in the A1:A3 range.
    Yes, we should have mentioned the Ctrl+Shift+Enter in the article. We will make sure of that in the next articles. As we used Microsoft 365 so it works by pressing Enter. We are sorry for that.

    Regards
    ExcelDemy

  364. Dear Tudor,

    Hope you are doing well. Answer of your questions are given below with explanation.

    1. How can I change the month and day from English to Romanian?

    Select the cell with month and date, cell C7 in our case.
    Right-click with the mouse and select Format Cells.

    monthly staff attendance

    In the Format Cells window, select Romanian (Moldova) under the Locale menu.
    Then, select any type under the Type menu and click the OK button.

    The month and date are changed into Romanian from English. Do the same process for cell E7.

    2. If an employee works on Saturday and/or Sunday, how can I collect those weekend hours separately, in a cell?

    Let’s say the first employee works on Saturday and Sunday for 5 and 6 hours respectively. He works on 4 weekends which you can see in the picture. To sum these values we’ll use the SUMIFS function.
    Apply the formula in any cell where you want the weekend hours, let’s say cell AM11-
    =SUMIFS($F$11:$AJ$11,$F$11:$AJ$11,"<>P",$F$11:$AJ$11,"<>A")

    After pressing Enter you’ll get the total weekend hours. You can use the Fill Handle tool to apply this formula to other employees.

  365. Dear Aspen,

    You are most welcome.

    Regards
    ExcelDemy

  366. Thanks for your suggestions.

  367. Dear Victor,

    You are most welcome.

    Regards
    ExcelDemy

  368. Dear Elizabeth,

    You are most welcome. We are so glad that our article fulfilled your need.

    Regards
    ExcelDemy

  369. Dear Anjli Gupta,

    Answers are given in the Solution sheet of Excel File which is in Download Practice Workbook section.
    Answer sheet

    Soluation-of-Advanced-MCQs-for-Exam

    Regards
    ExcelDemy

  370. Dear HG,

    You are most welcome.

    Regards
    ExcelDemy

  371. Dear Seaunders,

    Thanks for your appreciation. It means a lot to us.

    Regards
    ExcelDemy

  372. Dear Gunawan,

    Thanks for your suggestions. We updated the article. You can check it now.

    Regards
    ExcelDemy

  373. Hi Fake Hidden,

    Thanks for your suggestions. We updated our article so that it fulfills the need of all types of readers. You may check our article now and let us know any kinds of suggestions.

    Regards
    ExcelDemy

  374. Dear Rafi,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  375. Dear Elly,

    Thanks for your appreciation. We re-explained our formulas to make them more understandable. If you find any difficulty now, let us know in the comment section below.

    Regards
    ExcelDemy

  376. Dear Rashmi,

    You are most welcome.

    Regards
    ExcelDemy

  377. Dear Jay Dee,

    That’s good to hear. We are interested to know more from you.

    Regards
    ExcelDemy

  378. Dear Silver,

    You are most welcome.

    Regards
    ExcelDemy

  379. Dear William B,

    You are most welcome.

    Regards
    ExcelDemy

  380. Dear Eugen Safta,

    You are most welcome.

    Regards
    Shamima Sultana | ExcelDemy

  381. Dear Radu,

    Thanks for your suggestion and we appreciate it. We updated the cell range.

  382. Dear Sanket,

    Thanks for your appreciation.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  383. Dear Yar Zar Htun,

    You are most welcome. We are glad that through ExcelDemy you are improving your skill.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  384. Dear Vivasvan,

    You are most welcome. It’s great to know that our article helped you to complete your project.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  385. Dear Bo Thibaut,

    We are willing to do any Excel-related projects. Kindly share your requirements through this Email: [email protected]

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  386. Hi Robert Bakinam,

    Here, you will get the full copy in pdf Marking Result Sheet.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  387. Dear German,

    You are most welcome. To get solutions with detailed explanations, follow ExcelDemy.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  388. Dear Kirsten Wheeler,

    Thanks for your appreciation. To get solutions with detailed explanations, follow ExcelDemy.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  389. Dear NancyM,

    Thanks for your appreciation. To get solutions with detailed explanations, follow ExcelDemy.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  390. Dear CJvW,

    Thanks for your appreciation. To get more helpful content be with ExcelDemy.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  391. Dear Geogre,

    Thanks for your kind attention and suggestion. We updated it.

  392. Dear Michael Gamal Aziz,

    You are most welcome.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  393. Dear Glenn,

    We are glad to hear that. ExcelDemy is trying hard to give you quality content.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  394. Dear Uday Kumar,

    We are working on your problem. We will appreciate you to post your problem in our ExcelDemy Forum.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  395. Dear Ramandeep Kaur,

    Thanks for your appreciation. Sooner we will make another exercise based on Basic and Advanced Formulas.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  396. Dear Datla Srinivas,

    We are working on your requirements. We hope we will come back to you with your expected solutions.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  397. Dear Mody,

    Thanks for your appreciation.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  398. Hello Joanie,

    You are most welcome.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  399. Dear Map,

    Thanks for your appreciation and suggestion. Sooner we will write an article regarding this topic.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  400. Dear Ven Upekkha,

    Thanks for your appreciation.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  401. Dear Rajesh,

    You are welcome.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  402. Dear umit,

    Thanks for your appreciation it means a lot to us.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  403. Hello Zuri,

    Thanks for your suggestion.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  404. Dear Carl,

    Thanks for your appreciation. ExcelDemy is glad to help you.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  405. Dear Sandra Aldridge,

    Thanks for your appreciation it means a lot to us. ExcelDemy is glad to help you.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  406. Dear Micah,

    Thanks for your kind words. ExcelDemy is dedicated to provide solutions to help you.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  407. Dear Mukibul Hasan,

    Thanks for your appreciation. Stay in touch with ExcelDemy.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  408. Dear Shanmuga Raja V S,

    Thanks for your appreciation. Stay in touch with ExcelDemy.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  409. Dear Adam,

    Thanks for your appreciation.

    Shamima | Project Manager | ExcelDemy

  410. Dear Zidane,

    Thanks for your appreciation.

    Shamima | Project Manager | ExcelDemy

  411. Dear Kayla,

    Thanks for your appreciation and we are glad that our Dataset Template helped you.

    Regards
    Shamima | Project Manager | ExcelDemy

  412. Hello Uday Kumar,

    Kindly check the reply to your previous comment. We have given you a non-macro solution.

  413. Dear Forte,

    Thanks for your appreciation. Stay in touch with ExcelDemy to get more helpful content.

    Regards
    Shamima | Project Manager | ExcelDemy

  414. Dear Gilson,

    Thanks for your appreciation. Stay in touch with ExcelDemy to get more helpful content.

    Regards
    Shamima | Project Manager | ExcelDemy

  415. Dear Gerry Conroy,

    You are most welcome.

    Regards
    Shamima | Project Manager | ExcelDemy

  416. Dear Syed Anwar Hussain,

    Thanks for your appreciation.

    Regards
    Shamima | Project Manager | ExcelDemy

  417. Hello, Xzavier!

    For better understanding, we updated the article. Kindly check it now it would be helpful.

    Regards
    ExcelDemy

  418. Hello, An!

    You are most welcome. To get helpful content follow ExcelDemy.

    Regards
    ExcelDemy

  419. Hello, James!

    Your appreciation means a lot to us. To have a more wonderful experience follow ExcelDemy.

    Regards
    ExcelDemy

  420. Hi Rassulsson!

    Thanks for your appreciation.

    Regards
    ExcelDemy

  421. Thanks, Michael, for your query. From your comment, it seems that you want to permanently assign the replacing dataset (denoted by Reprng in the code) instead of taking them in a prompted input box. You can do that by following the steps below.

    1. First, set a Name to the range that contains the Find & Replace with columns (In this case E5:F6). To do that, select the range and type a suitable name on the Name Box. Suppose you give the name “Find_Replace_Array”
    2. Now, open a new module and write the given code of method 1.
    3. Then, on the code, replace the line :

    Set Reprng = Application.InputBox(“Replace with: “, Title, Type:=8)

    With the following line.

    Set Reprng = Range(“Find_Replace_Array”)

    Now, if you run the code, you will only need to select the range where you want to replace values and it will automatically replace the values for you. Here, you will not be required to manually input the address of Find_Replace_Array.

    Hope it does the job for you. If you have any further queries, do let us know. Moreover, if your problem persists, you can post your problem in our Exceldemy Forum along with your Excel file.

  422. Hello, Hamza!

    Thanks for your appreciation. We are glad that our article helped you.

    Regards
    ExcelDemy

  423. Hello, A!

    If your file is protected by using Encrypt with Password feature then it won’t work. We mentioned it in the Things to Remember section.

    Regards
    ExcelDemy

  424. Hello, Nabil sellami!

    Thanks for your appreciation. To get more enjoyable articles stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  425. Hello, JeteMc!

    Welcome, JeteMc. To get more helpful information stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  426. Hello, Helen!

    Thanks for your appreciation. To get more helpful information stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  427. Hi, Irene!

    Thanks for your appreciation. To get more helpful information stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  428. Hi, Elton!

    Thanks for your appreciation. We will try to launch pdf files.

    Regards
    ExcelDemy

  429. Hello, Muhammad Luqman!

    You can download it from Download Excel Formulas Cheat Sheet PDF section.

    Regards
    ExcelDemy

  430. Hi, Bosco!

    Thanks for your appreciation. To get more informative contents stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  431. Hello, Joe Smith!

    The 64-bit version of Excel is not compatible with 32-bit active x controls. To know more about it you can visit this site

    Regards
    ExcelDemy

  432. Hello, Aleksandra!

    Thanks for your appreciation.

    Regards
    ExcelDemy

  433. Hello, Bennie!

    Thanks for your appreciation.

    Regards
    ExcelDemy

  434. Hello, Harry!

    You can download the copy from Download Sample Workbook

    Regards
    ExcelDemy

  435. Hello, Emil Lazar!

    Thanks for your appreciation. Stay in touch with ExcelDemy to get more useful articles.

    Regards
    ExcelDemy