Can someone help me with a method to identify the ideal price in the below scenario to reach the volume of 1700?.. How to achieve this?
Year
Price
Volume
2018
4.75
1500
2022
6.03
1300
It should encode the text so that it will be used as an URL.. The whole logic is with that formula I should be able to create a dynamic url which users can click on..
Without encoding: This is test
with encoding : This%20is%20test( This is fit for URL creation)
I get #VALUE! with this formula
HYPERLINK(HYPERLINK(Config!$B$9&"/"&SUBSTITUTE(TEXT(E38,"MM/D/YYYYY"),"/","_")&"/"&ENCODEURL(Config!$B$10))&"/"&ENCODEURL(A38&".msg","Click")
Config!$B$9= https://kt001-kt.kell.com/:u:/r/sites/AAFAA3444/Connectivity/Connectivity Controls Audit...
Hi All,
Is it possible to open two links at once from an Hyerlink function.
Example: =Hyperlink("https://chandoo.org/ "&"https://stackoverflow.com/ ")
Thanks
How to achieve conditional average. I need average wherever there is "D" , When there is no "D" then it has to calculate the average for "R1".
Thanks
santhosha'
Hi All,
Please help me on predicting the future values based on the existing to meet the target value. I have explained my problem in the attached workbook.
Thanks
santhosha
You are a life saver. Million thanks to you. One last help. Can we have a one more column in front of it which should show me the exact date of resultant row. What it means is though the formula is showing Next day date but i want to consider it for previous day.Say for example 9/26/2015...
Happy New Year to All...
I need to derive the the working hours based on the specific time interval. I have explained my problem in the attached workbook. I need a formula to achieve. I have tried my best but with no luck.your help on this is greatly appreciated.
Thanks
santhosha
This works with one exception. I have to click send button in outlook which is very tedious as i have around 150 emails to send out every week. Can we automate that too?
Deepak. Thank you for your swift reply but unfortunately it is not working as i intended. What i need to do is sending the file based the email id provided in one of the column. It should pick the exact file and send it the respective users. The solution you gave me just create the email...
Hi All,
Here is a solution that exactly matches my requirement on splitting the file. This split the files based on sale person provided in the column(http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/). After the file is split i want to send out the emails to the respective sales...
Hi All,
I have come across a situation where i should be able to do a lookup which can give me the results when it doesn't find a value in particular column by taking a closest match from the same column.
For example I have 3 columns Year, month, salary respectively. I am trying to get the...