Md. Abdur Rahim Rasel

Hello RAVI
Thank you for your comment. When you are identifying the specific text from a string using Excel formulas, the specific text is known by you. So, I think if the return of the Excel formulas is TRUE you will be able to identify that specific text otherwise it returns FALSE. That’s why I think the above formula is appropriate to find out the specific text from a string. According to your question, I will introduce you to an efficient Excel function named the IF function to get the specific text. The IF function is,
=IF(E4=”YES”,D4,”Unable to Find Result”)
Look at the below screenshot.

For the convenience of your work, please download the below Excel file which is provided by Exceldemy:
https://www.exceldemy.com/wp-content/uploads/2022/08/Excel-If-Range-of-Cells-Contains-Specific-Text.xlsx
If the answer doesn’t fulfill your query, feel free to comment. Our Exceldemy Team is always there to help.

Hello JACK,
You can easily do that using the Custom Sort command. Let’s follow the instructions below:
Let’s Sales volumes less than 40 are marked with low performance. Sales volumes greater than 40 but less than 60 are marked with medium performance. Sales volumes greater than 60 are marked with high performance.
First of all, select cells range E5 to F14, and press right-click. As a result, a window pops up. From that window select Custom Sort under the Sort option.

After that, do like the below screenshot.

Finally, you will get your desired output.

Please download the below Excel file for your practice.
https://www.exceldemy.com/wp-content/uploads/2022/08/Advanced-Sorting-Options.xlsx
Thank you for your comment.
Regards
Md. Abdur Rahim Rasel(Exceldemy Team)

Hi AHMAD KHAN!
This article is how to Convert Formula to Value Without Paste Special in Excel. You can convert Formula in Value using the Keyboard shortcuts(F9), Right-Click Drag Down Option, Notepad to Convert Formula in Value, VBA code, Power Query, and so on. One suitable example is given below regarding your questions.
Suppose we have a data set that contains securing marks and results on Physics of several students of XYZ school. If a student secures less than 50, his/her result will Fail, and more than or equal to 50, his/her result will Pass. We will apply the IF function to do that. Let’s follow the instructions below.
First of all, select the formula in the Formula bar, then press F9.

As a result, you will be able to convert the formula to value without paste special.

Please repeat the procedure for the rest of the cells in column D.
Please download the Excel file for your practice.
https://www.exceldemy.com/wp-content/uploads/2022/09/Convert-Formula-to-Value-Without-Paste-Special.xlsx
Thank you for your comment.
Personal Email for sending your Excel sheet: [email protected]
Regards
Md. Abdur Rahim Rasel (Exceldemy Team)

Hello VADAKKUS!
To get the Stocks of the Indian Index instead of the NASDAQ Index, please use the below link in Method 3. The link is: https://www.moneycontrol.com/markets/indian-indices/
Thank you for your comment.
Regards
Md. Abdur Rahim Rasel (Exceldemy Team)

Hello, ROB!
Thanks for sharing your problem with us!
Let’s say, we have a dataset that contains several projects and project managers. You can know how many projects are shared among each pair of project managers by applying the IF, COUNTIF, ROW, INDEX, and SMALL functions. Hence, you can concatenate the projects with project managers using the Ampersand symbol.
Let’s follow the instructions below to solve your problem!
→ First of all, Select cell F5 and write down the below screenshot’s functions in that cell. Hence, press Enter on your keyboard to get your desired output.
=IF(COUNTIF($B$4:$B$16,$E$5)>=ROWS($1:1),INDEX($C$4:$C$16,SMALL(IF($B$4:$B$16=$E$5,ROW($4:$16)),ROW(1:1))),"")

→ Further, AutoFill the functions to the rest of the cells in column F.

→ Now, we will concatenate a project and the project managers under that project. Insert the below formula into the formula bar.
=$E$5&" "&F5

→ Hence, AutoFill the formula to the rest of the cells in column G.

