Its OK Anish, I can understand the frustration...
I am also sorry for my hard words..
CHEERS!!
Andy
On Fri, Nov 13, 2009 at 9:09 PM, Anish Shrivastava wrote:
> Thanks Aindril for your help.
>
> N GROUP ...M REALLY SORRY For what I wrote...trust me I realized it later
> tht it wasnt a right way..
Thanks Aindril for your help.
N GROUP ...M REALLY SORRY For what I wrote...trust me I realized it later
tht it wasnt a right way...was kinda frustrated in office.. :(
On 11/13/09, Aindril De wrote:
>
> Dear Anish,
>
> You would need a UDF for this:
>
> Use the following code :
>
> Option Explic
Hi Anish,
See the attached file. Don't change position of 'Auto Reset', 'Counter' and
'Auto Switch' else it may not work properly.
Also it can be done easily with VBA, so if you need then ask the solution in
VBA and you will get a quick response from the group.
Regards
Sandeep
On Fri, Nov 13, 2
Hi Punit,
Thanks for you helping attempt, but tht's not wht I want. You used just
vlookup in 2 cells...I m afraid to say tht but even I know tht much of
basics (No offence). Could you please let me know wht if the occurance is 3
times. :P
Cheers!!
ANISH
On Fri, Nov 13, 2009 at 3:06 PM, punit pod
Hi
You can use the file attached below:
Punit
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http:/
Hello Experts,
Once agian I am here with a new problem (Thanks for helping me earlier, on
my code).
This time I am stuck with Vlookup, actually I have a list of lot # for which
I have to find TIC # from another table but the problem is it has got
multiple occurances. Our simple vlookup picks the
