Hi all,
This forum is really helpful for novices like me. Currently struck with an
issue which goes as...

i have 3 col like date, cust number, quote ref. In quote ref i have a
formula "(COUNTIF($D$4:D16,D16)" to generate a number for the a customer,
what i am looking is this should be done on Date basis, in other words, i
should get a new quote number if the date changes

May be my example should give you clear idea,
Date (dd/mm/yyyy) Cust No. Quote Ref
01/10/2008 4628A 001
15/10/2008 4670B 001
16/10/2008 4628A 002

and so on,

Thanks in advance