Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create a series
hi all,
hello my name is Jeff, i work as a quantity surveyor in auckland, new zealand. i need a function creates a Quote Number everytime i click at a command button. as sometimes we double the quote number. and if there are anyway to check if there are some Quote Number that was double. example is if dn5555 has appeared twice in column A. Example below Cell Value A1 dn0001 A2 dn0002 A3 dn0003 .. .. .. A9999 dn9999 thanks in advance. appreciate any help. cheers. Jeff |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
create a series
Hi Jeff:
in A1 enter: ="dn" &TEXT(ROW(),"0000") and copy down the column. all the Quote Numbers will be pre-made. Then just use column B to indicate which numbers have been use or the date they were taken or any other information of interest. -- Gary''s Student - gsnu2007 "Jeff" wrote: hi all, hello my name is Jeff, i work as a quantity surveyor in auckland, new zealand. i need a function creates a Quote Number everytime i click at a command button. as sometimes we double the quote number. and if there are anyway to check if there are some Quote Number that was double. example is if dn5555 has appeared twice in column A. Example below Cell Value A1 dn0001 A2 dn0002 A3 dn0003 .. .. .. A9999 dn9999 thanks in advance. appreciate any help. cheers. Jeff |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
create a series
For creating sequential numbers:
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html To check for duplicates: http://www.cpearson.com/Excel/Duplicates.aspx In article . com, Jeff wrote: hi all, hello my name is Jeff, i work as a quantity surveyor in auckland, new zealand. i need a function creates a Quote Number everytime i click at a command button. as sometimes we double the quote number. and if there are anyway to check if there are some Quote Number that was double. example is if dn5555 has appeared twice in column A. Example below Cell Value A1 dn0001 A2 dn0002 A3 dn0003 . . . A9999 dn9999 thanks in advance. appreciate any help. cheers. Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How create a formula series with series inside | Excel Worksheet Functions | |||
how to create a series of numbers | Excel Discussion (Misc queries) | |||
Need to create a series of dates across a row | Excel Discussion (Misc queries) | |||
create an autofill series! | Excel Worksheet Functions | |||
How do I create a weekly series? | Excel Worksheet Functions |