N Numb7r New Member Sep 21, 2012 #26 Hi!! The only change that i see is that Type 3=1 only in the month due for example: D14=12/20/2012....the result should be: F=0 G=0 H=0 I=1
Hi!! The only change that i see is that Type 3=1 only in the month due for example: D14=12/20/2012....the result should be: F=0 G=0 H=0 I=1
N NARAYANK991 Excel Ninja Sep 21, 2012 #27 Hi , Can you check this ? https://docs.google.com/open?id=0B0KMpuzr3MTVTERQZmRBcHc0RDQ I have added one more condition to check for type <> 3. Narayan
Hi , Can you check this ? https://docs.google.com/open?id=0B0KMpuzr3MTVTERQZmRBcHc0RDQ I have added one more condition to check for type <> 3. Narayan
N Numb7r New Member Sep 21, 2012 #28 Whoa! thats looks great!! Thanks!! I'm going to try it on my actual data file and see how it goes. Thank you very much for your help!If you accept donations let me know =)
Whoa! thats looks great!! Thanks!! I'm going to try it on my actual data file and see how it goes. Thank you very much for your help!If you accept donations let me know =)