@Riny, Thanks for pointing this out, works indeed, makes it much easier
The offset part is what makes the validation list dynamic, you add a new item to the table it automatically updates it. I've been using this method...
Take a look here. Add a new item to your table and check if the dropdownlist is updated
Hi Frans, What's the Excel version you're using? You could add a dynamic named range to include the new data you enter in the table using the UN...
@Nick: there are no stupid questions. You learn by asking and you learn too by answering
I agree entirely, macros (VBA) is the only way to accomplish this. BTW: please mention the Excel version you're using
I have no idea of all these calculations but the formula in column G you have now does not really seem to work In G6 I did the following and COUNTI...
Julian that much I understood, and as I see it it does that now. I entered values today july 17 between the min and the max and they are not shown ...
Hi julian, Got the file, if I understand you correctly you want to update the comment every time a new value is entered that is not already present...
Hi, can you tell us which version of Excel you're using? I might try and paste your code in a new file but if you have a file, I suggest you attach...
I also suggest you tell us the Excel version you're using
I also suggest you tell us the Excel version you're using
Thanks for the upfate, I'll keep it in mind
Hi Jorge, First I suggest you include the Excel version you're using. Secondly a sample file will tell us more than words
Good day Kelly, How about a sample file? The image you attached is unavailable. Don't forget to mentio the Excel version you're using