Recent content by kinkart

sorry, I'm not getting it. let me try to rephrase: I need to distribute a certain amount over a period of time. For this year and next year, I want to know exactly per month. From 2023 to 2026, per year. After, I don't care whether it's in 2027 or 2059. If I have 1,000 to distribute between...

complex as in multiple tabs, managed by multiple people (editors) and used by 100s of users. I guess for most of the experts on chandoo it wouldn't be considered complex, but it is for us :-) So using formula that most editors understand (vs VB) would be beneficial. One thing I notice on your...

I simplified the layout in my example file, the original file is a lot bigger and complex, with other macros. If something similar could be achieved with formula, would be better for my org

thank you vletm! this works really well. But since I'm a complete newbie with macros, do you know if the same result could be achieved with formulas?

I need to use that format, it use in other places

Hi, I'd like to distribute a value across month and year: the next 2 years are monthly distributed, the years after are yearly. Attached is what i meant + a few scenarios. cells in ligh yellow are manula input, everything else is (should) be calculated. I've tried a few things, but my brain...

Hello, can someone please point me to the right tutorial or explain how I could have a dropdown that adjust the number of row to be included in the chart, but also tickboxes or other dropdown that add additional data to the existing chart (merge the chart on the left while adding the bars from...

perfect, thanks!

Hi, I'd like to know what is the formula I can use to automate column E in the exemple attached. I could try with a bunch of IF and OR, but is there something more elegant and less resource intensive that I could use? Thanks

thanks, will try that

Hi, I've read a few posts but can't figure it out. I have the attached table (simplified but then I just need help to understand the principle). I cannot change the layout of the table in rows 2-3-4-5. But I need to find what is the max value for each items (yellow cells). I manually entered...

wow, that was quick and perfect! Thank you Somendra!

that would be the difference from the previous X (22:00) and this one (8:00). From 10pm (or 22:00) to 8am, there is 10 hours. It's what I can automate.

Hello, I have a day table (see sample file) where one can put an X anywhere on row 4. Based on this, I'd like to automate the time difference between 2 "X"'s on row 5 so that my vlookup on row 6 pulls out the correct value. I've tried various ways including changing the format to time, but none...

great! thank you!