This presumes that there will be at most, only a single order per any cust
per date

Cust Nos are assumed running in D4 down
In E4: =IF(D4="","",TEXT(COUNTIF(D$4:D4,D4),"000"))
Copy E4 down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---
"Vijay DSK" wrote:
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