• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    Get the latest value from a table

    What does 9^9 do here?
  2. S

    Get the latest value from a table

    Please help me achieve this. Material Month Price Latest Price A Jan 10 B Jan 2 2 C Jan 4 D Jan 5 5 A Feb 8 8 C Mar 22 C April 19 19
  3. S

    Statically method to find out an expected value

    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
  4. S

    Average if with grouping

    You are a genius!:)
  5. S

    Average if with grouping

    Please help me achieve this! Name Month Sal Average ABC Jan 2 ABC Feb 4 ABC Mar 6 4 XYZ Jan 5 XYZ Feb 10 XYZ Mar 15 10
  6. S

    Minimum by group with formulas

    Thanks. Works a treat!
  7. S

    Minimum by group with formulas

    Please help me achieve this!
  8. S

    #VALUE! Error

    It is XL function. I resolved it. Thanks
  9. S

    #VALUE! Error

    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)
  10. S

    #VALUE! Error

    Here is the sample file
  11. S

    #VALUE! Error

    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...
  12. S

    Open two links at once from one hyperlink function

    Hi All, Is it possible to open two links at once from an Hyerlink function. Example: =Hyperlink("https://chandoo.org/ "&"https://stackoverflow.com/ ") Thanks
  13. S

    Conditional Average

    Amazing. It worked!. Thanks
  14. S

    Conditional Average

    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'
  15. S

    Predicting future values to meet the target

    Can we do it with the help of any formulas ?. If yes please provide me the formula
  16. S

    Predicting future values to meet the target

    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
  17. S

    Calculating the working hours based on Today's date and Next day

    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...
  18. S

    Calculating the working hours based on Today's date and Next day

    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
  19. S

    Sending Email with attachment

    You are amazing. Now It is perfectly all right.
  20. S

    Sending Email with attachment

    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?
  21. S

    Sending Email with attachment

    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...
  22. S

    Sending Email with attachment

    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...
  23. S

    Vlookup with Closet match from other column

    Thank you for the reply. It works.Do we have any Array free solution since array formals are not supported in Xcelcisus(An SAP dashboard making tool)
  24. S

    Vlookup with Closet match from other column

    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...
Back
Top