Search results

Somendra, that's fantastic :) Exactly something that i was hoping for. Thanks a lot.

Hi, i am trying to create an excel presentation form in which you can select 2 (or more) parameters, and the form would allow you to rotate through the available results. In the attached file, i made a mock up of what i am looking for. You can select on priority, and on status, and depending...

Hi everybody, This is a followup of a previous question that i asked a couple of months ago ( http://chandoo.org/forum/threads/work-time-calculation.12074/#post-70952 ) i have added the resulting file after the thread discussion, because i seem to have run into a weird situation, where the...

Thank you for the help Sir and Narayan. Your formula works, but could you please explain me how? I seem to have difficulty's understanding array formulas, and although it seems like a simple formula, i don't see how it works. Thanks

Hi, i was trying to achieve the following. In my attached file, i have 23 columns. Each column has either a number, or is empty. each column also refers to a separate table (not included in file) If there is a number in a column, then i would have to extract something next to the ID of 1 of the...

thnx Jake, that works perfectly

Hi, my situation is as follows. We have 3 columns Column A has dates of different facility's Column B has different incidents Column C has different dates. I am looking for a way to have the max (and maybe min) amount of days between certain incidents for each facility. So, for example...

Hi everybody, i was wondering if there was a way to achieve the following. column A i have names, B i have Date start, and C i have Date end. These columns are put in a table. Is it possible to use the Calender control to fill in the cells when you select them? I was thinking about linking...

Hi Sajan, It looks like it is working, but i will be honest, i'm lost in the formula. o_O I have no experience using the mmult command, and i'm staring at it, and it doesn't enter the brain :D (need more coffee i think) This in combination with the min/max you are using,.... Could you please...

Hi Sajan. You are correct in your assumptions, but i would assume that the start day would be the request day +1 (if the request is received at noon, or in the evening). The hours would be spend between Sep 2 and Sep 30, but divided over working days (not weekends).

Hello everybody, I am looking for a way to achieve the following. I have an excel table that gets filled as we process through the year. It contains the requested jobs, the day the job request was recieved, the day that it due, and the estimated time it would take to complete the job. i will...

Sure :) the page is protected, and as you will be able to see, you can use the data validation. But you can't paste in the cells Hope this helps out

Hi, I usually use a workaround for this problem. I have the data validation in 1 column, and put that column in unprotected. Then i select the next column, and put that protected. Then i merge the two columns. i protect the worksheet, and voilà. You can use the data validation, but you can not...

Many thanks Narayan. I really appreciate the effort you put into this.

Hi Narayan, I was just wondering if you might have made some progress with this issue. Thank you in advance

Hi Narayan, The use of VBA will be the only solution in the end i think. The other request i have made on the same day is also to be integreted with this document, so i guess VBA will be unavoidable. If it takes a couple of days, it won't be a problem. Thank you for your effort Pofski

Hi Narayan, thank you already for your example. The idea is that eventually all the information (tables and languages are on a different tab, and that the O3 till O10 would be part of a growing list. Every time that there would be a new project, we would add to the list, and translators could...

Hi Narayan, i prefer to avoid VBA where possible, but if this would be the best solution, then there is no choice. I included a small example file. the only thing that really has to be taken into account, is the fact that the available statuses can change (grow or shrink), and the files...

Ok, example added

Sorry about that Nar, i will get to it, right away. Also for the second post i made

Hi everybody, I was wondering if it was possible to make a drop down that is semi automatic, but still manually changeable. for example, you have a drop down list in B1, When you fill in something in A1, it automatically changes to "Started" (for example), you can still manually change it to...

Hello everybody, I am trying to achieve the following. I have in column A a list of names. In column B, C and D i have a list of languages these ppl speak. Some speak 3 languages (or more), some only 2. Now on a separate page i have a list of source languages (A), and a list of target next...

Thnx guys :)

Hello everybody, I was wondering if there was a way to combine checkboxes. Lets say that you have a list of 10 checkboxes, underneath each other. Each individually is linked to a cell for a TRUE, FALSE statement. Would it be possible to make a list of 5 check boxes next to it, that would...

Hi everybody, after going over the date manually, we have come to the conclusion that the remark that SirJB7 made, is in fact correct. There is no certainty that those date's that are automatically registered as "correct" dates, are in fact correct. Although the end of year number would be...