Search results

Hi, I am looking for a vb code that would run through column A on the first worksheet, and looks up each reference number in column A of the second worksheet. After this, if it would find the number in the second list, it should copy the line of information next to the reference number of the...

Hello everybody, i remember seeing this somewhere here before, but i seem to be unable to find it. I am trying to create a dynamic list between two values In the attached example you would be able to select a continent (I1), and then all the countries of that continent would be below. Now i...

Hi, this will prolly be something stupid, but here goes. I have a sheet where i have to put some calculations, but for some reason, when i have a number with a "," it doesn't want to be recognized as a number. I tried different things already (putting it as =text(a1,"@"), or using the format...

Hello, i was wondering if somebody could explain a formula to me. I have been using this formula for almost a year now, and to be honest, whenever i have to re use it, i often wonder how it works. The formula i am speaking of is...

Hi, i need some help, because for some reason i am feeling really stupid atm there are 3 cells (A,B,C) if a result is good, the cell of that result turns TRUE if bad it is FALSE. Each week there is a check, the cells change. If a cell becomes bad, it has to be checked daily, until it becomes...

Hi everybody, Would anybody be able to help me with the following problem (see attached file) What i am trying to obtain is the following. We have a list (column A, B, C and D) that contains location, item, date and result. I was looking for a way to have the last 3 results from each...

Hello everybody, i was wondering if there is somebody who could help me with the following problem. I have a table with multiple conditions. I would need to find a large (and small) in a table, depending on what is filled in in the first two rows. Now, the row where the large has to come from...

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

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

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

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

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

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

Quick question, i am doing an extraction of date's out of a txt file. now, after the extraction is done, i have a list of dates, but i notice that some of them are in european format, and some are in american format. So that makes it that it shows some dates as completed on 4th december...

Hi everybody. I was just wondering if somebody would know why the option to calculate that is located at the bottom left of the screen (underneath the tabs, next to the word ready) sometimes is visible, and sometimes isn't. At this moment i have a pretty big calculation sheet, and when i...

Hi everybody, just a quick question. Does anybody know of a way that you could integrate a sort of selection of table in a formula? For example, you have a cell that goes from 1 to 5 and in a formula (for example =SUMIFS(Table1[ActualOpen];Table1[Request Service...

Hello again everybody; I am trying to achieve the following. I have a row with unique id's. In a column next to that row i would like to have a formula that automatically puts a 1 if the id isn't found in any of the tabs that contain data.( i have included an example, because I know that it...

Hi everybody, i seem to have got stuck on a date calculation. ok, so i have 1 column with date, and another column with a recurrence indicator in the form of for example 6 M (6 months) or 80 D (80 days) or 7 W (7 weeks). These numbers varies. Now, what i need to get is a column with the...

Hi, i've been trying to use the guidelines showed here http://chandoo.org/wp/2010/11/02/multi-condition-lookup/ to do a filtering depending on 2 different criteria. But for some reason i keep getting the #value result, no matter which way i use. Is it that these different possibility's only...

Hi, i'm a bit stuck at the moment with a bit of a logical problem. https://docs.google.com/file/d/0B0naOkYo4pCmZkNtSHlEUnNWQk0/edit?usp=sharing Now, in the above file you see that i have a column with due date, a column with Last serviced, and a Column with interval. I'm looking for a way...

Hi, I was wondering if the following is possible. You have a list with conditional formatting with cells that changes the colors depending on any given parameter. Is it possible to have another list with different columns that get filled in with the data from the first list depending on the...