Posts by jl2509

    HI NBVC


    Thanks for the repsonse


    Sorry, I though I was clear on that.


    If the number is below 200 then show a response of "Low"

    If the number is equal to or greater than 200 but below 400 then show a response of "Medium"

    If the number is equal to or greater than 400 but below 800 then show a response of "Medium High"

    If the number is equal to or greater than 800 and below 1000 then show a response of "High"

    If the number is equal to or greater than 1000 then show "Very High"


    Thank you

    Hi All


    Any thoughts on a formula that gives a different output for a range of numbers.


    i.e.


    A1 contains a value from 0 to 1000

    A formula in A2 should follow the following scenario:


    If the number is below 200 then show a response of "Low"

    If the number is equal to or greater than 200 but below 400 then show a response of "Medium"

    If the number is equal to or greater than 400 but below 800 then show a response of "Medium High"

    If the number is equal to or greater than 800 and below 1000 then show a response of "High"

    If the number is equal to or greater than 1000 then show "Very High"


    Any help is much appreciated


    Thank you

    Thank guys, I used KjBox's suggestion to remove the "zeros" and Ingo_Ingo's suggestion with the array formula to create a new list of selections made.


    KjBox, I did appreciate your first response and please don't think I am not grateful, but we are not all as clever as you pros's when it comes to VBA and Array formulas, I just wanted something easier to modify and the array formula was just the ticket.


    Great work as always, keep it up


    Thank you

    Thanks for the response and although this is a great solution, it does not work for me in my intended worksheets.
    The sample sheet was as named "a Sample" and there are more columns and data to be included and extracted using the method I was originally implementing.


    Using your macro is not easy for me to understand or to edit.


    Is there a solution to my original post request?


    Thank you

    Hi All


    Attached is a sample workbook which I hope explains my requirements.
    Basically, I am trying to create a list of selections made in a column, in another column but without the row spaces.


    Also, I need a way to remove the zeros from an indirect function as shown on the sample sheet.


    Any help is much appreciated



    Thank you

    Files

    • Sample.xlsm

      (19.58 kB, downloaded 12 times, last: )

    Hi All,


    Cant seem to get the correct formula here to set a conditional format.


    I only want cells in a row highlighted if the cell above has a date in it.


    Hopefully the sample sheet attached will explain.


    Any help appreciated


    Thanks

    Files

    • Sample.xlsx

      (9.63 kB, downloaded 10 times, last: )

    Hi All


    Attached is worksheet which I hope is clear for my latest challenge.


    I would like to auto fill dates based on a start and end date
    then
    auto fill the row below with a linear burn down based on a start value and an end value of zero.


    Any help appreciated.


    Thanks

    Hi Carim


    No worries, I managed to modify it.
    I guess that's the problem with sample sheets, unless the structure is identical, there could be issues in transposing solutions to the final worksheet.


    Appreciate the help again


    Thanks

    Hi All


    Attached is a sample sheet with tasks to be completed.
    They all have unique IDs, Status and completion dates


    On Sheet 2, I would like to show the tasks that are to be completed for the date (today) shown in B3 and an entire list of open tasks.


    However, I would like this to be concatenated into once cell if at all possible.


    Sample data on sheet 2 what I would like to be shown is in RED


    There are limitations here though as this is Excel 2013 and you cannot use "TEXTJOIN"


    Any help please.

    Hi
    Assuming you want to calculate the cumulative lognormal distribution, you can use the following.


    =LOGNORM.DIST(x,mean,standard_dev,cumulative)


    The LOGNORM.DIST function uses the following arguments:

    • X (required argument) It is the value at which we wish to evaluate the function.
    • Mean (required argument) It is the mean of In(x).
    • Standard_dev (required argument) It is the standard deviation of In(x).
    • Cumulative (optional argument) It specifies the type of distribution to be used. It can be either TRUE (implies the cumulative distribution function) or FALSE (implies the normal probability density function).

    Sample data (x, mean, SD) shown below.


    [ATTACH=JSON]{"alt":"Click image for larger version Name:\tLND.jpg Views:\t1 Size:\t23.4 KB ID:\t1214996","data-align":"none","data-attachmentid":"1214996","data-size":"full","title":"LND.jpg"}[/ATTACH]



    a few links to follow up with


    https://www.excelfunctions.net/excel...-function.html
    https://support.office.com/en-us/art...b-6074aee6b070