Max,
Did exactly how u advised (changed the formula pointers also) the result is
as follows :
Col A Col B Col C Col D Col E Col F Col G
Sl No Date Cust Name Cust Code Cust Ref Quote Ref
1 10/09/2008 ABC 610000-RO Tele.conv 1 001
2 23/09/2008 ABC 611900 Tele.conv 1 002
3 26/09/2008 ABC 610902 E-mail 1 003
4 26/09/2008 ABC 611700 Tele.conv "" 003
5 26/09/2008 ABC 611700 Tele.conv "" 003
6 26/09/2008 ABC 611700 Tele.conv "" 003
7 26/09/2008 ABC 611702 Tele.conv 003
8 26/09/2008 ABC 611702 Tele.conv 003
9 27/09/2008 ABC 610409 Tele.conv 1 004
10 27/09/2008 ABC 610409 Tele.conv 004
11 01/10/2008 ABC 611501 Telecon 1 005
12 11/10/2008 ABC 610700 Tele.conv 1 006
13 22/10/2008 XYZ XYZ0004028 Tele.conv 1 007
14 23/10/2008 XYZ XYZ0004086 Er.Visit 1 008
15 23/10/2008 XYZ XYZ0004086 Er.Visit 008
16 23/10/2008 XYZ XYZ0004086 Er.Visit 008

Vezerid,
Take above example and after using your formula the result is as follows,
just go through the post what i am looking at please.
Col A Col B Col C Col D Col E Col F
Sl No Date Cust Name Cust Code Cust Ref Quote Ref
1 10/09/2008 ABC 610000-RO Tele.conv 1
2 23/09/2008 ABC 611900 Tele.conv 1
3 26/09/2008 ABC 610902 E-mail 1
4 26/09/2008 ABC 611700 Tele.conv 1
5 26/09/2008 ABC 611700 Tele.conv 2
6 26/09/2008 ABC 611700 Tele.conv 3
7 26/09/2008 ABC 611702 Tele.conv 1
8 26/09/2008 ABC 611702 Tele.conv 2
9 27/09/2008 ABC 610409 Tele.conv 1
10 27/09/2008 ABC 610409 Tele.conv 2
11 01/10/2008 ABC 611501 Telecon 1
12 11/10/2008 ABC 610700 Tele.conv 1
13 22/10/2008 XYZ XYZ0004028 Tele.conv 1
14 23/10/2008 XYZ XYZ0004086 Er.Visit 1
15 23/10/2008 XYZ XYZ0004086 Er.Visit 2
16 23/10/2008 XYZ XYZ0004086 Er.Visit 3

Request you both just copy & paste my data and advise me.

"vezerid" wrote:

I assume your data start in row 4. You can use this formula in Row 4
for QuoteRef and copy.

=SUMPRODUCT(($A$4:A4=A4)*($D$4:D4=D4))

HTH
Kostis Vezerides

On Oct 31, 8:42 am, Vijay DSK
wrote:
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