Search results

Hey Have you tried using custom sorting? there you can put several arguments for filtreing, it is available on the sort & filter drop down icon, shortcut in 2010 is 'Alt,H,S,U' cheers

Hey again o/ Regarding Fred's posting. I must admit that I do not feel I got there to where I can use pencil, but I can certainly see your point, and from your point of view, some things are more obvious than for example for me. I can see it now:) I'm just sometimes too stupid and too lazy...

Hey guys Just looked at you'r formula Luke, and after a little tweak I've got my desired Error. here is the formula: =IF(ISNUMBER(A2);IF(E2="";IF(TODAY()<A2;0;TODAY()-A2);IF(E2<C2;"Error";E2-A2));"") Next desired step is to convert the negative counter into positive 'where...

Any Idea how to solv this? thanks in advance

Thanks for the fast reply Fred I was staring me blind, after all began adding more collums until the equation, and I probably lost track. I will return as soon as I got little sleep:) cheers

Hey all I'm working with some mind mumbling "If's" atm, I have collum (A) as the esteminated date, (C) as the ready date,(B) as the caounter between collum(A&C). Formula I use in (B) is: =IF(ISNUMBER(A2);IF(C2="";A2-TODAY();A2-C2);"") as far as good, but in collum (E)I have the real engage...

Hey all o/ I'm writing from denmark,and I use excel to manage our componets together wtih our production line. I will like to thank Chandoo for making this awsome site, and I also have my first issue where I need you'r sharp brain to look at it. Best Regarts Philip o/