Search results

Luke, It works now. Made a mistake in copying the last part of the formula... I changed the row with columns in the last part of the formula and the output is like this now: Column AB Column AC Column AD 120 200 15 130 210 200 15 210 15 So...

Luke, It is not working as described above. In which column is the output supposed to be printed? Is that A1? With your suggestion the output is still only printed in column AB and the output is different than it was with the original formula as shown below...

Luke, Sorry for not phrasing this more clearly. Here's an example that will hopefully clarify what I mean (refer to the example in one of our previous conversations). Right now the output in column AB is like this (only values <> 10 are printed): Column K Column L Column AB 10...

Luke, It's really amazing to see how this works!! Now to make it even more sophisticated is it possible to do the following: Column K contain values either equal to 10 or >10, so with the formula above each set of data matching the criteria is printed below each other in column AB. Is it...

Luke, Many thanks! It works now and your answer has been of great help. However in case I want to expand the selection criteria by adding another IF statement I seem to get into trouble. This is how I set up the formula...

Dear Hui, Thanks for your quick reply. I tried the techniques described by Luke M and it actually works if the criteria is set to a fixed number or a text string (in the example it was "Vetgetable" But I would like to filter only those values that are not equal to the criterion. In the...

Hi I am wondering if you can help me with this: I have file with several columns. Column B contains cells that equals a value of 10 or has values > 10. Column C contains data that is corresponding to the value in column B. Now I would like to retrieve only those numbers from column C...