Search results

Marc, thank you for your help as well. I failed to check out your link, but i will still use it for potential future issue's.

Hui, thank you for your help. I managed to adapt your solution to fit completely in our project.

Formula's (which i would personally prefer to use) are not an option in the situation that this file will be used in. Would also recommend using the index/match lookup in place of vlookup for such things.

in my example, the numbers on the sheet "Data" should be completed with the information that can be found on the sheet "Reference".

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

Narayan, the information that is now in the second drop down should fill in the area I3:I66. This is because this information would be compared with another list of filtered information, to check for differences. Interesting way how you did this though. Never thought to do it like that.

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

.... Like i said, i feel stupid now :) Thanks Narayan, will use a substitute to transform all the "," to ".". Sincerely

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

Fantastic Somendra, now i understand this. And your code is actually a lot simpler. Thank you

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, If you would like the cells to just remain blank, in stead of giving the #value! error, you could just put existing formulas in an iferror. An example would be the D5 formula: =IFERROR(IF($B5>0,C5/($B5*$B5),""),"") Hope this is what you are looking for.

i think you've got it Narayan. It looks correct, and i did seem to have made a mistake in row 16. Thanks a lot, you guys really helped me out again. This is why i love this forum.

free to be implemented.

Unfortunately no Narayan. The company that i work for prefers to not implement vba in their excel sheets. I realise that this does not make it easier.

let's take row 11 as the first example 3 measurements ago, the reading was FALSE. Because of this, we would need 3 readings TRUE, before the statement becomes completely true again. We already have 2 time TRUE (C11 and D11), so we need 1 more TRUE (E11 states that we need 1 more) Row 12 The...

Hello Misra, the solution should appear in E9:E26. At thiss moment, the numbers that are filled in there are to give a correct representation of what the solution should look like. Thanks for looking at this.

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

ok, NOW i get it :) Thnx a bunch. I never thought about just using the sumifs function, and have always been using the array formula. Again, thanks a lot. I got the file to work thanks to you

Luke, this is fantastic already, thank you. At the moment i am implementing the changes that you made to the original document to see where it ends up. Just one question, In your file in the columns M, N, O, you are using a combination of sumif and countif, and to be honest, i don't see how it...

Hi, first of, i would like to apologize for the remark "To make it easier". It was meant sarcastically, but i am aware that it is easy to misinterpret the sarcasm through written word. I do mean that it is more difficult. Unfortunately, the data can not be delivered in another way, as these...

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

thanks Xig :) If there's no score, the area should be left empty, but i will put an if formula on top of your array formula. Thanks a lot for your help, it's fantastic.

So, this is a sample file of what i am looking for. The data is to be found in column A to D. I made a collection of all available options from I5 till M14, and underneath that, the score card that will have to be linked to the table data.

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