Please download the Excel file for your practice.
https://www.exceldemy.com/wp-content/uploads/2022/10/COUNTIF-with-Multiple-Criteria.xlsx
Again Thank you for your comment.
Regards
Md. Abdur Rahim Rasel
Exceldemy Team

Hello UMESH!
Thanks for reaching out and sharing your problem with us.
let’s break down the given formula =PRODUCT(SUM(B5:B14),SUM(C5:C14)) and provide a deeper interpretation:

SUM(B5:B14): calculates the sum of the values in the range from cell B5 to B14. It adds up all the numbers in that specified range.

SUM(C5:C14): calculates the sum of the values in the range from cell C5 to C14. It adds up all the numbers in that specified range.

=PRODUCT(SUM(B5:B14),SUM(C5:C14))
The outer PRODUCT function takes the results of the two SUM functions and multiplies them together. In other words, it multiplies the sum of values in range B5:B14 by the sum of values in range C5:C14.
When you AutoFill the above formula, it will automatically create relative cell references within a similar data range.
If you want to get the total product result in a single cell, use absolute cell references instead of relative cell references in the above formula. Then, use the following formula instead of the one above
=PRODUCT(SUM($B$5:$B$14),SUM($C$5:$C$14))
Again, thank you for being with us.
Regards
Md. Abdur Rahim Rasel
Exceldemy Team

Dear Anton!
Thanks for reaching out and sharing your problem with us.
No, you can not set the color of negative numbers using hex values directly in the custom number format in Excel. The custom number format in Excel has predefined color names such as [Red], [Green], etc., but it doesn’t support specifying colors using hex values.
Again, thank you for being with us.
Regards
Md. Abdur Rahim Rasel
Exceldemy Team

Hello PAUL!
Thanks for your feedback.
You can use the following VBA code to change “IsNumeric” to “IsText” for composing the text values instead of numeric values.

Dim R As Range
Private Sub Worksheet_Change(ByVal Target As Range)
	On Error Resume Next
	If Target.Cells.Count > 1 Then Exit Sub
	Set R = Intersect(Range("D6"), Target)
	If R Is Nothing Then Exit Sub
    
	' Check if the new value in the changed cell is a text string
	If IsText(Target.Value) Then
    	Call send_mail_outlook
	End If
End Sub

Sub send_mail_outlook()
	Dim x As Object
	Dim y As Object
	Dim z As String
    
	Set x = CreateObject("Outlook.Application")
	Set y = x.CreateItem(0)
    
	z = "Hello!" & vbNewLine & vbNewLine & _
    	"Hope you are well" & vbNewLine & _
    	"Visit our Exceldemy site"
    
	On Error Resume Next
	With y
    	.To = "Address"
    	.cc = ""
    	.BCC = ""
    	.Subject = "send mail based on cell value"
    	.Body = z
    	.Display
	End With
	On Error GoTo 0
    
	Set y = Nothing
	Set x = Nothing
End Sub

Please download the Excel file for solving your problem and practice with it.
Send Email Automatically.xlsm
If you are still facing issues, please mail us at the address below.
[email protected]
Again, thank you for being with us.
Regards
Md. Abdur Rahim Rasel
Exceldemy Team

Hi MEAGAN!
You can set the below VBA code to send an email if D1>7 but also send an email if D5>2. The VBA code is:

Dim R As Range
Private Sub Worksheet_Change(ByVal Target As Range)
	On Error Resume Next
	If Target.Cells.Count > 1 Then Exit Sub
	Set R = Intersect(Range("D1,D5"), Target) ' Combine D1 and D5 ranges
	If R Is Nothing Then Exit Sub
	If IsNumeric(Target.Value) Then
    	If (Target.Address = "$D$1" And Target.Value > 7) Or (Target.Address = "$D$5" And Target.Value > 2) Then
        	Call send_mail_outlook
    	End If
	End If
End Sub

