Posts by jl2509

Perfect thank you

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

Dang, I was looking too deep and trying if statements

Lesson learned Master, "keep it simple"...

Much appreciated

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

HI Carim

Once again, a great solution.

Your assistance is much appreciated.

Thanks

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

Just a thought though,

The actual sheet 1 has more columns and sheet 2 cells are in different locations, would the UDF need modifying?

Hi Carim

Welcome back, seems like you have been away for ages...

Thanks for the UDF, it works a treat.

Nice work

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.

Attach the xls(x) file to this thread not a dropbox please. You may get some assistance then.
People do not like downloading from Dropbox due to Virus etc.

Happy to help

Thanks for the like

Hi

Is the traffic light and actual "Traffic Light" image (3 off) with the relevant light lit up (RYG), or just an object that could be changed in colour (RYG) rather than having 3 different images to play with?

Hi,

Using the standard protection in excel is not very secure and is easily overcome with a little know ho or an off the shelf product for password recovery.
There are methods to protect your hard work but come at a price.

Take a look at the link below for some explanations and a potential solution.

https://www.thespreadsheetguru…oject-password-protection

hope this helps

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

Try this
=if(H9=0,0,(D4+D5+D6+D7+D8)-C27-C32-C28)