Search results

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

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

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

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

Hello, I have a spreadsheet with the following formula in O13: =SUMPRODUCT((D13=MASTER[ name])*(H13=MASTER[[#Headers];[1]:[20]]);MASTER[[1]:[20]]) In H13, the "value" is based on the list from 1 to 20 that is =MASTER[[1]:[20] I have the little green triangle in the top left corner of that...

Hello, I have this spreadsheet that use a pivot table to sort out my data by type (item) and displays them from their highest value to the lowest. Manually, I copy all these tables, paste them in another worksheet, use a conditional formatting to highlight the duplicates and then, starting...

Hello, I'm facing in any issue in a quite large spreadsheet I created. In a worksheet (say "worksheet A"), I have a table where in columns B C D E, I have various color choices (say "red", "blue", "green", "black", etc...) and where column F is my helper column, which combine the text value of...

Hello, After hours trying to understand a little bit of array to do what I wanted, I find myself stuck again with INDEX and MATCH. I'm actually not sure I'm using the right formulae :-s So here's my setup in the file attached. The worksheet "MASTER" is my ... welll ... master table. This is...

Hello, I have been pulling my hair for a while with this, so hopefully someone can help. here's my setup: tab "MASTER" Starting in A2 and down, I have a list of unique ID In C2 and down, primary colors In D2 and down, secondary colors In E2 and down, tertiary colors In F2 and down, quaternary...

Hello, I have a problem with a conditional formatting in a spreadsheet I made for work. In short, it calculate time for a meeting and display the local time based on the timezone of each participant. What I have is this: G7: typical working day start = 08:00:00 formatted as time H11: adjusted...

Hello, I finally registered after using the info on your site for a while. I've been asked to create a vacation calendar for an international team. I downloaded the template you made, but it was too complicated for me to edit, and too complex for our needs. My company's VPN does not allow...