Sub send_mail_outlook()
	Dim x As Object
	Dim y As Object
	Dim z As String
	Set x = CreateObject("Outlook.Application")
	Set y = x.CreateItem(0)
	z = "Hello!" & vbNewLine & vbNewLine & _
    	"Hope you are well" & vbNewLine & _
    	"Visit our Exceldemy site"
	On Error Resume Next
	With y
    	.To = "Address"
    	.cc = ""
    	.BCC = ""
    	.Subject = "send mail based on cell value"
    	.Body = z
    	.Display
	End With
	On Error GoTo 0
	Set y = Nothing
	Set x = Nothing
End Sub

Please download the Excel file for solving your problem and practice with it.
Automatically Send Emails from Excel Based on Cell Content.xlsm
If you cannot solve your problem, please mail us at the address below.
[email protected]
Thank you for being with us.
Regards
Md. Abdur Rahim Rasel
Exceldemy Team

Hello IRINA!
Thanks for sharing your problem with us!
It would be better for us if you shared your Excel dataset to help us better understand your problem.
Don’t worry! I have created an Excel file to fix your problem. I have solved your problem based on the current working days. I have calculated the Progress of the work & the Estimated Days of the work (which represent the total days of working), and Working Days (the actual working days at that moment).
Please download the Excel file to solve your problem and practice with it.
Dates Calculation.xlsx
If you cannot solve your problem, please mail us at the address below.
[email protected]
You can also leave your problem on our Forum site.
Regards
Md. Abdur Rahim Rasel
Exceldemy Team

Hi SANDEEP KOTHARI!
I have not encountered any problems while using MD. If you face any problems, please send us your Excel file.
Thank you for being with us.

Regards
Md. Abdur Rahim Rasel
Exceldemy Team

Hi TONY!
We checked the Excel file. It is working fine for an even and uneven amount of characters. Make sure the TRIM function and the text to the column are entered correctly. We suggest you download the file and practice there. If you are unable to solve your problem, you can also share your Excel file with us.
Thank you for being with us.

Regards
Md. Abdur Rahim Rasel(Exceldemy Team)

Hello, SAJNA!
Thanks for your query!
I think you want to know about the fixed balance instead of faxed balance.
In a daily cash book, a fixed balance refers to a predetermined amount of money that remains constant throughout a specific period, such as a day. This fixed balance represents the starting cash on hand at the beginning of the day and is not affected by daily transactions. It is typically used to track and reconcile cash inflows and outflows accurately.
For example, let’s say a company starts the day with $1,000 in its cash register. This initial amount of $1,000 would be recorded as the fixed balance in the daily cash book. Throughout the day, various transactions occur, such as cash sales, cash expenses, and withdrawals. These transactions are recorded in the cash book, and the fixed balance is adjusted accordingly.
At the end of the day, let’s assume the company made $700 in cash sales, paid $200 in cash expenses, and withdrew $300 for petty cash. Despite these transactions, the fixed balance in the cash book would still remain $1,000. The final balance in the cash book would be calculated by adding or subtracting the daily transactions from the fixed balance. In this example, the final balance would be $1,000 + $700 – $200 – $300 = $1,200.
The fixed balance in the daily cash book helps ensure that the cash position is accurately tracked, and any discrepancies can be easily identified during the reconciliation process.
Regards
Md. Abdur Rahim Rasel (Exceldemy Team)

Hi GABRIEL!
Thank you for your comment.
The RATE function does not work for some combinations. In these cases, the #NUM! error occurs. To solve this error simply add the Type and the Guess arguments in the RATE function. For Type, 0 or omitted is used for at the end of the period and 1 is used for at the beginning of the period. If RATE does not converge, try different values for the guess. RATE usually converges if the guess is between 0 and 1.
Using these two arguments, you can solve the #NUM! Error. Look at the below screenshot.

Please download the Excel file for your practice.
https://www.exceldemy.com/wp-content/uploads/2022/09/Calculate-Yield-to-Maturity.xlsx
Regards
Md. Abdur Rahim Rasel (Exceldemy Team)